Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
 Posted - 2008-01-30 : 12:25:04
|
| Guys,Am getting the following error on running a view.The view consists of many unions.What could be the cause of error ?I have no other process running when I run the view.Server: Msg 1205, Level 13, State 2, Line 2Transaction (Process ID 71) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.I think it could be possibly be something to do with the unions cos prior to this, the view had one less union,eversince I added one more union to it ,it has been giving the same error.Thanks |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-01-30 : 13:00:57
|
| Here is a good place to start: http://msdn2.microsoft.com/en-us/library/ms188246.aspx |
 |
|
|
|
|
|
locking issue