NO!

....

Ok.  You cannot ship logs from 2005 - 2000 period!  Now you can ship logs from 2000 to 2005 (Not sure if  you can do it with the MS products...

$10k for a Server Class 64Bit system, with Raid Controllers?  How much memory are we talking about.  If less than 4G, perhaps you don't need 64bit.  Does that 10K include...

oops, I apparently quoted the wrong message....

Not sure you have read many of my posts, but you situation sounds very similar to mine. ...

Didn't I say, there are several that will disagree with me.  The examples given are the standard ones.... Only one field to reference the column. ... What if I want to...

The following does a much better job explaining when/why to use table variables.

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/18/11-0-temporary-tables-table-variables-and-recompiles.aspx

Also, be careful not to get into optimization overload.  I still suggest that you spend time optimizing...

From what I recall, that error is basically an I/O type of error.  usually related to either being unable to access the database that is being backed up (offline), or the...

Enerprise Manager is very similar to Oracle's Enterprise Manager.  Look into the Agent.  You can configure all sorts of alerts that look for Errors, performance conditions, etc. 

Read the Books...

Exactly.  However to see what A Pivot of that data would give you;

DROP

TABLE #a

CREATE TABLE #a

After re-reading your post.  There is something wrong with how you configured Database Mail.  Not sure what yet, but the error message below is where I think the issue is. 

Up to this point Loner, I have felt for you.  Unless you are consulting, going through 4 companies in 6 years!  I think there might be something wrong in the...

First of all, there is rarely a good reason to shrink the DB.  It really makes things ugly on the inside. 

Next point is one only has 4 Gig free in...

I agree! 

If you are calling the procedure, why are you passing a string.  Why not just insert the values into the table directly?  To say it kindly... This is...

oh well.  That makes it hard   Because there isn't a row_number, or dense_rank either.  Hmm. 

I often forget where I am, and don't...

Ok.  I Figured out what you want:

DROP

TABLE #tblA

CREATE

table #tblA

(

ItemNumber INT

Scott,

I once came across that same sort of situation.  The DBA had all sorts of certifications.  Was a professor at a college.  Could quote line for line the documentation.  In...