Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HSSona
Starting Member
5 Posts |
 Posted - 2007-06-26 : 13:54:31
|
| Hi,I have created a couple of tables in my local database (SQL Server 2000) by using create table scripts. The scripts run fine and the tables are created, I add some foreign key constraints (master-details) and also insert some values. However, each time I restart my machine I see that the table are no longer there, they are gone and I have to re-create them. Am I missing something very elementary? Please help.Thanks in advance.HS |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-26 : 13:59:53
|
| Are you putting these in the tempdb database?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-26 : 14:14:35
|
| Implicit transactions turned on maybe? |
|
|
|
HSSona
Starting Member
5 Posts |
Posted - 2007-06-28 : 08:16:29
|
| Thanks mates, basically I was not aware of the tembdb database - in order to test my applications, I created a database and named it as none other than "tempdb" - this may have been a keyword as tkizer mentioned. I deleted the database and created a new one with another name and now I find my tables intact after machine restart :)Thanks again! |
|
|
|
|
|
|
Tables deleted after machine restart