In my experience reporting services has a lot of trouble with temporary tables. If possible wrap the code into a stored procedure and have RS execute the procedure.

Wow, what the heck do you have to store that takes so much space???

I don't know of any way to disable that warning, however I would caution you against the...

Wow, what the heck do you have to store that takes so much space???

I don't know of any way to disable that warning, however I would caution you against the...

Doh, I totally misread...

I'd create a table with the columns specified in the result sets from BOL for sp_spaceused. Then you could do something like this:

EXEC sp_msforeachtable 'INSERT #spaceused...

Temporary tables are created in tempdb so you'd have to execute it there... i.e. exec tempdb..sp_msforeachtable 'sp_spaceused ''?'''

Your subquery would acts like a virtual table. Tables need to be referenced using the FROM clause in this case. You'll need to not use WHERE IN but...

The problem is that your target table has a primary key which enforces uniqueness across a certain set of one or more columns. You can do a few things...

Look into using the LEFT() and CHARINDEX() functions to search for the results of CHAR(13) which resolves to a new line.

That should get you started.

Yes, it's normal for it to stay in the earlier compatibility mode in my experience. If you update it to compatibility mode 80 it will open up the ability...

I've used XP_SMTP before and found it's pretty darned cool. But if you want to receive e-mails in 2000 you're going to want to use SQL Mail. But...

You can use it in combination with an IN statement. I see it frequently like this:

wHERE a.mycolumn IN ( @MultiSelect )

Jeff brings a good point (I was in a meeting while responding the first time so I'm sorry if I was brief). The issue is that if you're noticing...

I would suggest a defrag of the indexes. Rebuild them if you have a maintenance period. Statistics are great, but good statistics on a bad index is only...

Agreed, this reeks of troll. All the same, I usually try to be helpful (with varying degrees of effectiveness); I'll take down my sarcastic comments from the other thread...

Methinks this is a Friday joke... 😉