Sunday, March 11, 2012

assigning sysadmin rights to login through O-SQL

Hi,
I'm currently using MSDE 2000 & i want to create a server login with
SYSADMIN Rights.
please suggest.If you use a sql server login, you can use:
sp_addlogin 'NewUser','NewSecretPassword'
GO
sp_addsrvrolemember 'NewUser','symin'
HTH, jens Suessmeyer.

No comments:

Post a Comment