Re: SQL connection problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 15:35:31 +0200

John

> Or the db that I cannot re-attatch?
Yes
> I am cannot see any of my db the SQL srvr registration will not show me
> anything because of the user default db. The user is 'sa' and the
> production db is 'Commercecenter'. But I cannot see any db including
> master,model, msdb, pubs,tempdb.

When you try to connect via QA what db you are seeing?
Did you run EXEC sp_defaultdb 'yourusername', 'Commercecenter'?

"John Almeda" <jalmeda@northsouth.net> wrote in message
news:%23OElKTPFFHA.3840@tk2msftngp13.phx.gbl...
> Uri,
>
> Which db do I detach? PUBS and delete the log for PUBS?
>
> Or the db that I cannot re-attatch?
>
> I am cannot see any of my db the SQL srvr registration will not show me
> anything because of the user default db. The user is 'sa' and the
> production db is 'Commercecenter'. But I cannot see any db including
> master,model, msdb, pubs,tempdb.
>
> John Almeda
> System Adm
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!