+ Reply to Thread
Results 1 to 7 of 7

Thread: Cant see tables in SQL Server 2008

  1. #1
    micky
    micky is offline
    Lazy Bum micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky's Avatar
    Join Date
    Jul 2008
    Location
    India
    Posts
    693
    Blog Entries
    1
    Rep Power
    6

    Cant see tables in SQL Server 2008

    Hello people
    My client has a MSSQL SERVER 2008 hosted somewhere.
    He wishes us to have a look at the db structure.

    I downloaded one "EMS SQL Manager 2008 Lite for SQL Server" from here
    EMS SQL Manager 2008 Lite for SQL Server Freeware download and review - MS SQL Sever management from SnapFiles

    Now when i login, i dont see any tables. According to client, there are tables in the db.

    So am i doing something wrong??

    Thanx
    micky, February 27th, 2009 06:55 AM
    Reply With Quote Reply With Quote
  2. #2
    jmurrayhead
    jmurrayhead is online now
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Washington, D.C.
    Posts
    2,354
    Blog Entries
    9
    Rep Power
    19

    Why not just use SQL Server Management Studio Express?

    Anyway, I'm sure it's a permissions issue. You probably just don't have permissions to see those objects.
    jmurrayhead, February 27th, 2009 08:26 AM
    jmurrayhead
    If you agree, give me rep. If my post helped you, click "Thanks".
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
  3. #3
    micky
    micky is offline
    Lazy Bum micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky's Avatar
    Join Date
    Jul 2008
    Location
    India
    Posts
    693
    Blog Entries
    1
    Rep Power
    6

    Is "SQL Server Management Studio Express" free?

    How can i set the permissions?
    Although i dont like playing with such things for clients
    micky, February 28th, 2009 03:12 AM
    Reply With Quote Reply With Quote
  4. #4
    jmurrayhead
    jmurrayhead is online now
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Washington, D.C.
    Posts
    2,354
    Blog Entries
    9
    Rep Power
    19

    Yes, it's free: Download details: Microsoft SQL Server Management Studio Express

    They would have to right-click each table and click properties. Then they would have to give your username permissions on the tables and procedures. Of course, there's probably a script out there that can do this easily. I'm not certain...but I think if dbo is the owner of the objects and they give you dbo, then you would be okay.
    jmurrayhead, February 28th, 2009 11:56 AM
    jmurrayhead
    If you agree, give me rep. If my post helped you, click "Thanks".
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
  5. #5
    micky
    micky is offline
    Lazy Bum micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky's Avatar
    Join Date
    Jul 2008
    Location
    India
    Posts
    693
    Blog Entries
    1
    Rep Power
    6

    Thanx for the info J

    Things have been clear a bit with client and the news is that are NO tables indeed in database

    I love such clients
    micky, March 2nd, 2009 03:36 AM
    Reply With Quote Reply With Quote
  6. #6
    jmurrayhead
    jmurrayhead is online now
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Washington, D.C.
    Posts
    2,354
    Blog Entries
    9
    Rep Power
    19

    lol glad everything is cleared up for ya
    jmurrayhead, March 2nd, 2009 08:48 AM
    jmurrayhead
    If you agree, give me rep. If my post helped you, click "Thanks".
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
  7. #7
    micky
    micky is offline
    Lazy Bum micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky is a jewel in the rough micky's Avatar
    Join Date
    Jul 2008
    Location
    India
    Posts
    693
    Blog Entries
    1
    Rep Power
    6

    Quote Originally Posted by jmurrayhead View Post
    lol glad everything is cleared up for ya
    ya and now the client (or whoever) made 1 table and i can see it.
    So there is no permission issue as well
    micky, March 3rd, 2009 04:07 AM
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Similar Threads

  1. getting values from tables
    By todd2006 in forum ASP Development
    Replies: 7
    Last Post: February 2nd, 2009, 06:33 PM
  2. SQL Server 2008
    By stephenhy88 in forum Microsoft SQL Server
    Replies: 7
    Last Post: August 13th, 2008, 01:55 AM
  3. Using Visual web Developer 2008 Express Edition
    By todd2006 in forum .Net Development
    Replies: 2
    Last Post: April 23rd, 2008, 11:35 AM
  4. Visual Web Developer 2008 Express Edition
    By todd2006 in forum .Net Development
    Replies: 1
    Last Post: April 22nd, 2008, 03:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


SEO by vBSEO