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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.