How to change default db

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi Robert,

try sp_defaultdb

sp_defaultdb [ @loginame = ] 'login' , [ @defdb = ] 'database'

Also see BOL

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Robert Lu SSCrazy Points: 2488 More actions · Answer 2

Thank you again, Frank. I changed the registration.

Robert