Never mind! COPY!!!! NOT IMPORT!!!!! Geezers, it has been a long week!!!!
Happy Halloween, Lisa Lisa Cruz Teledermatology System Administrator Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -----Original Message----- From: Cruz, Lisa L Ms GPRMC Sent: Friday, October 31, 2003 11:25 AM To: '[EMAIL PROTECTED]' Subject: SQL 2000-replicate database tables on another server - HELP! Hi all, I am trying to replicate a database on another server. Every time I try to "import" I get ALL the data elements (patient info, images, etc.)...is there anyway to import/install a CLEAN copy of the database (replicate the DB ONLY on this new server? The other problem is that the production server works great - everything works well - when I import the DB to the test server, I keep getting errors within the .cfm pages such as "cannot insert null values into xxx table" - am I inheriting permissions that need to be changed on the test server???? HELLLLLLLLLLLLLLLLLLLLLLLLLPPPP!! Lisa
