installing SQLDMO 2005

This article describes how to install SQLDMO 2000.

http://support.microsoft.com/?kbid=326613

Anyone know the procedure for SQL 2005?

The procedure is basically the same. You need to register SQLDMO.DLL (typically located at %ProgramFiles%\Microsoft SQL Server\80\Tools\binn):

regsvr32 sqldmo.dll

For SQLDMO to work MDAC must be installed on your machine.

Hope this helps,

Artur Laksberg

SQL Server Team

|||

If you want to redist DMO with your application you need to include the Microsoft SQL Server 2005 Backward Compatibility Components MSI. The SP1 CTP is available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae94bb12-c839-4b4f-a71b-412fb3a0500e&DisplayLang=en

RTM is available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en

DMO is installed as part of this MSI.

installing SQLDMO 2005

This article describes how to install SQLDMO 2000.

http://support.microsoft.com/?kbid=326613

Anyone know the procedure for SQL 2005?

The procedure is basically the same. You need to register SQLDMO.DLL (typically located at %ProgramFiles%\Microsoft SQL Server\80\Tools\binn):

regsvr32 sqldmo.dll

For SQLDMO to work MDAC must be installed on your machine.

Hope this helps,

Artur Laksberg

SQL Server Team

|||

If you want to redist DMO with your application you need to include the Microsoft SQL Server 2005 Backward Compatibility Components MSI. The SP1 CTP is available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae94bb12-c839-4b4f-a71b-412fb3a0500e&DisplayLang=en

RTM is available here: http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en

DMO is installed as part of this MSI.

Integrate VSS with SQL 2005

Is there a way to compare a script in Visual source safe with sql 2005 stored procedure without scripting out the stored procedure from sql? I usaually script out a stored procedure from sql to a .sql file and compare it with a script in VSS and I was wondering if anyone know a faster way to compare SPs in production server with VSS. I am using sql management studio and also added all SPs to VSS thru management studio. Thanks.

Hi,

the best application for this is the Visual Studio for Database professionals. The sources used here can be integrated with a Visual Source safe provider. You can easily compare two database /the actual project in schema as well as in the data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de