Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
04-03-2009, 12:49 AM #1
- Join Date
- Nov 2008
- Thanked 0 Times in 0 Posts
proper Save location for SQL stored procedures
I saved a few stored procedures in SQL Server Management Studio. The default Save location, which I accepted, was C:\Documents and Settings\BobLewiston\My Documents\SQL Server Management Studio\Projects. (And yes, each stored procedure was in the form of an .sql file, and I assigned each file name root to be the same as the contained procedure's name.) But this Projects folder must be the wrong place, because my apps aren't finding these stored procedures.
I see a lot of .sql files in various places on my hard drive, but I can't find any by the names of the stored procedures listed in Management Studio's Stored Procedures folder (none of which I wrote). For that matter, I'm not even finding the Stored Procedures folder on my hard drive.
Where are stored procedures SUPPOSED to be saved?