FYI. News for you guys the problem has gone away by itself. Our database adminstrators could not find any locks during the time when problem was happening.

It is hard...

There is no process blocking.

Locks are mostly based on query inside stored procedure and I already pulled whole of the query stuff inside SP as it is, just I needed...

Please first tell me. Are you currently using SQL Server Yukon?

Here is the answer to your question with assumption of SQL2K in use.

Create...

I searched whole of MSDN and its release contents online but couldn't find it. I also suspected for release label as SQL Server 2005 but there was none.

Usually MS releases...

I monitored Target server Memory and Total server Memory when the system reached idle state the two are equal and staying at higher limit 1629MB. As per Brian's suggestion I...

Glenn & Charls

I am using one of such stored procedure which takes XML doc as input and insert records in various tables. Till yesterday it was working fine with response...

CHECK IT OUT

Create trigger dbo.bkiTriggerTest_Instead

      on dbo.bkiTriggerTest

      INSTEAD OF INSERT

   AS

 -- TRIGGER GETS CALLED FOR EVERY INSERT STATEMENT. ONE ROW AT A TIME

   set nocount on

   insert into dbo.bkiTriggerTestDups (i2.pkid,...

Thanks for all you guys to participate in resolving this subtle query. I got my result from you valuable inputs.

Special thanks to Mike McMahon and Vijay JDV for actively posting...

I cannot use self join as the table TestTbl is a result of a very complex query and I plan to replace TestTbl with the complex query in the final...

David,

Just use if @@rowcount = 0 condition in your instead of insert trigger just before the actual table insert statement. This will avoid failing statements as well as log the...

Any clue how to tweak SQL Server settings for query timeout.

Thanks Andy.

Unfortunately this error is not related to hardware as it happens in various testing environments but randomly. In fact I found on internet lot of people facing this...

You can also use.

DBCC TRACEON (1204)

or

SQL Profiler

Follow BOL "Troubleshooting Deadlocks"

From MSDN

PAG: db_id:file_id:page_no;

So you know your database and file segment in database. So now you know at least list of tables which are in the file segment by looking at...

Dale-

Does this mean SQL Server (single instance) may also be listening on more than one ports? I was in impression that every instance of SQL server start on different port...