Import Users into database - 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

General SQL Server Forums

New to SQL Server Programming

Import Users into database

Author

Topic

electra109
Starting Member

4 Posts

Posted - 2010-11-11 : 16:41:13

I have 200 users to import into sql 2000

I need to import there database username,password and which database they can access

Can I run a script that will read the excel spreadsheet and import the user details

X002548
Not Just a Number

15586 Posts

Posted - 2010-11-11 : 17:47:27

why don't you use windows security

in any case import the data you have to a table

You can the create the sp's to do the work

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

electra109
Starting Member

4 Posts

Posted - 2010-11-12 : 04:10:05

I need to change the databse logins because I have to migrate to another domain site by site

I am new at sql what sp's

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources