Post reply

Login Problem

  • July 6, 2011 at 9:23 am

    #240445

    Hi,

    I have SQL server 2000.

    I have login as windwos authentication and SQL login .

    While I login as windows authentication and execute a create table statements, the table gets created , but no one else can see the tables. If I look into the enterprisemanager then table can be seen but with my name and dbo owner. If I login with sql login no problem happens.

    Can somebody guide me whats happening? as this problem is really a huanted one.

    Thanks in advance.

    Harsha

  • July 6, 2011 at 9:33 am

    #1349085

    A good place for you to start is finding what your rights are. Your problem lies in user schema sepration here is an article on it:

    http://msdn.microsoft.com/en-us/library/ms190387.aspx

    :cool:

    "There are no problems! Only solutions that have yet to be discovered!"

  • July 7, 2011 at 3:58 am

    #1349527

    Thanks,

    All done..

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

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