Hi,
Thanks for the comment.  In our case, an iterative DBCC CHECKFILEGROUP approach seems to be okay.  We run the same version of my script at both our live and DR...

Hi,
Thanks for the reply.  Yes, the same options are used in both cases.  I thought CHECKALLOC was the only single threaded part... and as it's done by both CHECKDB...

anyone? 
thanks

Yes, thanks. I have seen that one...

Anyone have any thoughts?

Hi,

Thanks for the response.

SQL Server version

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit)...

http://stackoverflow.com/questions/1059105/how-to-remove-server-name-items-from-history-of-sql-server-management-studio

https://msdn.microsoft.com/en-gb/library/dd352356.aspx?f=255&MSPPError=-2147217396

Presuming you're in a Windows domain, give the account that's running your SQL Server services permissions in AD to read/write service principle names, restart the services and they'll...

on the datasource for your report (via the SSRS website), you need to put stored credentials in there

like mentioned before, if the SSRS end is ok, it's probably their permissions (or lack of) in SQL Server that's the problem

Hi,

Yes, in the datasource, enter domain credentials of an account that has permissions to read data from the database the report's querying. This will have to be static credentials...

Subscriptions are generally unattended, i.e. the report is executed in your absence. Therefore, you need to provide credentials for the time it runs off the subscription's schedule.

try putting the following at the top of your proc

set FMTONLY off;

If you're talking about SSRS, then no, you can't turn that off for a multi-value parameter.