There won't be any foreign key dependencies, so I guess you're mostly thinking of sps and triggers. This will find references from the current DB to another named DB selected...

A hint on using UNION -

Since you won't be returning any duplicates, and since you aren't ORDERing the data, you should use UNION ALL to improve performance. Otherwise SQL...

Maybe try a computed column?

Create the 'stub' of a temp table (say, just an identity column) with a standard name before calling the stored proc. Inside the stored proc you could add the...

If you have off-peak times, you could try using a timestamp column on your production tables to identify new/modified rows, then extract the new rows every night. This should minimise...

David

quote:

---

For problems like this cursors seem the best bet as trying to build a dynamic query can sometimes exceed variable size limits....

oops - I don't know if you are reading any of this, but I commented some bits of the code out in the version I posted - the WHERE clause...

I've just used the code for this problem as an example for the junior DBA I am currently training - in the process I fixed a couple of errors. The...

You will need to use dynamic SQL. I haven't tried the code below, so there may be errors, but it should give you the idea.

declare @attid int, @attname varchar(255)

declare @sql_start...

Not sure about this, but you could try just changing the '7.0' on the first line to '8.0'. The equivalent works for upgrade from 6.5 to 7.0, so worth a...

I can't see any problem which would prevent this statement from parsing. You don't have to supply an 'else' clause.

Did you definitely copy and paste exactly the correct code?

I guess...

JeffDyer's point does not rule out using views, only SPs.

Some queries may require stored procs, of course, e.g. crosstabs, returning lists of values in a single field etc., so with...

look at:

@@error

set xact_abort

transactions

sysmessages

in BOL

Are they really the same attribute? There may be a logical design issue here. Can you explain what the attribute is?

I think you might want to decompose the property_type table. Why is language_id included in the PK?