artful at rogers.com
artful at rogers.com
Tue Oct 3 18:43:01 CDT 2006
Save = Save As, which is to a script. Assuming that your script begins "Create Procedure XXX" then just execute it, then select the Sprocs node and press F5. You should see it then. hth, Arthur ----- Original Message ---- From: Jim Lawrence <jlawrenc1 at shaw.ca> To: dba-sqlserver at databaseadvisors.com Sent: Tuesday, October 3, 2006 8:37:48 AM Subject: [dba-SQLServer] Saving stored procedures Hi All: This undoubtedly will appear to be a silly problem but I do not seem to be able to get past it. It may be the late night or something. I am working in SQL 2005, in SQL Server Management Studio. I have just created a new Stored Procedure, tested it and now want to save it. It can be stored to any directory but does not save the results to the Stored Procedure list. There is something very simple that I am missing but at this late hour have no idea and the help files do not. All that is needed is for the new SP is for it to appear/stored in the list. TIA Regards Jim _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com