paul.hartland at fsmail.net
paul.hartland at fsmail.net
Tue Oct 3 08:37:08 CDT 2006
Jim I had the same problem when I first dabbled with this, you actually don't have to save it as far as I can remember. If you create the stored procedure, click the execute button, think this tests if all is ok...then if you refresh your stored procedure listing it should appear. Paul Message Received: Oct 03 2006, 01:37 PM From: "Jim Lawrence" To: dba-sqlserver at databaseadvisors.com Cc: 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 Paul Hartland paul.hartland at fsmail.net 07730 523179