Speaking of which recovery mode, much of that depends on what your responsibilities/ SLAs are for each of the databases you support. If you don't require the ability to...

If you're having issues after installing a patch typically the call to MS PSS is a free one. Obviously you'd want to run it up through management first in...

I think I'm still a bit confused. I put a single list control on my report then added the sub reports contained within rectangles to the list. I...

yes obviously, however I didn't want to incorrectly size the varchar column as the OP had mentioned about both being numeric so no clue as to the actual length of...

since so much of the table would be included in your index it's possible that the optimiser wants to do the scan because it thinks it's more efficient than do...

I seem to be getting opposite results than you. I get nulls for the strings and a datetime of 1899-12-30 11:00:00.000 for the time. It seems the lack...

Just outta curiosity, what is this for?

salesin_no >= 199701 AND sales_in_no <= 199701

It looks like that would select everything in that column.

Depending on the order of the columns in your...

I'm using the idea tools as well to do monitoring. Although I'm in the process of augmenting that solution by writing some of my own.

-Luke.

Without know more about what you're trying to accomplish, it seems like this is the perfect candidate for a SSIS task, not a reporting services one.

how big is your log file, is it havinging to continually grow as the re-index operation is occurring? Also, have you taken a look at the index defrag command?...

if you don't wish to use rs.exe have you taken a look at subscriptions? Basically, you can set up a report to be generated and sent to you via...

I may have attempted your solution incorrectly... I tried to include all of my subreports inside of rectangles inside of a list control, however when I run the report it...

Right and it's not just about leaving the two columns separate, but in the same row (this breaks the first normal form, see the section on repeating groups http://en.wikipedia.org/wiki/First_normal_form), but...

So why not just have a lookup table that includes the Machine and a unit value.

If there's 1 unit just have 1 row, if there's 3 then use three rows....

I've never had much luck in passing multi valued params to a stored procedure and in those cases I've just pulled the query back into the RDL instead of having...