Tuesday, March 13, 2007

Scripting Objects from SQL Server 2005 or SQL Server 2000 Using DMO

I wrote a stored procedure to script out database objects (functions, stored procedures, constraints, jobs) from SQL Server 2005 or SQL Server 2000. We use this at our agency for automated source control comparisons. The procedure uses DMO and is extremely fast.

Feel free to email me if you have any questions.

Here is the source code

0 Comments: