SQL 2000 has more trigger options, but I'm not sure there is any other difference.

Steve Jones

steve@dkranch.net

I had something like this. With only about 1.2GB of databases on a server with 2GB, I had SQL Server increase to 1.7GB and hold there over a few months....

Active Active refers to the two SQL Servers that form the cluster. In this mode, each serves it's own clients as well as being part of the virtual server. Or...

Is this W2K srever? There are some issues with installing 6.5 on 2k. There is a wokraround on Technet somewhere.

I'd stick with v4.0 or run SS2K in 6.5 mode.

Steve...

We used to use a tool from Quest Software. It had a high learning curve and takes time to use. They are alos Expensive $$$. You can rent them, but...

Strange. Never seen anything like this and I use SQLAgent all the time. Antares has a reasonable explanation that I'd buy.

Steve Jones

steve@dkranch.net

It seems like you are looking for whether it's better to put logic in a trigger or place it in a stored procedure. I'd tend to argue there is no...

Ouch ,

no, this actually occurred two weeks ago on a Wed. I succsessfully moved everything over and ordered a new RAID controller the next day. We were...

Agree with Andy, use DTS to move the data only. You might have to mess with it to get the parent child data to go in the right order.

Steve Jones

steve@dkranch.net

Brian is correct, DNS has nothing to do with Ports. DNS is a name resolution srevice. It gives back an IP for a name (and vice versa). You can specify...

the two screens are both your desktop. You configure in Control Panel | display the orientation (up/down, side to side). Your mouse then moves easily as if it were one...

Good point, though I'd be sure I had these two on another server as well. Wouldn't have done any good in this case to have them on the local drive.

Steve...

Let us know if it works and the outcome.

Steve Jones

steve@dkranch.net

You can use bcp and xp_cmdshell to export it.

You don't need a temp table, though that might be easier. you can make a real table and add a SPID column....

You can use SQLAgent to do this on SQL Server.

On NT or W2K, you can schedule an ISQL query with the "Scheduled Tasks" or "At" command.

Steve Jones

steve@dkranch.net