Help 51000 Error Message.
Michael Owsiany
Things to check:
Is database in single user mode?
What # of user connections are defined for the server?
Rob Michel wrote in message ...
>Hello,
> I am rather new to MSSQL. I am troubleshooting a SQL 6.5 with no
Service
>Packs installed. When two users are logged in at one time, only one can do
>queries at a time. If both do queries, one gets the queries, and the other
>just times out. I've found errors of 17824 and 1608 maybe once or twice a
>day. I'm still investigating now, however I am getting an error message in
>the error log that no one seems to know what it is. I've checked Technet,
>and the MSSQL manuals with 0 results. If you know what error 51000 severity
>10 state 1 is please let me know. It occurs every other line in the error
>log. Any help is much appreicated.
>
>Thanks,
>Rob Michel
>rami...@emial.msn.com
>
>
>
Jeff Jones
Any error message over 50000 is a user defined error message and was
probably implemented by another programmer. You can use Enterprise Manager
to check all error messages in the system. Go to Server, Messages, and
search for the message in question.
Verify that the database is not set to single user mode. You can so this
using Enterprise Mansager. Right Click on the database and choode edit.
The options tab has several options, one of them is single user mode.
Good Luck,
Jeff Jones
a-jj...@microsoft.com