SQL Server 7: Error Msg - Error: 1222, Severity: 16, State: 50 Lock Request Timeout period exceeded
Balwinder,
Frankly this is more a guess than anything else, but I suspect that your
application might have the LOCK_TIMEOUT specification set somewhere in it.
Additional information on the setting can be found in the section "SET
LOCK_TIMEOUT" in the SQL Server 7.0 Books Online.
Re: tracing ... you might consider reading up on the SQL Server Profiler
which can let you track long running queries. Again, documentation on
Profiler can be found in the SQL Server 7.0 Books Online.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:
> Hi,
> I am regulary getting the above message, localised within a particular
> database on our server.
> I realise that this is a locking problem but how can I get more
> information about this and where it is occuring.
> I have been advised to use a trace, can anybody advise me what trace
> flag to use to be able to localise where the errors are occuring.
> Any help would be welcome
> Thank you
> -BKaur
