Just to add a potentially helpful tidbit.. your backup history tables are an awesome resource to go back and report on database size/growth. If you need to report on...

If it's not possible or logical to consolidate the jobs, you can have the last On Success step of the first job run sp_start_job to kick off the next. ...

First to eliminate the easy stuff; Are you sure you're using 64bit Windows? Is perhaps your installation media for Itanium not x64?

Do you get an error/screen during...

Regarding Tom3w's question: "Technical tidbit: if any db is case sensitive, the tempdb must be too. Can anyone verify or refute that (for SQL 7.0 and higher)"

In SQL...

Brilliant idea - let your users enter data that could (and should) be in a fk table and provided in a picklist! (golf clap) Even more brilliant than allowing...

I love reading the references to case-sensitivty being a problme due to dba's/dev's spelling columns as "CustomerID", "customerid", or different variants of it. In a case sensitive environment that's...

Case-insensitivity is really just a case of taking the easy way out. A well designed database and app wouldn't let the user enter "Fl", they would pick the correct...

On a side note, I think that in the original query if you qualify the sort column with the table name - sql should know to sort on the table...

How about, create views on the tables you need. Taking into consideration including only fields you need and naming them with teh required names - then using For Xml...

Your comment of: "The recommendation I have heard most often (and the one I use in my Production environment now) is to set the number of processors available to use...

That's an interesting approach. I've devised a system where i have a table storing job and step id's, recipients, and on_success/on_fail fields and a trigger on sysjobstephistory. Though...

That's not correct. You can upgrade MDAC's, but attempting to install an older MDAC will not downgrade. Removing MDAC's is a manual process; http://msdn.microsoft.com/library/en-us/mdacsdk/htm/mdac_faq.asp?frame=true#mdac_faq_remove

Umm, make sure it's using TDS 8.0? Is about as much advice I can give you. I've had success using freetds and also UNIXodbc to connect to SQL...

Before reading these posts, my recommendation would be to use linked server names that can be used in both production and test.  For example, if you needed to access some...

You would define your axis' in columns instead of cell ranges (A$ instead of A1..A51).  Also, I set up routines to copy a template over the spreadsheet/linked server then name...