Is there a transact SQL or system SP that could do the job?

Hi,

For SQL 2000 You have to use system stored procedures to create login and
user.

sp_addlogin
sp_adduser

Take a look into above 2 system procedures in books online for usage to
create login and users

Thanks
Hari
SQL Server MVP


Show quoteHide quote

Hari Prasad wrote:
Thanks! Got it done.

A .NET Framework error occurred during execution of user defined r
sql statement (how to)
Update Information in SQL from a VBS script
Dynamic SQL and column-values
validate statement before execute with sp_executesql
SQL 2005 slower than 2000?
Re: Connections List
Other ways to run this query?
Trying to do a blog join (entry columns, and # of comments) without success
How do I.....?