December 9, 2007 at 9:07 pm
Heh... good ol' Microsoft... I just completed installing 2k5 Dev and I'd first like to say something about the interface... WHAT A PIECE OF CRAP!!!!
Ok, I've got that out of my system. 😉
In SQL Server 2k, in Query Analyzer, you used to be able to right click on a table and tell it to gen the script for the table. Yes, I know you can still do that in 2k5... but how do you set the scripting options? That doesn't appear when you right click anymore. I'd like to suppress things like the object header and collation, etc, etc.
Thanks, folks...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 10, 2007 at 12:23 am
Unfortunately, there isn't any option to set scripting options for the selected object. You'd only have to take what the SSMS gives you by default. However, you can change these default scripting options through Tools > Options > Scripting.
Scripting options can also be set when generating scripts by right clicking on database > All Tasks > Generate Scripts.
Apparently, you would be surprising to see some useful features disappeared!!!:D
--Ramesh
December 10, 2007 at 1:48 am
Ramesh (12/10/2007)
Apparently, you would be surprising to see some useful features disappeared!!!:D
Heh...you've got that right...
Thanks for the info, Ramesh... add one more chunk... the scripting options you told me about are not available on the raw install... you have to install the latest service pack for them to appear on the menu. I'm happy to see that there are actually more scripting options... 🙂 First thing I've seen them do right on 2k5 yet.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2007 at 3:28 am
:hehe: Glad to see I was not the only one to discover this feature or is it lack of Feature.. and you will also find that if you don't install at least sp2 you will not be able to use custom reports which is a great feature
CodeMinkey
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply