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

mix. I touch type, but not the "right way". In 20 years, my fingers have somewhat learned where the keys are and I can type pretty well in the dark....

I like that. I think you should have some xx experience before you even take the test, like 1yr documented experience.

Steve Jones

steve@dkranch.net

Do you have a service names MSSQL$SQL2000?

Might try re-running setup, also, I hate names like this because there might be something reserved. Can you makeup some other instance name?

Steve Jones

steve@dkranch.net

I'm slightly confused as to why you need to know if the strings are longer, but that's besides the point.

If you are worried about imports, I'd make an import table...

update mytable

set myvalue =

case

when mv_dummy = 1

then "a"

when mv_dummy = 2

...

Are you having performance issues? Are there unexplained slow times? Jobs might help, but if not, then might not be a benefit.

Of course, it won't hurt, but then your window...

Can you post some DDL and your attempt?

Steve Jones

steve@dkranch.net