I know this is an old article, but I figured I'd give a reason why you should disable indexes.

Not all organizations have the ability to have dbs for applications and...

Yes.. SSRS doesn't function with passing multivalue params to procs out of the box.. however, with some minor code efforts you can do it..

if you wanted to build a report...

FYI, hyperlinks are available in charts.. I know it for a fact since I demonstate this all the time with custom reports and MS even has this in a sample...

The permission you need to see the report bulder button is called "Execute Report Definitions" and it is available to the system users role in SSRS under site settings.

FWIW..

Even if you could add a SQL 2005 box to a SQL 2000 cluster, if it ever failed over to that machine, the dbs would be converted to SQL...

Technically, there are 2 right answers to this question.

The SAC tool allows you to enable remote connections by enabling TCP/IP or Named Pipes, or both. However, the SQL Configuration...

If you have multiple instances, I'd use SSIS.. you can call the package from a procedure and pass it parameters.

The package can then loop through the statement across all servers.....

You can achieve this in a number of different ways..

The question is where do you want to put the processing. If you create a dynamic dataset and parameters, then...