{"id":5460,"date":"2016-06-16T09:35:11","date_gmt":"2016-06-16T14:35:11","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=5460"},"modified":"2016-06-16T09:35:11","modified_gmt":"2016-06-16T14:35:11","slug":"sql-server-querying-active-users-by-database","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2016\/06\/16\/sql-server-querying-active-users-by-database\/","title":{"rendered":"SQL Server &#8211; querying active users by database"},"content":{"rendered":"<pre>\r\nuse master\r\ngo\r\ndeclare @table table(\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 spid int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 status varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 login varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blkby varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbname varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 command varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cputime int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 diskio int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 lastbatch varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 programname varchar(max),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 spid_1 int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 requestid int\r\n)\r\n\r\ninsert into @table exec sp_who2\r\n\r\nselect\u00a0 *\r\nfrom\u00a0\u00a0\u00a0 @table\r\nwhere dbname = 'NCRWO_Transactions'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>use master go declare @table table( \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 spid int, \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 status varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 login varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hostname varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 blkby varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dbname varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 command varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cputime int, \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 diskio int, \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 lastbatch varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 programname varchar(max), \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2016\/06\/16\/sql-server-querying-active-users-by-database\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,34],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5460"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=5460"}],"version-history":[{"count":1,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5460\/revisions"}],"predecessor-version":[{"id":5461,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/5460\/revisions\/5461"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=5460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=5460"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=5460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}