MS SQL Server Most Useful Queries

mssql.sql

select * from master.dbo.sysdatabases;

use DataBaseName;
select * from information_schema.tables;
select TABLE_NAME 'Table Name',COUNT(COLUMN_NAME) 'Column Count'  
from information_schema.COLUMNS group by TABLE_NAME order by [TABLE_NAME];


select @@CONNECTIONS;
select @@SERVERNAME;
select @@SERVICENAME;
select @@VERSION;

--http://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row
select @@IDENTITY;
select SCOPE_IDENTITY();
select IDENT_CURRENT('tableName') ;