Table added to every database I create

Question

0.00/5 (No votes)

See more:

I have never heard of this nor has anyone I've asked. I created a database via SSMS about a year ago and put a 4GB table in it. I don't know what I did, but every time I create a new database it puts a copy of that table in there automatically. It's easy to delete but makes DB creation a pain.

A solution would be appreciated as well as learning how the hell I did it.

Thanks

Posted 6-Jan-15 5:38am

John M Bundy

Add a Solution

Comments

Kornfeld Eliyahu Peter 6-Jan-15 11:51am

How do you create your new database?
Do you have any DDL triggers?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2015-01-06T05:50:00

Solution 1

You have created that table in the model database. That one is replicated on every database creation. Please noted, that in SQL Server not the database, but the instance is the top level logical and functional object.

[Update]
Not master, model.

Posted 6-Jan-15 5:50am

Zoltán Zörgő

Updated 6-Jan-15 6:24am

v2

Comments

Richard Deeming 6-Jan-15 12:09pm

Did you mean the model database? :)

Zoltán Zörgő 6-Jan-15 12:23pm

Yes, I meant model!

John M Bundy 6-Jan-15 12:22pm

There are no tables at all in my master or model database.

Zoltán Zörgő 6-Jan-15 12:28pm

Well, you could have also created an instance level event but I doubt that something like that is created by accident.

John M Bundy 6-Jan-15 12:26pm

Strange, there are no tables showing under my model database, but when I search for that table using the sp_MSforeachdb procedure it says there is one there.

Kornfeld Eliyahu Peter 6-Jan-15 12:30pm

Try run this:
USE model
GO
SELECT *
FROM sys.Tables
GO

Zoltán Zörgő 6-Jan-15 12:31pm

Well, as I suppose, that table was created by a service, your user (even SA) might not have right by default to see it. I have never encountered something like that, but might happen. With admin try to grant all rights to yourself and try to drop it.

John M Bundy 6-Jan-15 12:38pm

I am the sole admin/user and set it up myself, still couldn't see it. Once I knew where it was though it did allow me to drop it. Thanks

Zoltán Zörgő 6-Jan-15 12:39pm

You are welcome.