SMO/RMO/DMO

• Topics

  Started by

  Posts

  Last post

• ListAvailableSQLServers (SQL-DMO) deprecated

  I understand that ListAvailableSQLServers is deprecated, but I cannot find what to replace it with.…

  judy.keadle

  6 replies

  13 years, 11 months ago

  By: mrdenny

• Growth of transaction log

  someone has script to monitor a Growth of transaction log in sqlserver/ or link. thank's

  Aviad C.

  1 replies

  14 years, 1 month ago

  By: ChazMan

• SMO within SSIS Script Task - User.Drop() causes error at runtime.

  I am having issues with the following code within a SSIS package. It is designed to drop all datab…

  Scott Clark-275269

  3 replies

  14 years, 2 months ago

  By: Kenneth.Fisher

• load assembly - error

  hi, I load assembly of managedts. it's work great with the new version of sql 10.5 . but when I try…

  Aviad C.

  1 replies

  14 years, 2 months ago

  By: Gail Shaw

• update access to sql server

  I would like 'power' users to be able to run queries and update selected tables, I would prefer for…

  wendy elizabeth

  1 replies

  14 years, 5 months ago

  By: Jack Corbett

• Running .sql file using C# .Net - Accents Problem

  Hello, I have this small app to run a batch of .sql files on multiple databases. When the .sql file…

  DiegoPeña

  8 replies

  14 years, 5 months ago

  By: dmbaker

• object with managedDTS

  hi, I try to create this object, but I Had error : $obj= new-object Microsoft.SQLServer.ManagedDTS …

  Aviad C.

  1 replies

  14 years, 5 months ago

  By: Gail Shaw

• Looking for MySQL expert to Skype with us!

  We are looking for a MySQL consultant who is expert in writing conditional SELECT statements using …

  tess.vanb

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Refresh PivotTables in MS Excel 2007 with OLE Automation

  Hi, I need to update a pivot table that resides on a Microsoft Excel worksheet. I created a stored …

  sgovoni

  1 replies

  14 years, 10 months ago

  By: sgovoni

• Retreive an error for an UPDATE SQL Statement

  Hi I wrote a VB6 program using SQL-DMO. Everything works fine except I don't know how to get the re…

  animho

  2 replies

  14 years, 11 months ago

  By: animho

• Error: This cache contains no result sets, or the current result set contains no rows.

  Hi all, Does anyone know what this error means, what causes it and how to fix it?  Exception…

  jeanangeo

  2 replies

  14 years, 11 months ago

  By: SEFL

• passing parameters to a vbs file in command line

  Hi, I have a VbScript file that has oSQLServer.Connect statement using windows authentication. I am…

  coolchaitu

  2 replies

  14 years, 11 months ago

  By: coolchaitu

• SQL 2005 - SMO / DMO lockdown

  I am locking down a goverment sql database system using DOD Security guidelines. One of them calls…

  Carl McGhee

  1 replies

  15 years ago

  By: huy1002

• SMO Temp Tables

  Hi All, I created an application (VB.NET) using SMO. This application acts like SQL Server Analyzer…

  Alexander-623609

  3 replies

  15 years, 1 month ago

  By: RBarryYoung

• SQL-DMO is blocking other process

  We have an application, the application is insert a value into the database. While inserting it cau…

  karthikaug18

  4 replies

  15 years, 3 months ago

  By: karthikaug18