One thing you are forgetting about, at inches apart (on a motorway) whats happens if the car in front has a "blowout"?

There will always be too many variables, like how...

or sp_who2 'active'

this is why stored procedures are good... You GRANT access to execute the procedure, but no permissions are given to the base tables 🙂

haha, confused my parameters... Opps... SORRY

Taken from http://www.sqlservercentral.com/blogs/robert_davis/default.aspx

Configuring Kerberos and Constrained Delegation

I've rambled on enough about what kerberos is. I want to get into actual problems and how to fix them, but there's one more...

Try this site

http://clintboessen.blogspot.com/2010/04/working-with-spns-and-sql-server.html

A screen shot of the results from the setspn (in CMD) and a screen shot of the SQL Service account in AD would be useful

State 16 means that the user does not have access to the requested database

Comments 1 & 3

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

This one question I have always wanted an answer to as well. In some environments, where OS drive space is limited, I can see the point.

If you have the...

anything else?

or build the date into the filename of the backup file. Much easier than trying to get the "modify date" from xp_cmdshell

Next features I am hoping for are

-load balanced SQL Server(s)

-the SQL OS 😀 (basically a single install, stripped down OS, including SQL, optimized for SQL)

Well I must admit that I most places that I have worked for have had VERY poor capacity planning. Most cannot see past the end of the week. Its actually...

must agree... guaranteed 0 data loss is not possible, there are always cases/situations that will break everything.

However a maintenance job is not going to come anywhere close to giving...

Swiss Alps

:w00t:

Virtualization technology is good and can be good enough for most systems. The problem is how it is managed and administered, in this way it is the same as SANs....