Regarding temporary tables - if you dynamically include the user's login id in the temp table's name, you not only allow for multiple temp tables simultaneously but you also add...

Before you reach for a book tutorial with CD, start with looking for online tutorials. They will give you the rudimentary basics. Once you have the basics, then...

Is there any chance that the problem is on the AS400 side?

As a general rule of thumb, GLOBALLY, spaces in the middle of a name will either cause processes to not work as expected or force additional formatting and keystrokes to...

If you want the whole book on the migration, here's the link for SQL Server 2005 Upgrade Handbook:

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

I think it would depend on when / where you actually receive the parameters that filter the report. Also, how you would redeploy them the next time, and whether...

Grab a grain of salt. Ready? Upgrade to 2005.

Michael is right - you need to build your own enforcement mechanisms.

Alternatively, does it make...

and what did you answer? were you being interviewed for a newspaper or magazine article, or for a position? what type of position?

Is there a question you'd like...

As a general rule, when 'cascading' inserts, you need to use one or more triggers in order to preserve the correct associations across tables.

I am concerned when you specify that...

Are you experimenting with technique? or trying to manipulate information on columns? building a script? perhaps trying to do column operations without using set-based SQL? What's...

Sounds like the difference in operating systems, not in the hardware, to me. It's a thought.

someone go off on vacation? or worse?

Are you getting an error message? no results? anything? What are your symptoms? Any hints at all?

Translation, translation, translation.

I know you believe that you understand what I said, but I'm not sure you realize that what you heard is not what I meant.

You MUST...

You could modify the query that feeds the app by using TOP n. Your app may not work correctly, but at least it won't die.

More likely, the query has...