sql server dts: References to deleted objects -- sql server dts

References to deleted objects

Tim Vernon
4/21/2004 1:10:43 PM

sql server dts:

Hi all

I have a problem with an SQL Server db, which is proving quite tricky to
solve.

I deleted a table dbo.Addresses and created a new one dbo.AddressesV2. I
changed all the relationships with other tables to reflect this change, and
the db runs without a problem.

The problem rears its head when I want to copy the database with DTS to
another SQL Server. I get a "Import failed" report at the end of the job:

"Invalid object name: dbo.address"

So somewhere in the database, there is a reference to the old table. I've
looked through all the Sprocs and Views but can't see it.

Could anyone suggest a way of identifying where the reference is, so that I
can amend the necessary part of the db?

Thanks in advance

Richard

Re: References to deleted objects

Allan Mitchell
4/21/2004 1:18:24 PM

How about scriptng the whole DB and then load the script into your favourite
text editor?

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]