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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-02 : 09:04:07
|
| andy writes "When I dbcc opentran(tempdb), it shows me the following :-Transaction Information for database: tempdbOldest active transaction: SPID : 88 UID : 4 SUID : 11 Name : sort RID : (142355 , 10) Time Stamp : 0001 0024D661 Start Time : Oct 30 2001 4:28:59:873PMDBCC execution completed. If DBCC printed error messages, see your System Administrator.I can't kill the SPID. Any better suggestion for this to overcome my problem ?" |
|
|
|
|
|
TEMPDB (SQL Server 6.5)