We have problems with our tempdb.Whenever we start query analyzer we noticed that tempdb contains tables and stored from our database.

We have two separate scripts for my database but after we ran the first scripts every entities and sprocs on the second script were already present in the database we just created.

Cud these be the problem with the tempdb?
We also noticed that the master database contains those entities.

How could this happen?


Aldwin Enriquez
"Dont you ever give up!"

__________________
\"Dont you ever give up!\"

Hi aldwinenriquez,

The problem is not with the tempdb database but with your model database. Check your model database and see if the tables you are referring to are there. What happens is that everytime you restart SQL Server, it recreates the tempdb database and bases its structure from the structure of model database.

Hope this helps.

SQL Server Helper
http://www.sql-server-helper.com

The tempdb is also going to be mirroring things that are happening on every database. You can ignore that activity.


mmcdonal