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 |
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
 Posted - 2008-09-09 : 15:35:53
|
| Does SQL Server 2005 have a way to place limits on query execution by user login?For instance, setting a particular user's priority as low, or automatically timing out after 60 seconds?Boycotted Beijing Olympics 2008 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-09-09 : 15:58:14
|
| I know Oracle has a suite of things you can limit bu login, but I think you have to wait until SQL 2008 for such things on the Microsoft side. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-03 : 07:22:59
|
| sql server 2008 has resource governor, I don't think we have anyhting in sql 2005 to limit resources for logins |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-03 : 07:37:03
|
| no it doesn't have anything like that. i was looking for something like this too but haven't found it yet._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
Limit queries by login