SQL Management Objects / SQL Server Management Studio Plug-In. Mark Gilbert BlueGranite, Inc. The Task. Create a scripting plug-in for SSMS that creates DROP/CREATE scripts like SQL Server 2000 Enterprise Management: IF EXISTS … DROP … GO CREATE … GO. Scripting with SMO.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Create a scripting plug-in for SSMS that creates DROP/CREATE scripts like SQL Server 2000 Enterprise Management:
IF EXISTS … DROP …
SQL Management Objects (SMO) are used to create the DROP and CREATE statements.
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\AddIns\SSMSScriptor.Plugin
The entry point for the plug-in
Encapsulates all logic for adding an item to the context menus
Used when the user invokes a menu item