Glad you found the cause.

One thing I had problems with on a Cluster before - and it took months to sort out - was priority boost.

The cluster had been set...

Hi,

do you have any other error in the SQL error log or in the windows event logs at around the same time?

Seth

I use this for date parameters:

Select Right('0' + Cast(Day(dateRange) as Varchar(2)),2) +'/'+

Right('0' + Cast(Month(dateRange)as Varchar(2)),2) + '/'+

cast(Year(dateRange) as char(4)) as label,

dateRange as value

Then in Report Parameters...

As per Cliff Jones

The answer should be 12 not 22

(I see I missed the Set followed by Select

set @b-2 = ' '+@a + 2

select @a...

I got this right because I read the question quickly and didn't notice the missing columns.

However, I have gotten these questions wrong before where there were deliberate 'mistakes' like this.

...

We use Redgate's SQL Compare.

You can generate a script for all the changes - eg from UAT to Live.

You can also run the same compare to get a script from...

Thanks for the warning - that is the sort of thing I have been caught out on before.

I am running this in SSRS and it is working fine for me.

I...

Spot on 😛

Thank-you

Seth

OK Peddie you got me searching for more config info.

After reading to the bottom of the page in the link you provided I saw that the email To filed is...

Thanks Gift Peddie

The problem isn't with subscriptions or sending emails as such.

For example - I have Content Manager Rights and I can subscribe ok.

This is what happens:

Click on subscriptions...

Thanks Ian - that might be just the sort of thing I am after.

If I start using powershell it might be useful to replace some of my old scripts I...

Hi Phil

Yes - the vb part just copes the file.

I have a couple of sequence containers that have the 3 steps 1 and 3 are TSQL backup and restore tasks...

Hi Dan

Sort will probably use TempdB - but normally having an up-to-date index and stats will remove the need to do this as they already have a record of the...

Also data imports will use tempdb (espically Bulk inserts) - but the point I want to make was: sortintempdb for an index will only affect tempdb when they are building...

Hi Dan

I appreciate developers using temp but that is not because the index has sortintemp enabled. It is going to be because they are creating and using tempoary tables.

Seth