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','sy

HTH, jens Suessmeyer.
Asp.net / sql help
No comments:
Post a Comment