If you need to do something like migrate, hire a consultant. You're asking for trouble on your own.

If you want to know how it's configured, that's not an easy thing...

I assume you have other columns, correct?

You can do

create table mytable

( myid int default 0

, mychar varchar(20)

)

go

insert mytable select 1, 'A'

go

select * from mytable

go

insert mytable (mychar) values (...

I'm not sure you can control which objects go where in tempdb. I've not heard that splitting it helps. If you can get multiple drives under it, you can improve...

I thought this wasn't supported, or at least not installing SS2K later. Did you install both as SS2K and then upgrade?

Perhaps the SQL Browser is broken because its' 2000 and...

I've used Profiler. You could even capture separate traces for different users and then replay them from different PCs to simulate loads from different sources.

If you have serious auditing requirements, deleted records aren't allowed. You "mark" them as logically deleted (some flag), but you keep them around.

Worse case, you set up a table to...

The licensing, from what I've understood in the past, is that you license all CPU sockets that are occupied on your system, regardless of affinity. I tried to license a...

My experience with replication and DTS (not so much SSIS) is that they work great until they don't. Then it's a pain.

If you are worried about support calls, I'd think...

I've told someone in every interview in the last 9 or so years that I won't be micro-managed and I don't track time. If you need that, hire someone else.

If...

Very good comments and a few smiles appearing over here from the jokes.

Not that I think all british humor is bad, but I don't like the UK version of the...

I might also run a trace for that user and see if anything is happening.

Can you stop the job?

Strange.

If you need to save databases, I'd copy those, then delete the mssql folder structure off the disk. Also in HKLM/Software, delete the Microsoft SQL Server keys. That should let...

You'd have to post the code to get help on the WHILE loop. In general, any execution that includes a SELECT or PRINT will return something to the client. Other...

If you have other filegroups, you can also move the table to the other filegroup or set the other as the default.

Do not shrink the database regularly.

Herve has the only real solutions. This isn't tracked by default, so if you haven't enabled anything, you cannot go back in time.