Ramesh,

I'm trying this, but getting an error that Dts "Name is not declared". I must be missing something here. Here is my code.

Imports System

Imports System.Data

Imports System.Math

Imports...

This will be very helpful to me in the future, I'm sure.  Thanks for the posting.

Thanks, Andy. Do you have any code samples or can you point me to a resource on how to check sysprocesses for connections to the db and then killing...

I am using the Andy Warren's code to do the restore, and it does not connect to any database to perform the restore, it connects to server only. Like...

Thank you SO much. It works!

It was the line: keyPKMyTable.Name = "pk_mytable" that I was looking for! 🙂

Where did you find the sql-dmo samples?

This is my experience with the sqldmo.dll on the client. I wrote my app using a reference to SQLDMO.dll version 80. Created package using P&D wizard. The...

Andy,

This field name "source_emp_id" does exist in another table, but it is not defined as a foreign key.

I have emailed you the entire trace as a txt file....

Andy,

I am still getting the error: Line 1: Incorrect syntax near dbo. I have profiled it and the code generated is as follows: The error occurs on...

I'd try profiling to see what you get with SQL7, maybe that will help figure it out.

By profiling, do you mean running on SQL7? If so, yes, I...

Andy, Here is the code that creates the table columns.

Dim tblAdvCustomers As New SQLDMO.Table

tblAdvCustomers.name = "tblAdvCustomers"

tblAdvCustomers.FileGroup = "PRIMARY"

'Create the column objects using my CreateTableColumn procedure

CreateTableColumn tbllAdvCustomers, "cust_id", "varchar", False, ,...

The key field is defined: cust_id, char, False (for allow nulls), 8

for length.

Set namesPKtblAdvCustomers = keyPKtblAdvCustomers.KeyColumns

NamesPKtblAdvCustomers.Add "cust_id"

tblAdvCustomers.BeginAlter

THE NEXT LINE CAUSES ERROR

tblAdvCustomers.Keys.Add keyPKtblAdvCustomers

I can post the code that creates the...