O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required