sqldmo

distributing SQLDMO
Thiago Almeida t...@t.com microsoft public sqlserver programming Hi, I'm having a problem with SQLDMO ScriptTransfer. I want to script all functions, stored procedures, triggers and views of a database. When I run the application (created using VB.Net 2003) on my computer, it works fine, creates the script for only

QueryInterface error with SQLDMO.NameList
Willy Denoyette [MVP] willy.denoye...@pandora.be microsoft public dotnet framework interop Yes, download and install SP2 for MSQL, and rebuild the SQLDMO interop assembly. Willy. "ericbl" <eri...@avanade.com> wrote in message news:c8a601c20cc6$949bc690$35ef2ecf@TKMSFTNGXA11... The following code: SQLDMO.

Register SQLDMO.RLL problem.
Dim oSQLServer As SQLDMO.SQLServer Dim oDatabase As SQLDMO.Database Dim oBackup As SQLDMO.Backup Dim oRestore As SQLDMO.Restore Dim databaseName As String Set oSQLServer = New SQLDMO.SQLServer oSQLServer.LoginSecure = True oSQLServer.Connect "(local)\dev" Set oDatabase = oSQLServer.Databases("pubs") Set oBackup

Inregistrare SQLDMO.DLL
"Bill Cheng [MSFT]" billc...@online.microsoft.com microsoft public sqlserver programming Hi Mark, On my side, I also cannot cast theTable to SQLDMO.DBObject type. According to my check, The DBObject object is used as a parameter to the GetObjectByName method of the Database object and the AddObject method of the

SQLDMO
SQLDMO is registered on my system and I can use the CreateObject("SQLDMO.SQLServer") in both VBScript and Excel VBA code. Also SQL Enterprise Manager works fine. SQLServer SP3a has also been applied on my system. I created the reference to SQLDMO in my project and the Interopt.SQLDMO.dll is created.

VB.net + SQLDMO = slower than VB6 !!!
Ernest Morariu ern...@gesora.com microsoft public it dotnet vb Nella finestra DetachDatabase dell'Enterprise Manager c'è un pulsante "Clear" che da la possibilità all'utente di distrugere le connessioni attive al db, però, a quanto pare, l'oggetto SQLDMO non offre un comando equivalente.

sqldmo in VS.Net question.
sql...@virgilio.it microsoft public sqlserver programming hi, "Bonj" <B...@discussions.microsoft.com> ha scritto nel messaggio news:63522AC3-9CC8-4A7F-BA66-4F050CDD0DB3@microsoft.com Hello I have recently deployed a VB application that uses SQLDMO.dll. I have read in a reply to a previous post that this was

Wanted: Help translating VB6 SQLDMO App
Item(pullsubidx); // Find the job matching the subscriptions job id SQLDMO._Job job = null; for(int jobidx = 1; jobidx <= svr.JobServer.Jobs.Count; jobidx++) { job = svr.JobServer.Jobs.Item(jobidx); if (job.JobID == sub.MergeJobID) return job; } // If we have a job check whether it needs to be run if (job !

SQLDMO Error
foon soft_f...@163.net borland public delphi database sqlservers Hi, I want to use sqldmo's bulkcopy object to exportdata from MS SQLServer2000, would u give me some advice? Here is my code, however, it raised error at the last statement. The error code is bcp error. procedure TForm1.Button1Click(Sender: TObject)

SQLDMO question...
Can I let programmers use SQLDMO under their own NT security context without giving them wide-ranging administrative privileges? They will need the correct rights on the SQL Server database they are working on. SQL-DMO was never designed to provide the capabilities with the lowest possible privileges on the

SQLDMO EnumHistory method
Hilary Cotter hilary.cot...@gmail.com microsoft public sqlserver fulltext try going to this location via a command window C:\Program Files\Microsoft SQL Server\80\Tools\Binn and type regsvr32 sqldmo.dll -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ

Listing Available SQL Servers Using SQLDMO
John Peters gr...@hotmail.com microsoft public scripting vbscript I'm trying to back up a SQL Server database using Microsoft SQLDMO. If the string assigned to SQLDMO.Backup.Files does not contain spaces, it works. If it contains spaces, I get error messages which seem to indicate that SQLDMO's interpreting the

Database utilities for Access/SQL runtime application
VersionBuild If you Registered SQL-DMO version is from SQL Server 2000 it should return 8.0.x. In which case you need to have a Registry2 object type If OleView states it is not there, my guess is you have multiple copies of SQLDMO.DLL and the 7.0 version is registered instead of the SQL Server 2000 version.

SQLDMO: Access Violation...!
Click Dim app As SQLDMO.Application Dim nl As SQLDMO.NameList Dim ii As Integer app = New SQLDMO.Application() nl = app.ListAvailableSQLServers() For ii = 1 To nl.Count ListBox1.Items.Add(nl.Item(ii)) Next ii app = Nothing nl = Nothing End Sub How do I translate this to J#? Here is my attempt, but it does not like

SQLDMO and SQLObjectList -- Unable to refer to a specific item
Vorab: Für so etwas muss es nicht unbedingt SQLDMO sein, Prozeduren oder auch ADO OpenSchema oder aber Verwendung der INFORMATION_SCHEMA Sichten sind da meist schmerzfreier. Mir würde es nie in den Sinn kommen, bei SQLDMO in grösserem Umfang QueryResults einzusetzen. Problem: Nach der Verwendung des

SQLDMO.BulkCopy
Net noch installiert werden, damit die Bibiliotheken SQLDMO und DTSPackage in der Verweisliste zur Verfügung stehen? SQLDMO und DTS vermutlich ;-) Gundlegendes dazu findest Du in der SQL Server Dokumentation zur Verteilung von DMO und DTS, die Du über Mergemodule in eine Visual Studio Setup aufnehmen kannst.

Can't run SQLDMO command from remote client Access Project
Tibor Karaszi tibor.please_reply_to_public_forum.kara...@cornerstone.se microsoft public dotnet languages csharp microsoft public sqlserver msde microsoft public sqlserver programming but (there is always a 'but'...) when playing with ADO.NET, it sounds like using a SQLDMO solution will 'open' a second connection

Database utilities for Access/SQL runtime application
Dim oQR As SQLDMO.QueryResults = oDBO.EnumDependencies(SQLDMO.SQLDMO_DEPENDENCY_TYPE. SQLDMODep_Children) The resulting QueryResults object contains the object type in column 1 and the object name in column 2. So, when I issue oQR.GetColumnLong(<Row>, 1) for a knowm UDF a value of 1 is returned This is exactly in

Alter tables and retain data is this possible with SQLDMO?
NET/C# MVP] nicholas.pald...@exisconsulting.com microsoft public dotnet csharp general microsoft public dotnet general microsoft public dotnet languages csharp BAZRAMIT, SQLDMO is use more for administering SQL server, and not manipulating data in the tables. Is there a reason why you aren't using the classes in

SQLDMO.hlp
When I try to reference the Microsoft SQLDMO Object Library 8.0 (it show in the list under the COM tab), I get the following message: A reference to "Microsoft SQLDMO Object Library" could not be added. The type library tool 'tlbimp' cannot be found on this system. Please reinstall Visual Studio.