sp_addlogin @loginame = 'bob', @password = 'bobsstupid', defdb = 'ilikethisdb'
Or do it through enterise manager security, or look in BOL under 'users' Jacob Jacob Cameron Blue Lantern, Inc. (972) 226-9595 [EMAIL PROTECTED] http://www.blue-lantern.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 6:20 PM To: [email protected] Subject: RE: MSSQL 7 Emergency I cannot seem to put my finger on where I resetup my sql user logins... I have the repair complete and sql starts but I need to then connect... I am using the sql login not nt user login. thanks. At 05:34 PM 3/23/2005 -0600, you wrote: >I, fortunately, have never been in that situation. AFAIK, you will lose >your SQL user logins, permission settings and some other things. You >can still restore your databases individually. > > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of [EMAIL PROTECTED] >Sent: Wednesday, March 23, 2005 4:59 PM >To: [email protected] >Subject: RE: MSSQL 7 Emergency > > >Looking for it; what if I cannot find ? > >At 04:53 PM 3/23/2005 -0600, you wrote: > > >Do you not have a backup of the master DB?? > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >Behalf Of [EMAIL PROTECTED] > >Sent: Wednesday, March 23, 2005 4:36 PM > >To: [email protected] > >Subject: OT: MSSQL 7 Emergency > > > > > >All, > > > >Having a 5 alarm fire: > >My master log file (ldf) has gotten corrupted and now the SQL Server > >will not restart leaving a ton of databases unaccessable. > > > >I guess that I have to reinstall... correct ??? > > > >Will this not delete any databases that are present? > > > >Precautions, Hints, Etc. Appreciated. > > > >Bob Coalter > >InterNet Partners > > > > > >-- > >No virus found in this outgoing message. > >Checked by AVG Anti-Virus. > >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 > > > >---------------------------------------------------------- > >To post, send email to [email protected] To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > > > >---------------------------------------------------------- > >To post, send email to [email protected] To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > >-- > >No virus found in this incoming message. > >Checked by AVG Anti-Virus. > >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 > > > >-- >No virus found in this outgoing message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 > >---------------------------------------------------------- >To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm >To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > >---------------------------------------------------------- >To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm >To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > >-- >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005 ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
