Results 1 to 2 of 2
Thread: Database tables
Jun 4, 2008, 05:03 #1
For some reason unknown to me when I created a database and then the tables for it, these tables have appeared in my other databases—including the master database... I'm using SQL Server 2005 Express.
I've deleted these tables from those databases.
Will this remove them and restore the master (and other) databases to what they were? I've heard you're not supposed to tamper with the master database.
Or will I have to reinstall SQL Server 2005 Express?
Jun 4, 2008, 06:41 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 58 Post(s)
- 3 Thread(s)
before you create a database, you're actually in another database
so, right after you create a new database, issue the USE command for it, and then you can continue and create the tables
i've created tables in master by mistake too, just go ahead and drop them