It's not a simple process and you will have downtime.

Backup / restore will move the databases, and you can stage this to minimize time. Do a full backup, move that,...

apexsql.com (apex log tool)

Don't forget DDL triggers.

Also, please don't cross post. We scan all forums. The others were deleted.

What is the problem/error or what are looking for?

It was removed in 2005, added back in 2008.

I thought Gail was right here. Shouldn't use space for int/char if it's null, the null bitmap should carry that.

I'm not sure what you mean. Is it that Profiler in the SQL Server program group (for SQL Server 2000) isn't working?

It doesn't matter. You can use the SS2K5 version...

You should be able to connect by directly connecting to the port for that instance. So if you have a named instance, you need to set a specific port (port...

Mirroring / clustering the publisher will help you keep things going, but it's a more expensive solution.

What about merge replication? How much data are we talking about and how...

2. use xxxdb go create trigger.

Not sure on #1

FAT32 isn't really designed for large files or heavy activity. I'm actually surprised it's supported in SS2K5

I've updated the links. Some of these broke last year when we migrated platforms and these must have been missed.

I think I did miss my target with the myth, though as I think about it, giving up a liver every day for your boss might be how many of...

You can go dynamic. The SQL Browser service is what determines which port it is if you address the instance by name. So if you have a server named SUIS01...