Hiyas,
I am using a SQLServer 2000 installation to process web orders and parse email orders. We went into production this week and since my test cycle was woefully short, I have been in firefighting mode. I needed to create a debugging copy of a table. I went in to enterprise manager and rightclicked the table All Tasks|Generate SQL Script
I copied the script to the clipboard, opened query analyzer
pasted the result in, deleted the unneeded portion at the top, changed the name to add _debug to the end of it and ran it. I verified the table was created. About 1.5 - 2 hours later I realized that the table was missing (because it is the main gateway from my asp into the SQL box and I wasn't getting any web juice). I guess I can set up a foreign key relationship to keep it from happening again but I would like to know how it could've happened. I know I didn't drop the table in Enterprise manager 'cause it gives you a bigass confirmation dialog with a drop all button on it. Could something have happened with the script? Thanks in advance JHall
I am using a SQLServer 2000 installation to process web orders and parse email orders. We went into production this week and since my test cycle was woefully short, I have been in firefighting mode. I needed to create a debugging copy of a table. I went in to enterprise manager and rightclicked the table All Tasks|Generate SQL Script
I copied the script to the clipboard, opened query analyzer
pasted the result in, deleted the unneeded portion at the top, changed the name to add _debug to the end of it and ran it. I verified the table was created. About 1.5 - 2 hours later I realized that the table was missing (because it is the main gateway from my asp into the SQL box and I wasn't getting any web juice). I guess I can set up a foreign key relationship to keep it from happening again but I would like to know how it could've happened. I know I didn't drop the table in Enterprise manager 'cause it gives you a bigass confirmation dialog with a drop all button on it. Could something have happened with the script? Thanks in advance JHall
