A little late, but I think whether or not the developer provides the table scripts, or even other object scripts, they definitely have to provide the NAME of the object...

You can use scope_identity() to get the last identity value. How are you getting these records? Are they all bulk inserted? Are you splitting data from a central source?

Typically I...

I'd like to see it as the default for some files. Like SQL Server files. Adding this option to Express, AND making it the default, would make things more secure....

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...