We all should read the documentation first.
5 Detecting SQL Server Utilization with a query Feb 8 '13
1 Does a transaction cover the subroutines? Feb 14 '13
0 Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands? Jun 12 '12