Monday, February 20, 2012

limit per user/per db

Hello
I know that SQL 2000 has no way to set a limit for connections,
transactions memory or cpu per user or per db... but, there is a third
party software or any method that would allow a sysadmin to limit a
single db or a user?
ThanksWhat about ALTER DATABASE and the SINGLE_USER or RESTRICTED_USER options ?
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

No comments:

Post a Comment