Being DBA
MCITP
Wednesday, October 5, 2011
Find the list of server on Network
Method 1 :
Set SQLCMD mode => Use below query
!!SQLCMD -L
Method 2 :
use below query:
EXEC master..XP_CMDShell 'OSQL -L'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment