To update a database that wasn't being used yet I disconnected it from sql, uploaded the changes and then couldn't get back into the database. The server I'm on had two to login to, "sharepoint" and "sbsmonitoring". The database was in
"sharepoint". I can no longer access "sharepoint" but can access the sbsmonitoring". I've determine from the posts I've read that I can't access the "sharepoint" server because the default database no longer exsists in that
database. I've found code to reset that,
c:\> sqlcmd -S AIR\SQLEXPRESS -d master
Where AIR is the name of my machine and
SQLEXPRESS the name of the SQL Server instance.
In the sqlcmd prompt I put the following:
Go to the complete details ...