July 11, 2007 at 5:35 am
Server Management Studio 2005 – Query Designer Toolbar- “Change Type” button is grayed out. Assuming that this serves the same functionality as the Enterprise Manager 2000 “Change Type”, how do I activate this button?
MISfIT
July 11, 2007 at 6:04 am
http://mssqltips.com/tip.asp?tip1086 this link might help. But check if you are following it up right.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 11, 2007 at 6:21 am
Thank you for your reply.
I understand that this functionality can still be obtained in the manner that your link provided, however this method does not seem to fit my needs. I really do not need this button option as I am sure most of us here don’t. But I do find it usefull when helping “even newer-bies”. In order to help them avoid their first Delete disaster I would have them do a Select first to be able to examine the data that they were about to delete, and then change the query type to delete. Within the Design Query Editor one is not able to execute and therefore defeats my lesson. Further I was curious as to why this button seems to have no functionality.
MISfIT
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply