SMO/RMO/DMO

• Topics

  Started by

  Posts

  Last post

• Programming the Data Conversion task in SQL Server Integration Services 2012 in C#

  I am trying to adapt C# code that configures the Data Conversion task from the code used in SQL 200…

  DdG

  2 replies

  11 years, 7 months ago

  By: bornsql

• SSIS Vs Linked Server with SQL Agent Jobs

  Dear Experts, Need advice in planning. There are tables which needs to be exported to / imported fr…

  pawana.paul

  5 replies

  12 years, 10 months ago

  By: pawana.paul

• Detach database, copy to new location, attach database

  Hello, PowerShell newbie here. I'm trying to write a PS script that will detach a database, copy th…

  brett-585458

  7 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Minimum permissions to allow access to SMO.Server.Databases.Users list

  I have a Powershell script which I would like to run using less than sysadmin permissions. It creat…

  geoffrey grierson

  7 replies

  13 years, 3 months ago

  By: SQLRNNR

• how to call excel (2007/2010) macro in SSIS Package (2005/2008)

  Hello, My situation : - Excel 2007 and 2010 MSBI - 2005 and 2008 (EE/SE) Excel based macro has been…

  pankaj.baluni

  1 replies

  13 years, 3 months ago

  By: Orlando Colamatteo

• Using SMO for 2000 servers

  Hi Friends, I would like to know how can I take full advantage of SMO scripting on SQL Server 2000…

  m--S3qU3L

  1 replies

  13 years, 4 months ago

  By: patricklambin

• sqlcmd.exe is hanging after running sql statement in inno package

  Hello, I'm write installation package using inno for ms sql script. I have the following code: …

  WaitingWonder2

  1 replies

  13 years, 5 months ago

  By: Orlando Colamatteo

• Using SQLCMD script in SMO

  Hello, I have a C# program which uses SMO to submit tsql to SQL Server 2008 R2 for execution. The t…

  apatel903

  2 replies

  13 years, 6 months ago

  By: apatel903

• Process profiler log in C#

  I am in charge of migration DB from 2k5 to 2k8 One of tests to check that all functionality works s…

  sqlrand

  1 replies

  13 years, 6 months ago

  By: SQLALX

• Script difference between two databases

  I need to compare two databases and update one of them. Suppose a table "Table A" is available in b…

  thulani.moyana

  12 replies

  13 years, 7 months ago

  By: oughtsix

• Schedule SQLExpress Backup using SQLDMO

  is it possible to Schedule SQLExpress  Backup using SQLDMO?SQL Express does not support SQL Ag…

  k-346900

  2 replies

  13 years, 8 months ago

  By: AlexGreen

• sqlparser parseresult - How do you parse?

  I was looking for some sample code to figure out how to effectively use some of the classes in the …

  Babu Mannaravalappil

  6 replies

  13 years, 9 months ago

  By: Babu Mannaravalappil

• Powershell for data transfer from non-SQL Server database

  I have a tool that uses SSIS and stored procedures to extract data from a non-SQL Server database (…

  mcginn

  1 replies

  13 years, 10 months ago

  By: patricklambin

• SMO performance issues!

  Hi guys! I've used SMO in some my latest apps but I am really disappointed with performance! It is …

  Betim Drenica

  7 replies

  13 years, 10 months ago

  By: patricklambin

• smo table script generation performance problem

  Hello, I'm currently working on program for database compare. In this program I need to create scri…

  kanasz.robert

  2 replies

  13 years, 10 months ago

  By: patricklambin