creating login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

creating login

Author

Topic

PSPL
Starting Member

3 Posts

Posted - 2007-08-16 : 06:28:48

I want to create login (user) thru' DB script. Can anybody help me out with this? I have written for SQL 2005, but I want for SQL 2000.

SQL 2005:

CREATE LOGIN [sa2] WITH PASSWORD=N'password2', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'sa2', @rolename = N'sysadmin'
GO
ALTER LOGIN [sa2] ENABLE
GO

PSPL
Starting Member

3 Posts

Posted - 2007-08-16 : 06:52:53

sp_addlogin @loginame = 'sa2' ,
@passwd = 'sa2' ,
@defdb = 'master' ,
@deflanguage = 'us_english' ,
@sid = NULL ,
@encryptopt = NULL
GO
sp_addsrvrolemember @loginame = 'sa2',
@rolename = 'sysadmin'

This does my work. Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources