save a script as a stored procedure???

[mbair]

I have several scripts that I run once a week. They drop tables and manipulate data. Write now the scripts are just in notepad and I copy and paste them into query analyzer. Can I just make stored procedures out of these scripts???

 

[JamesLean]

Yes. Look up CREATE PROCEDURE in BOL.

--James

 

[mbair]

thanks

 

[SQLBill]

Also, when you create a script in notepad make sure you save it as a .sql file and not a .txt file. Then you don't have to copy and paste it...just open it in Query Analyzer.

-SQLBill

Posting advice: FAQ481-4875