Viewing 15 posts - 2,041 through 2,055 (of 6,105 total)
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...
June 22, 2006 at 11:39 pm
Did you follow these steps to run rebuildm.exe on the cluster?
How to rebuild the master database on a virtual SQL Server instance
June 22, 2006 at 11:29 pm
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...
June 22, 2006 at 11:27 pm
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...
June 22, 2006 at 11:19 pm
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:
June 22, 2006 at 11:16 pm
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...
June 22, 2006 at 10:22 pm
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...
June 22, 2006 at 10:16 pm
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?...
June 22, 2006 at 10:13 pm
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...
June 21, 2006 at 2:30 pm
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.
June 17, 2006 at 9:12 am
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...
June 17, 2006 at 9:01 am
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...
June 17, 2006 at 8:59 am
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...
June 17, 2006 at 8:52 am
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...
June 16, 2006 at 7:30 am
Can you post the query you are using and possibly the DDL (Data Definition Language) for the objects it references? That might help.
June 15, 2006 at 7:06 pm
Viewing 15 posts - 2,041 through 2,055 (of 6,105 total)