Being DBA

MCITP

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'
Posted by Aditya Jha at 2:01 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Aditya Jha
View my complete profile

Blog Archive

  • ►  2018 (1)
    • ►  February (1)
  • ►  2017 (3)
    • ►  December (1)
    • ►  November (2)
  • ►  2016 (5)
    • ►  June (2)
    • ►  May (3)
  • ►  2015 (13)
    • ►  October (6)
    • ►  July (5)
    • ►  January (2)
  • ►  2014 (8)
    • ►  September (3)
    • ►  April (4)
    • ►  March (1)
  • ►  2013 (3)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
  • ►  2012 (5)
    • ►  June (1)
    • ►  May (4)
  • ▼  2011 (50)
    • ▼  October (1)
      • Find the list of server on Network
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  April (7)
    • ►  March (34)
    • ►  January (1)
  • ►  2010 (7)
    • ►  September (1)
    • ►  July (6)
Simple theme. Powered by Blogger.