If you're using SQL2K you could just change the collation to match the old one.

Andy

You cant use the results of a stored proc directly in TSQL (ADO is often a better choice for these types of things). The easiest way to do it in...

We keep ours local, data on fibre. Nice and simple, plus good separation if you're having a problem with your storage.

Andy

I'd vote for the SQL dump to disk as well. Easy and reliable.

Andy

I've got some sample code posted in an article http://www.sqlservercentral.com/columnists/awarren/dmointro.asp that you may find helpful, plus a couple other articles on DMO, including one about how to restore.

If...

Sorry we didnt get back to you in time. If you're connecting to a server via Query Analyzer to do the restore, it's pretty much like you're standing in front...

If you're familiar with DMO you can manage logins (and a lot of other stuff) that way - the object model pretty much maps to Enterprise Manager. If you just...

Does sound like prepared procs. Mostly went away with SQL 7. Been awhile, but I think the box in the dsn dialog is grayed out. Might take a look at...

I havent seen anything quite like that, but how about this:

1) Script the tables you want to copy into a new db.

2) Use the designer to build your package.

3) Edit...

I suspect this is a DCOMCFNG problem. I've run into a couple similar (but not DTS) situations recently that have me scatching my head. Been doing some reading, but haven't...

Unless you're short on disk space, I wouldnt sweat the size. Definitely keep auto grow on. We had a recent thread along similar lines:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=499&FORUM_ID=5&CAT_ID=1&Topic_Title=Recommended+TempDB+Size&Forum_Title=Administration

Andy

I would guess that you've got a value that SQL can't translate to a date. Try making a separate col that is a datetime, then update it with the contents...

How about this one:

select convert(varchar(20), getdate(), 112)

returns 20010705

Andy

Duplicating ALL the functionality of EM might take some time! Doesnt BMC sell a web based admin product? I use PCAnywhere from home to office workstation, if needed I can...

Take a look at the convert statement. Using a style of 121 will give you yyyy-dd-dd, just replace out the dashes and you're there.

Andy