I am aware that the profiler columns do no match one to one. In the case of this problem, I could find the transactions with dbcc opentran and see...
Yes, that is the case sometimes, however in that case if it was blocked, wouldn't the SP just spin or deadlock? The RPC:Completed shows up in the...
Recently we have been experiencing a lot of blocking in our VB fat client / SQL2K application. Certain processes have "hanging" transactions which...
I am trying to troubleshoot some deadlocking issues we are having. There are a few stored procedures that are updating a table and they often...
Wow, I just spent 15 minutes writing a huge reply and I was about to post it when I read Chappy's response that covers everthing I had written!<br...
Hmmm, I think I might not have been clear. I don't want to upgrade the database server from Win2k to Win2k3, which is why I want to make sure that...
Does anyone know what the differences are between the MSDTC in Windows Server 2003 and Windows 2000? We are considering upgrading some web/app...
It wouldn't have been the SQLAgent because it worked sometimes, even when run as a job. <br /><br />However, I think I figured it out, thanks to...
I am not sure about "set to 1", but the tasks go like this: (WF = workflow, XF = transform) [change default params] --WF1--> [truncate tables]...
This is beginning to drive me crazy... I have a DTS package that fails intermittently. I constantly get a variation of the following error message:...
I recently came across an interesting problem. An application that I work on broke because data was not returning in the correct order. An ORDER BY...
Does anyone know what the 7 scripts are called that are executed during the SP3 install? One of our SP3 installs ran all the way up to the last...
I have the following table in a database: CREATE TABLE [X] ( [XGuid] [uniqueidentifier] NOT NULL , [XID] [smallint] NOT NULL , [XFlag] [char]...
You might also want to check your general connectivity from the client machine. I would try pinging the SQL server first, and then try to telnet to...
I have found that dynamic SQL can almost always be replaced by more efficient code. The problem with dynamic sql, is that you end up losing all...
You may want to check to make sure that your table statistics are updated as well. You will see drastic differences in execution plans based on the...
Separate names with a comma.
