Monday, March 26, 2012

How to change or make new user on a SQL server 2000

How to change or make new user on a SQL server 2000Lookup sp_adduser in BOL.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Fernand" <fernand_77@.hotmail.com> wrote in message
news:3f7d3c32$0$58702$e4fe514c@.news.xs4all.nl...
>|||Actually for SQL 2k you should be using
sp_grantlogin to add a new login and
sp_grantdbaccess to add a new user... Both of these can be done easily in
SQL Enterprise Manager as well.
"Fernand" <fernand_77@.hotmail.com> wrote in message
news:3f7d3c32$0$58702$e4fe514c@.news.xs4all.nl...
>|||Wayne's right, BOL states sp_adduser is there for
backwards compatability...sorry about that.
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>Actually for SQL 2k you should be using
>sp_grantlogin to add a new login and
>sp_grantdbaccess to add a new user... Both of these can
be done easily in
>SQL Enterprise Manager as well.
>"Fernand" <fernand_77@.hotmail.com> wrote in message
>news:3f7d3c32$0$58702$e4fe514c@.news.xs4all.nl...
>>
>
>.
>|||I am new in SQL.
Where i find the SQL Enterprise Manager.
"Wayne Snyder" <wsnyder@.computeredservices.com> schreef in bericht
news:%23yPrkiaiDHA.3832@.tk2msftngp13.phx.gbl...
> Actually for SQL 2k you should be using
> sp_grantlogin to add a new login and
> sp_grantdbaccess to add a new user... Both of these can be done easily in
> SQL Enterprise Manager as well.
> "Fernand" <fernand_77@.hotmail.com> wrote in message
> news:3f7d3c32$0$58702$e4fe514c@.news.xs4all.nl...
> >
> >
>

No comments:

Post a Comment