General information
Forum:
Microsoft SQL Server
I've had this happen as well. Generally the server runs OK, but when deadlocks occur and I track down the last T-SQL command for the deadlocked process, it is a simple SELECT statement. The only consistency I have found is that the only time I have seen this happen the DATE() function has been part of the SQL statement. I am running SQL 7.0 SP3 on this particular server by the way. The original developer told me that he has never had this happen to him in 2 years and we are running identical enviroments. My only guess at this point is some sort of hardware failure or software conflict rather then the transactions themselves.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only