Using SQL-DMO with Stored Procedures
Not comfortable with Visual Basic, but you're pretty good with Transact SQL? Have you ever been writing a stored procedure and wanted to perform some administrative task during the procedure like backing up a database or exporting a table? For those of you who answered yes to any of the previous questions, Microsoft has created a set of stored procedures that enable you to invoke COM-based objects that support OLE automation (that is SQL-DMO) within a stored procedure. You can use SQL-DMO via Transact SQL or you can write your own OLE automation servers using your Windows tool of choice (for example, Visual Basic) to create components that can be invoked through Transact SQL. Creating your own components enables ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.