Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Table creation in Master DB
- Thread starter jxc
- Start date
Dear
It is most comman accident in using Query analyser. when we open Query Analyzer then the master databaes is selected in the combo by default.
To avoid this , go to Security option , then go to logins and select your login and see its properties and change your default database in this section. Then , next time when you will run QA then that database will be selected as default.
You can Drop that table easily using DROP TABLE Statement or form Enterprise manager.
Regards,
Muhammad Essa Mughal
- Status
Similar threads
- Locked
- Question
- Locked
- Question