March 22, 2004 at 3:17 pm
Hi,
I use the SQL server as an example of RDBMS in a database course, but I´m not an expert in SQL Server specific features. When I create a new database using Enterprise Manager, the new database includes the system tables plus 2 user tables. So, I think some of the students have created a sort of system-wide trigger; every time a database is created, so is this 2 tables. I wanna to disable this thing, but I don´t know how.
Any idea?
Thanks, Daniel.
March 22, 2004 at 3:21 pm
Most likely they created the tables in Model. As all db's built are modeled after model then they of course inherit these tables in their design. Check there and they should be there. Just remove and that should end it for you.
March 23, 2004 at 2:15 am
...and best to make sure those students haven't set up anythings else in model - views, stored procedures, functions, etc, and especially fixed database roles for themselves.
Cheers,
- Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply