I'm the gui one, will benifit from it the most I guess

John, I was talking about connecting to sql 2000, in which case sys tables are still there. U r right, in 2005 you'd want to use DMVs.

Just to nitpick...

Alex, I certainly agree that SQL 2005 is a new product, and a shift in paradigm. I even agree, at the risk of being strangled by other dbas, with doing...

Guys, one more thing:

How important is it to format the drives that house system databases (tempdb, master, msdb). Should that matter?

Tnks again

Awesome, thanks. Looks like it's using Reporting Services

2 different periods, millisec used by cpu and duration of the event. It's not the network nessesarily, could be parallelism and bunch of other variables.

thanks Crislis,

But I am not able to find parameters with which to specify to start the profiler.

AJ, I think it's the other way around.

Bulk Insert ADministrators built-in server role would work. But isn't this Yukon forum ?

yes i will!

thanks Chris, I guess I am confused about the naming conventions of CTPs:

"You can however use any edition of SQL Server 2005 April CTP with VS2005B2."

Do you mean like CTP...

not that I know of, you need repoint the apps to the subscriber, then rebuild the repl and repoint back to the publisher

Nope, just have the Help menu. Set Update Metjod is greyed out, there's no Delete at all.

thanks Hilary,

So to simulate the failover is it enouph to disable publication on the mail publisher?

Thanks DM