Post reply

Does SQL Server exist

  • February 12, 2004 at 6:45 am

    #86061

    I have two questions:

    1) How can I find out does SQL Server with certain name exist

    2)How can I find out does a database with a certain name exist on this SQL Server

    thanks beforehand

     

  • February 12, 2004 at 8:38 am

    #493817

    Before you do ANYTHING you need to have a login with Access to those servers!!!

    1. Use: This Trick

    2. Query the master..sysdatabases table


    * Noel

  • February 12, 2004 at 8:33 pm

    #493924

    It is not an answer. When you create new SQL Server registration in Enterprise Manager, it shows all SQL Servers, visible in LAN, without any login.

  • February 13, 2004 at 7:30 am

    #493978

    If you were refering to the Annonced servers you can run :

    isql -L

    Beware ! Announcing can be turn OFF!


    * Noel

  • February 13, 2004 at 7:33 am

    #493979

    F.Y.I. muk07 - when asking others for help, it's not a good idea to spout back at them "It is not an answer". Not if you expect to get any replies to future questions. No one's getting paid for this.

    1. noeld answered your 1st question. You didn't ask for solution w/o login. You didn't ask for "all SQL Servers in LAN like EM". In your original post, you asked for "a certain name" which is 1 server. noeld answered corectly.

    If you want list of SQL Servers like EM, then ask for it.

    Answer (if you have client tools installed):

    osql -L  (-L must be caps) from command line. No user id/password required.

    2. existence of database on server. Going to require a login because you actually want info from server instead of just checking for existence of server. noeld's response stands.

  • February 13, 2004 at 11:12 pm

    #494073

    Thanks to davidf for a time he spared to learn me how to behave myself

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply