Chuck, could you show us what you're using the union for? Sometimes we can offer alternatives if we have a good idea of the problem.

Andy

A view is just a way to encapsulate a select statement or statements, gets used like a table - call it a virtual table. Clusters are for fault tolerance, typically...

This may help on the DTS stuff:

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

What error message exactly when the copy mdf fails? You're moving the stuff to another server rather than upgrade in place?

Andy

Aint every day we get network jihad and glue sniffing in the same topic! I would like to see or more articles about this stuff. I work mostly on the...

Sometimes your best bet is to just reboot.

Andy

Not officially. A while back Robert Marda came up with a solution, though I still havent tried it yet!

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2593&FORUM_ID=7&CAT_ID=1&Topic_Title=Modifying%20a%20column%20on%20a%20table%20being%20replicated&Forum_Title=Replication

Andy

Yeah, I had to work to find it! Here is the link for the download Leon mentioned:

http://msdn.microsoft.com/downloads/samples/internet/default.asp?url=/Downloads/samples/Internet/xml/sqlxml/Default.asp

I ran across this link while looking, you might find something of interest:

http://www.sqlxml.org/sqlxml/v3.2/home.xml?browser=ie

I think...

There is nothing wrong with the memory usage increasing, by design SQL will acquire and use as much memory as it can, releasing some back to the OS if needed....

I'd start by verifying that the indexes for the tables involved match exactly and have been rebuilt on the server with the slower performance. Perhaps a better way would be...

Only by logging DDL via a trace.

Andy

For the first part I suspect you have too many columns defined in the proc - if you've got an identity col on the subscriber you need to either remove...

Good, will be nice to get someone else to test besides me!

Andy

TSQL isnt a fun way to manage it. The ADO stream (or the older chunk methods) is a lot easier and more practical. There is a bulk loader tool in...

I have not seen a tool to do this either. SQL2K supports cascade update/delete in addition to foreignkeys. Easiest way I've seen to implement them is via the diagramming tool.

Andy

Not sure this is a SQL issue. Are you actually able to log into the domain from a client machine? Until you get that working you won't be able to...