Very good script for Exchange 2010 features installation:
http://www.ehloworld.com/152
Wednesday, February 29, 2012
PRTG upgrade
When you try to upgrade PRTG from version 9.1 to 9.2, if the upgrade fail - you will need to clear "Read only" attribute on "c:\Program Files (x86)\PRTG Network Monitor\website folder"
Tuesday, February 21, 2012
List SQL active connection
Good script:
SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame
The script can enumerate all databases on a SQL 2005-2008 r2 server and list active connection.
FROM: http://www.sqlservercurry.com/2008/03/how-to-see-active-connections-for-each.html
SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame
The script can enumerate all databases on a SQL 2005-2008 r2 server and list active connection.
FROM: http://www.sqlservercurry.com/2008/03/how-to-see-active-connections-for-each.html
Subscribe to:
Posts (Atom)