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 |
|
dbist
Yak Posting Veteran
52 Posts |
 Posted - 2008-06-04 : 11:48:19
|
| my sql server froze last night and I didn't have profiler running. I would like to know if there's a way I can query the events that happened last night. In other words, I'd like to know what process exactly is the message below talking about?This instance of SQL Server has been using a process id of 3476 since 5/28/2008 1:09:26 PM (local) 5/28/2008 5:09:26 PM (UTC).Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 11:54:37
|
| Check event log and SQL server error log. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-04 : 22:50:04
|
| You'll not get process info if sql is restarted. |
|
|
|
|
|
|
how to query past events in the SQL Server