Pages

Social Icons

Thursday, 31 July 2014

How to Identify port number of SQL server

Hi, 

With the help of below query we can check the port number of sql server


select
 distinct local_net_address,
 local_tcp_port
from
 sys.dm_exec_connections
where

 local_net_address is not null

Thx, 
RS

Monday, 14 July 2014

how to check the dependencies of an object in SQL Server

Hi All,

This video will demonstrate you how to check the dependencies of an object.


Thx,
RS