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
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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy