SMO/RMO/DMO

• Topics

  Started by

  Posts

  Last post

• Using SQL-DMO Transfer Object

  Has anyone used the Transfer object in association with the Database object using VB, I need to tra…

  pfd3

  6 replies

  23 years, 5 months ago

  By: Andy Warren

• Starting/stopping SQL via DMO

  How can I use VBScript (and DMO) to stop the SQL Service service on a remote SQL 7 machine, copy tr…

  Barkingdog

  1 replies

  23 years, 6 months ago

  By: Andy Warren

• sqldmo backup/restore problem

  I have the following source code to backup database: Dim oBackup As New SQLDMO.Backup Dim oSQLServe…

  wsang

  12 replies

  23 years, 6 months ago

  By: PBirch

• DMO-Job Monitor

  I schedule many jobs thru the Sql seheduler. I was looking for a way to build an APP using DMO that…

  Bruin

  7 replies

  23 years, 6 months ago

  By: Andy Warren

• ScriptType Value?

  One question, through EM I can script tables and have the primary key constraint as a separate piec…

  Michael S. Armentrout

  3 replies

  23 years, 6 months ago

  By: Andy Warren

• Which is a better way... using DMO or SPs

  Which is a better way to create database and add user logins to it? Should I use Stored Procedures …

  paras_98

  4 replies

  23 years, 7 months ago

  By: Steve Jones - SSC Editor

• create logins and assign a db to it

  How can I create a new login and assign an database to it using SQL-DMO. I am finding that confusin…

  paras_98

  3 replies

  23 years, 7 months ago

  By: Andy Warren

• Langauges that support SQLDMO Objects

  Which other programming languages other than VB allow to use SQL DMO. Does VBScript(ASP) allow COMP…

  paras_98

  4 replies

  23 years, 7 months ago

  By: paras_98

• Columns.Remove Dependancy Problem

  Hi folks, I am using the following: sqlTbl.Columns.Remove ColName and getting the error: [Microsoft…

  bigdave

  2 replies

  23 years, 7 months ago

  By: Andy Warren

• SQLDMO Redistribution

  I have used SQLDMO extensively (SQL2000) in an app I have just finished developing. I am now tryin…

  bigdave

  1 replies

  23 years, 8 months ago

  By: Andy Warren

• DMo and SQL Server Agent

  Every once in a while the SQL ServerAgent (SQL 7) stops unexpectedly. How can I use DMO to check if…

  Barkingdog

  1 replies

  23 years, 8 months ago

  By: Sean Burke

• Autodetect of SQL DMO version

  I have a software which was developed to use SQL6.5 DMO. I am in the process of upadting the softwa…

  eletuw

  2 replies

  23 years, 8 months ago

  By: Andy Warren

• Simple SQL-DMO Question

  I'm trying to use SQL-DMO to determine the size of the "northwind" database: Dim oSQLServer Dim oDa…

  Barkingdog

  2 replies

  23 years, 8 months ago

  By: Andy Warren

• Binding Default Values To Cols

  I want to create a new column with a default value. I create the column object, and the default ob…

  bigdave

  1 replies

  23 years, 9 months ago

  By: Sean Burke

• Get default database directory using DMO

  Is it possible to get the default database directory settings from an SQL Server using SQLDMO. I am…

  paulhuts

  5 replies

  23 years, 9 months ago

  By: paulhuts