If you look at method 2 on the KB article (towards the bottom) you will see an SP called sp_help_revlogin_2000_to_2005. It includes both CHECK_POLICY=OFF and setting the default database.

I...

The TRACE_PRODUCE_BLACKBOX option is specifically for unexpected shutdowns. It has a running trace where it keeps the last 5 mg at all times. So after an unexpected shutdown you...

Most of the comparison tools I have seen don't require a dirrect connection between the 2 servers. As long as the machine running the software .. say your development...

The times I have seen that happen it was because the server used to have 1 name when SQL was installed and the server name was later changed.

Try this

EXEC sp_dropserver...

I am not 100% sure but I belive that you can not change system tables in 2005 like you could in 2000.

That being said I'm also not sure...

I don't know if this is exactly what you are looking for but there is an option on a trace called TRACE_PRODUCE_BLACKBOX that records the last 5mb of trace information...

Well the decision on FULL or SIMPLE recovery is going to be a business one. Right now if you have a crash on Friday you are going to have...

Given the amount of space you have free on the D drive your DB would just about have to double in space to cause a problem. I wouldn't worry...

Well based on the fact that your DB is set to simple recovery and you have 1.5 gig in the transaction log if you run out of space on the...

Sounds like a description of Quantum Mechanics to me 🙂

Have you tried removing the size restriction on the db1 database? It may not be the solution but its certainly the first thing I would try.

It looks...

I always thought the decision to agragate on NULLs made perfect sense. I can't think of the number of times I have needed a count of how many times...

I'm not sure about system tables but you can create DDL triggers in 2005. So you can easily create a trigger that runs any time a table is created,...

Assuming your company will let you I would go ahead and switch over to the 2005 tools. You can interface with 2000 just fine with the exception of DTS....

One really nice feature of SQL Profiler 2005 is that it will let you export the script trace definition to a script for SQL 2000 or 2005.

Generate your trace using...