Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005

    Question Unanswered: MSSQL2000 Client Unable to create new table

    I'm new to SQL Server and I'm sure this is a simple problem.
    But I can't seem to solve it.
    Here's the problem:
    My website & MS SQL 2000 Server are being hosted by Networksolutions.
    Thru the Client Enterprise Manager I am Unable to create a New Table.
    This is the error message I get:
    " [MS Design Tools]-ODBC error: [Microsoft] [ODBC SQL SERVER DRIVER] [SQL SERVER] SELECT permission denied on object 'sysobjects', database 'namedb', owner'db' "
    Last edited by septemberq; 12-18-05 at 22:53.

  2. #2
    Join Date
    Jul 2002
    Someone must grant you the necessary permissions for the database.
    You're not authorized to create objects, simply.

  3. #3
    Join Date
    Dec 2005

    Permissions Issue

    Thank you for your insieght.
    I'm sure your are correct.

Posting Permissions

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