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 |
|
cjp
Yak Posting Veteran
69 Posts |
 Posted - 2010-01-19 : 05:43:20
|
| I am working in SQLS 2005, sr 3. I have built a CTE that joins two large tables and then appends its output to a third table - routine stuff that I have done hundreds of times. However, today, and for the first time, the procedure terminated and gave this error:"Time-out occurred while waiting for buffer latch type 2 for page..."I have checked on the Internet and can find very few articles on this error - and only for SQLS 2008.Can anyone throw any light on this and tell me if there is a fix for SQLS 2005? Meanwhile, I will need to re-write the procedure to avoid working in a temporary table.Thanks.Chris |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
buffer latch error