November 7, 2005 at 10:28 am
I finally get to work with SQL Server 2005! And all day too almost every day!
I am finding many of the common things I do with SQL Server 2000 don't work the same way in SQL Server 2005.
First difference I found today. In SQL Server 2000 I go to Enterprise Manager and script the SP I will be modifying. I include in my script a drop command, a create command, and a grant command for all the users granted execute permissions.
In SQL Server 2005 (the latest Beta version) I go to SQL Server Management Studio and right click the SP and select "Script Stored Procedure AS". It does not give me the option to script a drop command with a create command and a grant command for the permissions. The reason I do this is I want the SP to have a new create date so I can sort by create date and then script all the recently modified SP's for a rollout script.
Anyone know how I can script the drop, create, and permissions for one SP all at the same time and have it all end up in one window where I can then make my changes?
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
November 10, 2005 at 8:00 am
This was removed by the editor as SPAM
December 2, 2005 at 1:34 pm
I do an looking for information on how to do this. I was excited about moving to the new tools but after not finding some features I have come to rely on from the SQL2000 tools, I am not sure yet if I like this new IDE or not.
Along with the scripting permissions issue, does anyone know if you can script multiple objects (SPs, tables, etc) at once like in 2000? Also, I really miss the view in SQl2k that allows you to view object, their owners, and the create date on one screen. Maybe these features are there and I just have not found them(hopefully). If anyone knows any of these answers or has any suggestions on workarounds, I would appreciate it.
Thanks,
Rob
December 2, 2005 at 1:43 pm
Found this about 2 minutes after I posted the above questions. Here is how to script multiple objects and with permissions.
Right click on the database, got to Tasks and choose Generate Scripts. The only issue I see here is you can script Drops or Creates not both. I am still looking for a way to do that. http://www.windowsitpro.com/SQLServer/Article/ArticleID/47719/47719.html
I still would like to be able to view SPs by their creation date and/or owner and not have to use the filters option (which is not all that great in my opinion)
December 14, 2005 at 1:56 pm
If you open the summary window and then highlight stored procedures folder in the object explorer, the sps will show up in the summary window with the schema and date
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply