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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-07-31 : 10:50:30
|
| Hi, I got an Severity error in alert: 019 - Fatal Error In Resource.the mail says:DESCRIPTION: Error: 1204, Severity: 19, State: 1 The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.COMMENT: (None) JOB RUN: (None) Thanks!!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-31 : 12:58:40
|
| You should probably consider installing more RAM. If this is SQL 7.0 or 2000 and you haven't modified the default configuration, then all that you need to do is add more RAM.Tara |
 |
|
|
|
|
|
SQL server alert