Not quite. The role is created which has DENY on vacations. Bob is made a member of this role. If others come along with the same situation they, too, can...

Did you follow these steps to run rebuildm.exe on the cluster?

How to rebuild the master database on a virtual SQL Server instance

Generally, yes, if you can copy off the database files (including transaction logs), while SQL Server is in a stopped state, it's relatively easy to get back to where you...

No, SQL Server doesn't restrict applications, only logins. And as mentioned, it is trivial to spoof the application name. This can easily be done using a File DSN, in which...

The License Logging Service may be disabled on the SQL Server's system or on the domain controller. However, the information isn't necessarily accurate. More here:

Description of...

You've defined 3 roles:

1) HR

2) Normal Users

3) Users who need access to the second table

You didn't specify whether or not all of HR needs access to that second table. If...

Granting permissions to individual user accounts is generally frowned upon. The reason being is that if you limit granting permissions to roles, you only need to look at one place...

Do you have any jobs that normally run between midnight and 3 AM? If so, are any of them failing? Were any new processes or applications put into place recently?...

You always have the option of setting up a trace and dumping to a trace table. You can give those who don't have sa access rights to SELECT from that...

Mirroring didn't gain full support until SP1 and since that is really new, not a lot of folks have likely implemented it in production as of yet.

Some of the versions aren't supported, true. You can't run Standard or Enterprise edition on Windows XP. However, you can run Developer, which is basically Enterprise in a specially licensed...

If role-based (or task-based) security is used as the model, then those groups would already exist and all you would have to do is add them. If your security account...

Rudy, I respectfully disagree. I think it is a big deal when someone who has had such an impact as Bill Gates does change directions as he has. It might...

True, moving on is probably a better way to put it. He's said it many times that he has planned to give away the bulk of his wealth to help...

Can you post the query you are using and possibly the DDL (Data Definition Language) for the objects it references? That might help.