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 |
|
farrokhp
Starting Member
15 Posts |
 Posted - 2010-01-19 : 15:47:02
|
| I need a script can be run on sql 2000 and 2005 both and filter out all activities on a specific database group by user logins. Any help appreciate |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-20 : 07:51:04
|
| the following will filter based on db_name and loginame , if you need omething slightly different or customised , let me knowSELECT * FROM master..sysprocesses WHERE dbid = DB_ID('my_db_name') where loginame = '<my_login_name>'Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
script