I believe Lynn has hit on the issue. All versions prior to RTM usually only run for a limited time.

Haven't used it, but according to this blog (http://blogs.msdn.com/b/granth/archive/2008/09/23/relogging-perfmon-binary-log-files-to-sql.aspx), you should be able to write to other formats.

Keep in mind that shrinking will also fragment indexes, so after you shrank, you'd want to rebuild indexes, so allow enough free space for that.

Hyperbac technology, now Virtual Restore from...

You could, though it depends if there is anything missing in Sharepoint that people need in a file share, like automated process copies, updates, etc. I'm not sure if things...

I agree with Jeff and Gail, and also, change ntext to varchar(max)

You've listed a lot here, but it's not clear exactly what you did.

Did you run sp_help_revlogin (the 2000) version on the SQL Server 2000 server?

Did you then run the resulting...

Yes, you can script replication. Was it setup before this backup was made? Is this on a new server? If so, you might need that script to reset the jobs...

Thanks for the update. That's a good thing to check early on with the newer OSes.

I'd certainly like to try it with a camera on the crowd. I did one remote one for the Charlotte group and struggled to present to an empty room.

ESPN will do 20 people, so keep that in mind.

I'll throw out a $50 Amazon GC as a prize, maybe see if I can do a couple for top few.

Doh!

Edited.

It is for replication. You might need to reset this up as a subscriber, or is this a publisher?

You don't want to use a variable. Think trigger. What if multiple rows are changed?

You use some table var and then drop that into your audit table.

This help?

http://www.databasejournal.com/features/mssql/article.php/3598636/OUTPUT-clause-in-SQL-Server-2005.htm

While you can hint for some types of joins, or indexes, I'm not sure you can control join order. The optimizer looks at statistics, data sizes, and guesses what would...