Here is sample code to copy the structure of a table from Northwind to Pubs and then append the data.

Dim oServer As SQLDMO.SQLServer

Dim oDatabase As SQLDMO.Database

Dim otransfer As SQLDMO.Transfer

Set...

I've never had problems with Kingston or Crucial. I see no point in paying vendor prices for RAM, even in production boxes.

Andy

Using api, it's possible to search by class id or app name. A lot of times the window caption is a good one to look for. I think the api...

Start by applying SP3! Are your tables indexed and have the indexes been rebuilt in the last few days?

Andy

I have not tried it yet. Im catching up on email, give me a day or so and I'll see what I can come up with.

Andy

I think you'd be better off importing the file first, then doing any data work. Using fso line by line is going to be slow(er) than you'd like I expect.

Andy

I've used push with good success. I let the replication wizard generate the tables, subscriber side procs, etc. Before you go the immediately updating route, you might want to consider...

Use the replication wizard. No reason at all to use the command line for replication.

Andy

I would suggest testing on a copy of the db/table before you spend a lot of time changing your replicated copy. You'll have to drop the subscription and remove the...

Im surprised that didnt work. What error did you receive from the dbcc? If nothing else, use DTS to copy your objects into a "new" db that has the files...

Mshapiro - thanks for the comment and very glad you found it helpful. I'll probably tackle a different part of DMO next month, fun to explore.

I'll admit EM is a...

Found this in redist.txt on the SQL install CD, shows while files you can redistribute freely (there are more, just DTS list presented here).

Data Transformation Services (DTS)

----------------------------------------------

File NameDescription

----------------------------------------------

sqlresld.dllSatellite Resource...

Yes it will run. Security concerns are same as always, restrict access to your tables using standard permissions, logins, etc. I'm not sure about licensing, I "think" if you've got...

If you're using SQL7 EM, you'd have to set an alias I think. Also your workstations need ADO 2.6 to work with instances without using an alias.

Andy

Are you running out of space on the drive? Do you have the db not set to auto expand?

Andy