Showing posts with label missing. Show all posts
Showing posts with label missing. Show all posts

Friday, March 9, 2012

Managment Studio Scripting options?

Am I missing something on options somewhere? With Enterprise Manager when you choose to script a stored procedure you had the option to say include a drop statement and security statements. In Management Studio I don't see these options. Just script a create OR a drop. Not both. I think this is a giant step backwards for the tool if it isn't present or can't be configured.Nevermind...I found it. It was in the Generate Scripts wizard off the database. Too bad this wasn't easily exposed from the context menu on specific object (like a stored procedure).|||

This seems like a lot of work to get a script with the options I want.

Why can't the IDE just drop script options in the query window like Query Analyzer did in the past?

managing XML with a GUI

Perhaps I'm missing something, but I'm going through a cert book for the MCTS 70-431 exam and doing the XML examples. All the examples are in T-SQL -- when I go to find the XML Schemas I've registered I can't seem to find a way to do this in SSMS ... is there a way to graphically manage XML Schema documents in SS05?

I have not done much th the xsl side of things but you can view the registerd collections under the programabilty tab and types for each database.