You can set dependencies on the resources themselves. So you could set the disk resource where the logs reside where it depends on the disk resource where the database resides....

Bring up your PromptSQL options (double-click on the tray icon is the easiest way). Click on the Content tab and uncheck List databases when listing everything.

Is the SQL Server installed on a member server or on a domain controller? If it is installed on a DC, that's a whole different ball of wax. There are...

Without seeing the exact error message, a few things to check:

1) The SQL Server's time is in synch with the domain controller (within a few minutes).

2) The SQL Server sees...

I would remove it from Domain Admins. It is unlikely this level of permissions in necessary.

As to the problem at hand, are there any errors in the System event log...

1) As has been pointed out on numerous security lists, many of the big name vendors have problems with bugs and security. The list of Oracle bugs fixed in this...

I didn't take it to be offensive, just wanted to let folks know who hadn't seen the editorial and blog that Steve's in and out.

Some of those threads aren't titled such that you'd know a problem happened in them. After all, they were started to ask a question. As for this thread, Steve is...

Most accurate way is to run SELECT @@VERSION and compare the value to the list here:

SQLSecurity.com: SQL Server Version Database

Ownership chaining is broke when any of the following is true:

(1) You are calling an object with a different owner than the object doing the call. For instance, if your...

If they have log on capabilities to the SQL Server, they can see the code of the stored procedure. Take your outputted script from Enterprise Manager and run it in...

I'm about halfway through the book myself and thus far I've learned a few new things that I didn't know. Thanks, Dale, for putting this book together!

Probably a better analogy is this:

Take a car from 1930...it may run, but new cars are safer, more efficient, and have new features. Do you expect Ford to install seatbelts,...

That covers the 80-20 rule. If someone wanted to decrypt the stored procedure,

it would be fairly easy. Just execute the statement on a SQL Server they control

and then...

Is the user account you were testing with a member of the sysadmin fixed server role? If so, it maps in as dbo, the database owner, and bypasses all permission...