UPDATE: I think I found the problem and the error is on my side. I made some assumptions about the DB I'm working with right now (not our regular DB) ...

Those work but not for tables just other objects like Stored Procs.

If I have a table named MYPARENT and there are 5 other tables that each have a foreign Key...

I will query on the system catalogs but know that so far everything Iv'e found either works only for non-table objects (i,.e. Views, Stored Procedures, UDF's) or does not work...

• This reply was modified 6 years, 2 months ago by YSLGuru.

Than you for the additional info/feedback Mike.

Thank you for the additional info/feedback Mike.

I think your right with the shrink file because the DB when backed up is still around the same size as when we had it ion prem.  I have another...

Jeff - Your links worked also and i will definitely give that a try now that IO know I should be able to do the restore.

You also may be onto...

Thank you Sue that worked.

This is certainly one way to drive users away from SQL 2016, make it hard to use the updates.

It might help if I just include what I am trying to achieve. I am trying to restore a copy of our DB from our cloud vendor and when I...

Chris

I knew there was something about that damned statement that bothered me but I could not see it (i.e.  forest for the tress). I was soo hung up on the...

That's it. Its difficult to modify DDL and get everything. I'd rather post the original/unaltered but can't do it.

There is an ACCT table and just like the CHILD_TABLE if you...

I used the Script to New Window feature in version of SQL Mgt Studio we have access to in the vendors cloud to quickly generate the DDL. I changed only...

John Roberts- Not sure about the errors, I don't get these when I use any of the code I've included. The 2 CREATE TABLE statements and the DELETE all work.

Thanks

John

Assuming I understand correctly you are in agreement with me in that assuming the setup of the 2 tables I've shown the included DELETE should never find anything to delete...

Just wanted to let everyone know who has taken the time to reply that I figured it out with everyone help. What had me hung up with PIVOT was the...