Showing posts with label o-sql. Show all posts
Showing posts with label o-sql. Show all posts

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.