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 |
|
ibnhall
Starting Member
1 Post |
 Posted - 2008-12-04 : 16:54:12
|
| I am new to SQL Server. I need to create a automated process to report the active users in SQL each day. This is necessary due to issues we have with our backups while users are currently in the system. All active users will get a slap on the wrist. |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2008-12-04 : 18:06:50
|
| try this..exec sp_whoalternativelyexec sp_who2 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-04 : 18:12:10
|
| You should have no problems while backing up.Try this for active users:sp_who2 active |
|
|
|
|
|
|
active users report