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...

Wow, this has gotten a little crazy, so a few comments and I hope everyone calms down a bit. I wish I had seen this forum a little sooner and...

I tend to agree with Lowell that if you need a flexible design and might have changes, it makes some sense to add a "Breeders" table and link people to...

It's the same as any other index, just with more columns. However, as Sergiy suggested, you might want to read up a little and better understand what you're going to...

If the problem is widespread, I don't see any great way to reorder them except by dropping and recreating.

However, if you don't have many indexes, why not just add...

Good for MSFT! Glad they have the domain.

I think we're sidetracked off my original aim. Not so much that we give them a better editor or OS, but maybe there's...

Very amusing from my Texas colleague above.

And good points made. However the poorest 90% is a spectrum of people. Some have food and electricity. Some have clean water. I'm amazed...

Can you post some sort of sample data that you'd want to see?

It's a security issue for the most part. Check logins and you might need to re-add the new groups (as new domains). IT might reach down into users, but I...

Scripting is the best bet, but you shouldn't use user permissions. Use roles.

As you script things out, create a role on the new server and give it permissions and then...

Will,

Not really digging through too hard, but this line caught my eye

OFF_COD between '0000' and '9999'

Are there other values? This seems like a strange join condition. Can it be <...