ADP Don't Shows Table From MSDE

Hi,

I created one blank ADP to connect default tempdb database on MSDE on server ASHFAQUEPC (name of my msde server). Tested the connection was successful.

I created a table called Testtable from command prompt (MSSQL/Binn) in default tempdb of MSDE using following lines:

…Binn>osql/U sa mypassword

1> use tempdb
1> go
1> Create table Testtable (Cnum integer NOT NULL PRIMARY KEY, City Varchar(15))
1> go

Table Created successfully then I added 2-3 records using following lines;

1> INSERT INTO testable (cnum, city)
1> values (1, ‘abc’)
1> go

1 Record affected and I did same to add 2-3 more records. Then I used following lines to see all the records I entered.

1> select * from testable
1> go

And a list of records displayed at command prompt. After exit from command prompt I found a ‘Testtable’ appeared in the above ADP.

But next day when I opened my pc and opened ADP, I did not found the Testtable even though I re-connected to tempdb on MSDE from File menu. I reached then to command prompt to see whether the table itself is existing. Strange it was not there.

Can somebody tell me how can I get connected to testable automatically when I open my ADP? Where might have gone wrong? Do I need to create table again and input records?
I want to make sure before I do anything with my real dbs.

Any help would be highly appreciated.

With kind regards,
Ashfaque :confused: