LOL, dropping the server is good.

We've tended to use multiple people to move servers now that most of us are past the 20 something stage. Felt embaressed to use...

Thanks and I'll have to look around. AFAIK you can't manage processes inside SQL Server (yet). The resource governer is SS2K8 is very exciting for me. I've been asking for...

Wow, more responses than I expected.

I think privacy is important. Maybe the definition of privacy needs to be changed and maybe our idea of what to expect should be altered,...

Have you looked at Reporting Services? It's free and easy.

If you are scripting, and you have some code, I used to use Active Reports and it worked great.

Agree with Bob. Keep the RI, prevents errors with triggers as code changes.

Tend to agree with Erik's advice myself.

I will say that some of the research from MS on very large DBs has been splitting off entire objects (data + indexes) into...

Good point. I hadn't thought about them trying to compete by removing Google's advantage, but it makes sense.

If there are alpha codes, wouldn't "< '9999'" work? Alphas should order above that. Might help it slightly,

I believe it's distributor, publisher, subscriber order.

Some of this changes in SQL Server 2008 with resource governers that can limit work in other areas, but I don't think you can specify affinity for a specific process...

And here I was going to give some fancy T-SQL to check and then fail the step if it was a Sat.

Nice solution, sql_junkie!

You can trace the purge with Profiler and see if things are removed or moved. That would be handy to know.

Indexes might need rebuilding to remove fragmentation in either case....

select e.empname, d.departmentname, '', ''

from employee e inner join department d

on e.emp_id = d.emp_id

union

select e.empname, d.departmentname, p.ssn, p.dob

from employee e inner join department d

on e.emp_id = d.emp_id

inner join person...

I like Markus' advice. It's a workaround and will get things moving. The other thing you can try is create the login yourself and then see if you can get...

I think 64-bit will soon be the norm, so for new installations, upgrades, new servers, etc., I'd look at 64-bit. There are so many limitations with 32-bit, not the least...