Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2008-07-10 : 16:44:03
|
| In SQL 2005, is there any option we can set up a higher priority for certain users in a database/server?Thanks ! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-10 : 16:54:20
|
quote:
Originally posted by sqldba20
In SQL 2005, is there any option we can set up a higher priority for certain users in a database/server?Thanks !
What do you mean by high priority? Do you mean high permission? |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-07-10 : 17:04:28
|
| Not high permission. By high priority meaning lets say we have 2 users "xyz" and "abc" . User "abc" runs lots of reports and I want give user "abc" less priority (so that his reports will run slower) than user "xyz" because "xyz" user does more important work. |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-07-10 : 17:11:51
|
| No.No such thing as "process management" until SQL 2008... |
|
|
|
|
|
|
Priority for Users/Logins to process the data fast