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 |
|
rajam.venkatesh58
Starting Member
2 Posts |
 Posted - 2012-12-06 : 10:06:41
|
| Hi all,is there any query to know active sessions that are running in a specific database for last 24 hours for 1 hour interval in sqlserver 2008 and that query shouldn't be burden to database.Please answer.Thanks in advance.Regards,Venkat. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-12-06 : 10:22:38
|
| A session (by which I assume you mean a connection?) connects to a server - it can then change between databases and have a default database but query several others in the same statement.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
active sessions