If you look at the entire quote from Inside SQL Server 2000, it goes on to say "In previous versions, SQLServer only logged the fact that an index had...

Yes, the CREATE scripts are both identical. I'd have expected that since the copy table was created using SELECT * INTO ....

Okay - I've duplicated your problem.

In my first example, my SP code was using straight SQL to access the non-existent table.

If I change this to also usse dynamic sql, then...

No, that shouldn't be necessary. Look at my example - I do exactly the same as you and it works perfectly. In fact, it's precisely what you SHOULD...

Only just noticed - this seems to be EXACTLY what you are doing in your example. I have no idea why your code doesn't catch the non-existent table error,...

Just modified this slightly to use dynamic SQL. It now appears that both the return status and @@error are populated (which did surprise me slightly):

declare @sql nvarchar(2000)

declare @error int,...

I'm not sure if you can do this for dynamic SQL as in your example, but you can certainly do it for stored procedures. Interestingly, I was just...

Use named parameters

e.g. exec procname @param1 = n, @param3 = x

Thanks to everyone who has contributed to this.  In the end, since there appeared to be no guaranteed solution (as can be seen from the variety of replies that this...

Actually, I got that wrong (I'm pretty new to Arc software).  We're using ArcGIS.  Same question still stands though

Thanks for that, Jean.  That's a very useful bit of information to know.  We're actually using ArcGSE, not SDE (although this still uses the SDE gateway as an entry point). ...

The only problem with that, Dave, is that it makes it very difficult should we ever want to share data between the 3 databases.  I know, if we do want...

So how did it go? 

Sorry - I just can't go along with that, John.  In anything close to a complex application with potentially hundreds of stored procedures you can't tell me that you've got every...

Hi Bill,

Thanks for the reply, but sadly I don't think it's that simple.  I don't have access to the source code (if I did I could think of a few...