|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
Default Database
Hi All,
I want to display selected database of my choice when i open the query analyzer of MS SQL Server 2000. How can i set the default database according to my choice. Thanks and regards.
__________________
The way to perfection is practice. |
|
#2
|
|||
|
|||
|
You can set the default database for any login ID in the Enterprise Manager. You can also set the default database by using sp_defaultdb.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. Last edited by Scorpions4ever : August 4th, 2005 at 05:08 PM. |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Default Database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|