what is this?

[StanKorn]

I am new in the MS SQL world and am curious re what a source is in a system log? I see a process open database tagged to spid12 and then the next process open data base tagged to spid13. Can anyone resolve my curiosity as to what this log is telling me?

2004-01-03 16:53:47.89 spid12 Starting up database 'lme_dev'.
2004-01-03 16:53:47.89 spid11 Starting up database 'lme'.
2004-01-03 16:53:47.89 spid9 Starting up database 'pubs'.
2004-01-03 16:53:47.89 spid10 Starting up database 'Northwind'.
2004-01-03 16:53:47.92 spid13 Starting up database 'Tires'.


Remember - only dead fish go with the flow.

 

[JayKusch]

The SPIDs are SQL Server processes that are performing tasks. In this case it looks as if you have started SQL Server and it is now connecting your databases.

Thanks

J. Kusch

 

[StanKorn]

Is there a way to determine what the user ID is for these requests?


Remember - only dead fish go with the flow.

 

[mrdenny]

You can see what account is used in real time from the master.dbo.sysprocesses table. Historically your out of luck unless you run a trace.

All SPIDs below 50 are system processes. They are run by the sa account.

Denny

--Anything is possible. All it takes is a little research. (Me)