I'll be honest have never bothered to try:-) ADO, using either GetChunk/AppendChunk or the Stream object is a much better way to go.

Andy

Normally you'd put it in a text column. The easiest way to do that is via the ADO stream object. Depends on what you're doing whether or not using a...

Try sysproperties. An easy way to test is to use EM to design a table and near the bottom enter some text for the description and save. Also whenever you're...

Sure. The trick is to get the data into a steady state for a few minutes. Disconnect all the users and do a backup. Restore the backup on the other...

There is an option to script it all out. Try right clicking the publication in SQL2K. Then just change the DB name using search/replace.

Andy

I think the thing to do is ignore replicaton for the moment and see what it takes to get FTP to work. Consider asking your network admin for assistance, could...

It does. Its a feature new to SQL2000. Prior to that you had to work at it - I've got an article posted that offers a fairly straight forward method...

SQL Compare. License for single user is very reasonable. Not hard to justify the ROI.

Andy

Sounds like fun. Maybe a little trickery via the Subst command in the OS?

Andy

Take a look at dbcc shrinkfile.

Andy

From what I heard at Pass ADO.Net using the SQL provider uses TDS directly and is supposed to be very fast. Will be interesting to see. I'm hoping to tackle...

Steve is right on the money. Scripting is a great example of something that DMO does far better than you ever could with ADO.

7DMO is an object model just...

Hi Bill,

Sorry for the late reply, was out of the office for a few days. It'll be another day or two before I get a chance to look into it,...

Maybe you could post the code that is doing the initial select and the refresh?

Andy

You're using SQL2K? If you only have one log file for the db the easiest way to get cleaned up is to detach the db, delete the log file, then...