When did this occur? There should not have been downtime?

It takes time and effort, but once you've done it, you're done. So it's a one time task and you just have to do it. There's no shortcut since it's...

From what I've always heard, you should not switch to fibers without guidance from PSS. They have a few things they examine and there are only some workloads, even with...

I have no idea, but my guess is that Microsoft is not a monolithic entity and they need a separate registration for some reason. They use Connect for beta, MVP,...

Sounds like your communication server doesn't have rights to connect. Have you checked if this account has rights in SQL Server?

I'd argue that if you are considering the move, and can wait until the fall, I'd go with 2008. There are now going to be releases every 2-3 years, which...

You can hack the system tables if you like to remove the Identity value. An MVP provided this script:

use master

-- drop database test

Create database Test

Use test

Create table exemplo (...

I never use them.

However I do end stored procs with a RETURN just for convention and to make it clear to myself that I'm done coding in this batch.

Was this upgraded? (hence Gail's question) or was it rebuilt on 2005 from scratch and has bad performance? Are the data sets the same?

Jeff hit it on the head. You have to take control and give people a chance.

There are lots of average managers out there, mostly they'll leave you alone. There are...

Please don't cross post.

handled here: http://www.sqlservercentral.com/Forums/Topic459398-149-1.aspx

Are you in topic subscriptions?

You only see page 3? Seems strange. I see a list of pages on my wide (for my account).

Send me (or post) the one you want...

Certifications in the US are $125 per exam. There have been deals a few times for second chances or retakes at no cost, but I don't know of any right...

you have to write a query that joins the tables together.

This sounds like homework or an exam question. If you show some work in writing a query, but we can...

What is the build number on your SQL Server install? Not Management Studio, but SQL Server.

Run select @@version to check.

Build numbers are here: http://www.sqlservercentral.com/articles/Administration/2960/

You don't need to install SP1 if...