ok, I found the tables in sysobjects on the db.  The optimization script I am using is searching the information_schema.tables to loop thru the tables.  When I query the information_schema.tables,...

ok, I queried the sysobjects table:

SELECT * FROM sysobjects.qatest.qatest_flash1

and got nothing.  Shouldn't I be able to query the sysobjects and get back info on any tables  or stored procedures...

Many thanks to all who helped me with ideas here!!  I appreciate you!!  Ok, I did total debug today...a dozen print statements to find out that my transaction rollback code...

There is indeed data in the PERSON table!  I am testing the import of new 'Persons'.  What I am doing in the testing phase is 'de-identifying' the patient info and...

Thanks John.  Here is my insert code.  It is done within a loop.  For testing purposes, I am only trying to insert one record.  Like I said, I already tried,...

Thanks again Greg!!

I believe what you said is what I should be asking.  This info is in VSS right???  I will check under history.....

thank you!!

ok, I am now having problems with other tables not being able to be dropped because of being referenced by (in this case again, another view) another object.,

Is there something...

I did drop the publication.....and rebuilt it.  I did NOT drop anything at the subscriber....will this cause me issues??  I am in the middle of building the snapshot as we...

Here is the error msg:

Cannot DROP TABLE 'PATIENT_RECORD_KEYS' because it is being referenced by object '_hypmv_0_2772'.

(Source: IMETOLAP (Data source); Error number: 3729)

---------------------------------------------------------------------------------------------------------------

for all kinds of reasons, we decided to delete the replication publication and start over.  I scripted out the replication and re did it.  After the snapshot was done, I...

thank you so much for such a quick response!!

Thank you again!!  These UNdocumented sp's could really help new DBA wanna be's like me!!  I appreciate your help!!!

thank you!  Can you tell me where to find some documentation on it???

I looked in BOL and KB on Microsoft to understand the sp_MSforeachdb and I can't find anything.  Can you point me to where I can get explanation of what it...