InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:16:46 GMT20http://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspxTo create a database user account for an existing login, sp_grantdbaccess @loginname = 'loginname'Tue, 10 Jul 2012 23:57:15 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspxConceptually both are same.Login lets you connects to the serverand User has the permissions inside the database.Only difference is in 2000 the user and schema are clubbed.In 2005 they are independentMon, 09 Jul 2012 03:14:21 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspxwhat is the difference between 2000 user and 2005 user ?thanks in advancesriMon, 09 Jul 2012 03:00:33 GMTsermohan-1082835http://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspx[quote][b]sumitagarwal781 (2/6/2012)[/b][hr]Thanks a lotMon, 06 Feb 2012 22:58:19 GMTssa2010http://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspxHere is the command for adding user on SQL server 2000/2005--2000exec sp_addlogin @loginame='NewLoginName', @passwd='The Password', @defdb='Default Database Name', --Optional @deflanguage='Language' --Optionalexec sp_adduser @loginame='NewLoginName', @name_in_db='NewUserName',--2005CREATE LOGIN NewLoginName WITH PASSWORD = 'The Password';USE AdventureWorks2008R2;CREATE USER NewLoginName FOR LOGIN NewLoginName;GOMon, 06 Feb 2012 22:06:55 GMTsumitagarwal781http://www.sqlservercentral.com/Forums/Topic1247799-6-1.aspxHello friends,Is there any way to add a new db user in sql 2000/2005 through script ?If yes please provide this sample script..Mon, 06 Feb 2012 21:37:02 GMTssa2010