Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

single user

Status
Not open for further replies.
swoodring

swoodring

Programmer
Dec 7, 2000
114
US
I was out yesterday and this morning when I came in our production db was set to single user. And 2 of our scheduled jobs had failed one being the db maint plan. Is there a way I can find out who or what job changed the db to single user?
 
Sort by date Sort by votes
SQL Server closes a database and opens it in single user mode when that open is selected. It records the closing and opening of the database in the error log. However, the only information about who set the option is the SPID (system process ID) number. You can look through the log(s) to find the open and close sequence for the database in question. Terry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
393
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Determine sa Password When Signed On As Administrator User Thru Windows Authentication 1
Replies
2
Views
264
Auguy
Auguy
baran121
  • Locked
  • Question
sql user default language problem
Replies
7
Views
406
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top