Not much machining on this one 🙂 Here's an image:

Scott,

a restart includes a shutdown and startup of the instance.

a shutdown and startup of the instance is not a restart.

They are not equivalent. The restart is a part of...

I added a reply. My guess is he was told to install SQL Server and set up monitoring, and like Gail's disk friend, is too afraid to ask for more...

If you don't know what monitoring is, then we likely won't be able to provide much help until you start to spend some time learning. There is no "monitoring script"...

The idea in the editorial poll was to make it easier to talk about databases, not harder. Especially with non-database people. I think you're arguing in the opposite direction.

My worst deployment support...

users and roles are in your database anyway. As Pradeep mentioned, the logins are in master, so you are good if you restore that.

If you restore the database elsewhere, but...

Did you create new logins when you restored the database on the new server and make sure those are mapped to users in the database?

Jeff has a great link there, but what's your job? What are you supposed to be doing with SQL 2005?

A couple hints,

use reverse, then charindex to find the "\" and then substring.

Yes you can sync up and you'll want SQL Server Compact Edition.

there's a sync framework to check out: http://msdn.microsoft.com/en-us/sync/default.aspx

and compact edition is here: http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx

there are lots of scripts in the Script section on this site that can help you.

you want to reuild typically not on when they were last rebuilt, but either on...

http://www.sqlservercentral.com/articles/Monitoring/67972/

http://www.sqlservercentral.com/redirect/articles/67738/

Safeco is cool. Kalen Delaney took me there a couple years ago, and we saw the roof close in the midde of an inning. The Arizona park is cool as...

We will. I'm not sure if they changed something else as they knocked off early today in the UK (Xmas party). Sending was definitely slower, so things might have been...