April 13, 2007 at 10:25 am
I am using SQL Server Management Studio and Visual Studio 2005 and I am a newbie.
Once connected to a remote server and database I am able to use SQL Server Management Studio to modify a table and save it. When I modify a stored procedure or create a new one and attempt to save it I get my local dialog box to save to my system with a new name “SQLQuery6.sql.” How do I cause the procedure to be saved to the remote database?
April 13, 2007 at 11:28 am
When you modify a procedure or creat a new one and you want to save this to database you need connect to server (local or remote) and execute the script that creates the proc or alters the proc whithing the database you want to create or make sure you have USE statement on top of your script.. You get the message above because you're trying to save the script as a file. So you need to execute the script. Hope that helps
Good day,
Bulent
April 13, 2007 at 1:04 pm
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply