Lots of problems here. Breaks SOX, so if you're public, this gets you an audit failure.

Time between detach and attach? Downtime for sure.

Testing? Developers can't test, or at the least,...

I'll try to track someone down at MS that can answer the "use" question.

At TechEd, in one of the tech talks, someone asked about hyperthreading, given all the multi-core options,...

Note that servers can mark themselves as "hidden" from -L and if any routers block 1434, this won't work either.

If you have SMS or someone can run a query, the...

That does sound strange. As Robert mentioned, I'd ask for more details on what you're doing in the wizard. I might even try a simple DTS package, with 2 connections...

I tend to agree with Jeff and try to create the table explicitly, then insert as needed, add indexes, etc.

I've seen so much on table variables v temp tables that...

Winston,

First of all good luck with this one. I took the 431, 441, 443, and 444 and this was the hardest one to me. It's two parts, one multiple choice,...

Not sure sp_who2 lists transactions. It lists active users. You can run dbcc opentran to see which transactions are open.

You can run profiler on a particular database to see if...

Why do you need to specify TCP: to connect? Is there something I'm missing?

You can use UTC time on both as the central time and then use an offset for local time.

Can you explain more about what the insert looks like and what...

Log in with the account used to run SQL Server (the service account). Run outlook and check the profile, be sure it can send and receive. Likely something is misconfigured...

You can break up the insert as well, use a transaction if needed, and insert in batches rather than one large statement. That could help with memory.

Interesting.

BTW, Clipper uses dBase format, so you can use those drivers.

Brandie,

What's your trigger code? Are you rolling things back?

They should work no matter what. A sysadmin doesn't override the trigger. Can you add log code to the trigger to see...

I realized that and had to recheck the question, but I don't think it implies space on the drive. The log could fill up, with no autogrow, and there still...

It definitely wasn't me and no sheep on this ranch. I was actually in Mexico, swimming with my daughter, completely unwired and enjoying the day.

I've fixed the ID, though I...