Related topics

How to delete a SQL Login with SQLDMO
Ho aperto le cartelle ed ho aperto la sezione SQLDMO dato che contiene del codice interessante. La prima cosa č il login. il codice di seguito riportato č preso fedelmente dagli esempi MS Private Sub Form_Load() On Error GoTo ErrorHandler Dim oSQLServerDMOApp As SQLDMO.Application Dim i As Integer 'Use the SQL DMO

SQLDMO.DistributionDatabase2
Tibor Karaszi ti...@cornerstone.se microsoft public sqlserver programming Mark, I don't know if SQLDMO exposes this (use ExecuteWithResults if not): I'd look in the backup-history tables in the msdb database. It keeps history for each executed backup. There are 4 tables that holds this information, and the tables

Problem Referencing SQLDMO COM object
That is a great article to get SQLDMO events working in .NET, and it has come in handy. But I'm not clear on how this explains the binding issues I am seeing in VB6. As I mentioned, the code works fine in VB.NET. In VB6, the restore object rejects the SQLServer object sent to it when the SQLServer object is early

Estado del SERVER
"Mingqing Cheng [MSFT]" v-min...@online.microsoft.com microsoft public sqlserver programming Hi Michael, From your descriptions, I understood that sqldmo's DLL could not be registered on some of your machine. Have I understood you? If there is anything I missed, please feel free to let me know:) First of all,

da 2005 workgroup a MSDE
I am receiving an exception "QueryInterface for interface SQLDMO.NameList failed" for the following C# code. The code worked previous to rebuilding Visual Studio 2003, the SQL server and applying the sql2ksp3 update. SQLDMO.ApplicationClass sqlDmo = new SQLDMO.ApplicationClass(); SQLDMO.NameList netServers = sqlDmo

SQLDMO with win 9x
NET code to do a publication and a pull: Dim objServer As New SQLDMO.SQLServer Dim objTransPublications As SQLDMO.TransPublications Dim objTransArticle As New SQLDMO.TransArticle2 Dim objTransPullSubscription As New SQLDMO.TransPullSubscription2 Dim objReplication As SQLDMO.Replication Dim objSubscriber As SQLDMO.

SqlDmo.DetachDb
Did anyone work with SQLDMO in C# in VS.Net? I created a wraper (Project->Add reference->COM->Microsoft SQLDMO), and then I wrote the following code: serr I remember reading some issues with SQLDMO and COM interop: http://discuss.develop.com/archives/wa.exe?S2 =dotnet&L=DOTNET&q=sqldmo&s=&f=&a=&b= (watch out

Weird SQLDMO Problem
SQLServer") Set db = CreateObject("SQLDMO.Database") Set objTrigger = CreateObject("SQLDMO.Trigger") Const sDrops As Integer = 1 Const sIncludeHeaders As Long = 131072 Const sDefault As Integer = 4 Const sAppendToFile As Integer = 256 Const sBindings As Integer = 128 Const SQLDMOScript2_NoCollation As Long

HELP - SQLDMO Problem
Ken n...@invaliddomain.com microsoft public sqlserver programming I'm not sure what the error means, but this is the directory structure I used when deploying SQLDMO to Windows 2000 and XP PC's. Some may be unnecessary, but should give you something to compare with: System folder (\%windowsroot%\system32 on the

SQLDMO error in .NET
Is there anything equivalent to SQLDMO in dotnet? I haven't been able to find it. VS .Net Server Explorer provides a user interface. Does it use SQLDMO or does dotnet have its own functionality? Thanks - Rich F. -- Richard J. Fowler Nugget Software Incorporated richardjfow...@msn.com MCSD, MCDBA, MCT.

how to use sqldmo.bulkcopy to exportdata(MS SQLServer)
InvalidCastException' occurred in 10-04- 30_SQL_DB_Conversion.exe Additional information: QueryInterface for interface SQLDMO.NameList failed. Any ideas? Click Dim i As Integer Dim oNames As SQLDMO.NameList Dim oSQLApp As SQLDMO.Application oSQLApp = New SQLDMO.Application() oNames = oSQLApp.

SQLDMO Installation
Seguí buscando en Internet y encontré este instalador especifico de SQLDMO y me funciono muy bien o por lo menos con los comandos que utilizo en mi aplicación. Por si te interesa la dirección es http://www.ag-software.com/DownLoad.aspx?DownLoadID=3. Saludos, Gerardo Mejicano "Adrian D. Garcia"

restoring database using SQLDMO
I used SQLDMO.DLL AND SQLDMO.RLL as my project references. But the utility can't automatically includes sqldmo.dll and sqldmo.rll so I included manually sqldmo.dll and sqldmo.rll in my setup packages. And I installed at user's computer(WIN95), User's computer can include sqldmo.dll and sqldmo.rll, but sqldmo can't

hOW TO: CREATE SCRIPT FOR INDEXED VIEWS WITH SQLDMO
Option Explicit Sub main() Dim oSQLServer As SQLDMO.SQLServer Dim oDB As SQLDMO.Database Dim oSQLObjList As SQLDMO.SQLObjectList Dim oDbObj As SQLDMO.DBObject Dim oTextFile Dim ObjectsCount As Long Dim i As Long Dim ScriptFileName As String Dim SQLServerName As String Dim ResultPath As String Dim oFS As Variant Dim

distributing SQLDMO
I am trying to determine if SQLDMO is installed. If it is, my installation script will not install it, otherwise, the installation script will install SQLDMO. Just finding a file (like sqldmo.dll) is not sufficient. The file must exist and must be registered properly. Thanks for the ideas though. mcpoo "Andrea

Start SQL agent Service using SQLDMO
Regards PerL On Wed, 31 Aug 2005 23:27:48 +0200, Per Larsen <perl.n...@tiscali.no> wrote: Dino Buljubasic wrote: Hi, I am using SQLDMO in my application to create data tables, full-text catalogs and jobs to populate the catalogs. My datatables are created successfully but I get error on line where it says : Dim

Problems using SQLDMO to access SQL Server 7.0
SQLServerClass sqlServer = new SQLDMO.SQLServerClass(); sqlServer._SQLServer2_LoginSecure; sqlServer.Connect("ns51.zabco.net"); "Mark Olbert" Table2Class(); // next line blows up now, but didn't used to SQLDMO.DBObject theObj = (SQLDMO.DBObject) theTable; scanDatabase_Click() is a menu item handler. - Mark.

distributing SQLDMO
Poked around in the codeand got this to work: SQLDMO.SQLServerClass sqlServer = new SQLDMO.SQLServerClass(); sqlServer._SQLServer2_LoginSecure = true; sqlServer. _Table theTable = new SQLDMO.TableClass(); theTable.Name = "Products"; // next line blows up now, but didn't used to theTable = sqlServer.Databases.

Client-Side SQLDMO Programming in VB - Can't register SQLDMO ...
There are 5 similar alerts referring to different scripts but they all have the same error of "Unable to create automation bject 'SQLDMO.SQLServer'" We are running MOM 2005 SP1 and SQL 2000 and this box is our global management server. I have read on other discussion boards about backwards compatibility but they

SQLDMO QueryResults Object In VBscript
SLE f...@mail.com microsoft public vb general discussion Has anyone tried to use SQLDMO objects with events? Declaring eg a SQLServer object with the WithEvents keyword results in various 'crashes': [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION Removing the 'WithEvents' works fine, but, hey,