Post reply

How to view/access tables in sql express? (Determine # of instances/box?)

  • May 26, 2008 at 8:34 am

    #121615

    Hello,

    I have a default mssql2005 SE instance on a server (not named) ... i also see (via windows explorer) another instance folder for sql express 2005 on same box (installed by vendor) ... how do i view and access tables in the sql express instance? can i use the same management studio?

    Also, is there an easier way/tool to determine/view all instances (default/named/sql express) on a given server box?

    Many thanks. Jeff

  • May 26, 2008 at 9:02 am

    #820209

    You can use the SSMS (same tool) in the openning window there will be a line for Server name. Click on the down arrow on the right side of this window. It should display all instances of SQL 2005 and if you have it installed all instances of SQL 2000.

    Once you select the server instance by default SQL express uses the instance name "EXPRESS". Select your authentication mode and then click on "Connect". Once it opens then push the "f8" key and you can then expand the instance name / databases. You can then right click on a database and expand it to show all user tables, programmaability (SPs, User defined functions) ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 26, 2008 at 10:33 am

    #820234

    You can use SQL Server Configuration Manager to identify all SQL Server services available on that system. Since I don't have SQL Server 2000 and 2005 loaded on the same machine - I can't test it, but I am positive that it shows both.

    You can also use SSMS to access and manage SQL Server 2000, MSDE and SQL Server 2005 (all editions, including Express).

    Jeff

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • May 26, 2008 at 11:32 am

    #820245

    Hi,

    Many thanks for replies.

    Jeffrey - Sql Server Configuration Manager (SSCM) is what I was looking for. Perfect! It displays all the instances and their names. Also, SQL Server Management Studio works ... after reviewing SSCM, I discovered that the SQL Express instance was named ... once i explicitly entered the proper syntax in server name input field of "connect to server" (servername\instance_name), i was able to connect/navigate, similar functionality as the default SE instance.

    Many thanks. Jeff

Viewing 4 posts - 1 through 3 (of 3 total)

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