Bug Vote for scripting issue in SQL Management Studio 2005

June 14, 2008 (Last Modified: June 15, 2008)

Back in November I posted a question to the MSDN newsgroups asking about why the scripting wizard in the new SQL Management Studio was a step backwards from Enterprise Manager. The specific issue was that for an object I couldn’t select a scripting object to generate both the drop and create commands. In Enterprise Manager you could say Scipt this object and add an IfExists then drop to the beginning before the create. I found this most helpful. In SQL Management Studio you can’t select this option. Read my post to the newsgroup here and others chimed in as well. The MS person who answered my question indicated it was as the product was designed.

Another reader added this as a bug on the MSDN Feedback center for the product. Please go vote for the bug if you want this capability back!