Home Forums SQL Server 7,2000 Security Add new user in SQL server 2000/2005 through script RE: Add new user in SQL server 2000/2005 through script

  • Conceptually both are same.

    Login lets you connects to the server

    and User has the permissions inside the database.

    Only difference is in 2000 the user and schema are clubbed.

    In 2005 they are independent

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]