default database

Hi all,
I want to delete a particular database 'r3risk', But when I delete it, I
have problems when connecting via sqlmanager. It gives me an error about the
default database, which is set at 'r3risk', which I've deleted. I've had to
restore and reatach in order to connect via sql manager.
Where and how can I change what the default database is. SQL manager options
in the database properties is greyed out.
Thanks
RobertEasiest is to use sp_defaultdb.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Robert Bravery" <me@.u.com> wrote in message news:eKg6bNWPGHA.2696@.TK2MSFTNGP14.phx.gbl...[
color=darkred]
> Hi all,
> I want to delete a particular database 'r3risk', But when I delete it, I
> have problems when connecting via sqlmanager. It gives me an error about t
he
> default database, which is set at 'r3risk', which I've deleted. I've had t
o
> restore and reatach in order to connect via sql manager.
> Where and how can I change what the default database is. SQL manager optio
ns
> in the database properties is greyed out.
> Thanks
> Robert
>[/color]