Deadlock victim has no locks

Hi , Im no Kalen Delany when it comes to understanding SQLServer internals but i thought i knew a trick or two. This has got me confused though. Why has the process "process40a9ac8" been selected as the deadlock victim ? How does that ...

Message posted on the May 11th, 2009 - 6:44 AM ET

Failed Virtual Allocate Bytes:FAIL_VIRTUAL_RESERVE on 32-bit SQLSe

All, We have a 32-bit SQLServer 2005 (9.00.3353.00) on a Windows 2003 SP2 box.It has 12GB of RAM. I had initially set the Minimum Server memory to 4048 and Maximum Server memory to the Default setting - Which means SQLServer would acquire and ...

Message posted on the March 23rd, 2010 - 3:28 PM ET

xa connection issues

Hello SQL Server gurus I'm having an issue with the following scenario: - Java 1.6 client using MS SQL JDBC drivers 2.0 obtains an XAConnection to SQL Server 2005 using SQLServerXADataSource - client obtains an XAResource, calls start on it. - ...

Message posted on the May 20th, 2009 - 9:24 AM ET

DBCC CHECKDB and LocalSystemAccount

I had the SQLServer services running with Network System Account initially and I created a Maintenance Plan. But everytime the job ran the plan used to fail with the error: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Msg 5030, Level 16, State 12, Line 1 ...

Message posted on the December 8th, 2009 - 5:00 PM ET

Event 5586 SQL Error 18452 Login failed for user 'Null'

Researched this before posting; please note permissions look ok and SQL is in mixed mode. Project Server 2007 with SP1 and Infrastructure Update. Installed MOPS a few months ago but it is not in use yet. WSS 3.0 team sites in use for over a year, ...

Message posted on the January 14th, 2009 - 1:38 PM ET

sqlserver locks