That was a smart solution Sean.

I've implemented this approach in the script now. Thanks for much 🙂

ok, thanks for the clarification.

I'll try this at work tomorrow.

Thanks very much for your help so far!

I'm at home now so I haven't got access to SSMS, but I've read through your code and I think I can see...

Ok, great. Let me take a look at your solution ...

Here you go ... hope this helps ...

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#Question','U') IS NOT NULL

...

Yes, I see what you mean. Let me see if I can clarify:-

I guess the question I need to answer is:- if I'm going to insert a batch of...

Thanks for the explanation, I think I see what you're saying.

I'm surprised there is such a limitation because I thought that actually it was common for there to be a...

Still not seeing it :unsure:

I've searched that article for "resolution" since that seemed to be a key part of what you were saying, but I only found references to "deferred...

Which link in that reference should I follow for...

Sorry, no idea how I managed to post in this part of the forum !!??

I've re-posted it in the 2008 General one.

I'm looking for the Delete option to get rid...

Awesome! I have just run the upgrade on my box and now Profiler is R2 and it all works perfectly!

Amazingly, we were actually able to use profiler (2008) against...

I would go with the second option but do away with sequence numbers. Use shadow tables instead.

I've got this to work:-

sp_changeObjectOwner 'dbo.GetSalesPurchaseOrder', 'sales'

This changes the owner, and when the existing apps connect with that owner information everything works ok.

I very much doubt there will be any performance issue from using a flag in...

I think it's worth pausing for a moment here and looking at what is actually needed.

I.e. what volumes/relationships exist in the data and how exactly is this going to be...