Re: SQL Server 2005 and SQLDMO



To add to Mikes comments No DMO is not 100% compatible with 2005. It does
not know anything about the new features and such of 2005 but it should work
on anything that was there in 2000 with minor exceptions. SMO is what you
need to use to be able to access anything in 2005 properly.

--
Andrew J. Kelly SQL MVP


"Marc Meribi" <MarcMeribi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3FBAF2CB-FCA2-42D6-8A90-E1EAB6031B9C@xxxxxxxxxxxxxxxx
> Hello all,
> I connect to SQL server using SQLDMO to update the database and make many
> Other tasks. I installed SqlServer2005 on a test server and I got an error
> using the connect method of SQLDMO.
> Is SQL Server 2005 is 100% compatible with old SQLDMO?
> How to make it working with the SQLDMO, rewrite a whole application is
> impossible at the moment?
> All info. advise are welcom.
> Thanks
> Marc.
>
>


.



Relevant Pages

  • Re: SQLDMO -> SQLSMO
    ... dass du auch einen SQL Server 2000 damit steuern kannst. ... Ich will aber nicht die Clienttools installieren, sondern nur das SQLSMO, ... SQLSMO verwenden kann um die Funktionen aus SQLDMO zu verwenden? ...
    (microsoft.public.de.fox)
  • Re: Error 21776: After creating new login
    ... EM uses SQLDMO and caches a lot of the information you see. ... another SQL Server session is not visible to the SQL-DMO session. ... > EXEC DATA0003.dbo.sp_addlogin 'test','pwd' ...
    (microsoft.public.sqlserver.security)
  • Re: >> DMO
    ... Alex, thanks for your response. ... specific purpose of referencing server instances and database collections. ... express on vista and I was not able to reference SQLDMO objects. ... it still works with SQL Server 2008. ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLDMO und DTSPackage-Bibliotheken fehlen
    ... > Bibiliotheken SQLDMO und DTSPackage in der Verweisliste zur Verfügung ... SQLDMO und DTS vermutlich;-) ... solltest Du dabei die Verzeichnisstruktur wie bei der SQL Server ... Installation bebehalten, sonst gibts Ärger wenn ein MSDE oder Servicepack ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • SQLDMO can login user while Windows OS cant
    ... start/stop/pause a SQL Server using C# and SQLDMO. ... has no login privileged) cannot login. ... SQLDMO APPLICATION CAN LOGIN THE USER ACCOUNT AND CAN HAVE ...
    (microsoft.public.sqlserver.connect)