Unfortunately it's a pretty large table, about 40gb; and as always, the business can't afford downtime to drop and readd it. So I'm reserving that for a last resort scenario.

Ah OK. Well, I only really started looking into it after porting some code that was using the performance counters for the pools from an enterprise edition, which was doing...

OK thanks for the reply. Any ideas on what to look at to troubleshoot? Would trying to run the disable resource governor alter statement reset it all, or would that...

OK, thanks for the clarification.

OK thanks. So, just to clarify how the out of row data for a varchar(max) works on an nci with it in the included column; is it as follows...

Yes, I've manually added the account as sysadmin role.

It seems like the permissions that should be applied when adding the account to run the agent in the Configuration Manager aren't...

Hi Bob,

Yes I installed with that account.

As a test I've also tried changing to the local system account and back to the account using SQL Configuration Manager; at the end...

The only other messages in there are the successful start/stops when I add the account back to the administrator group and restart, along with the change in Agent XPs option.

Without more information this is difficult to assist with, or even ascertain if there is a problem. What sort of locks are you receiving, what's the workload on the...

Yes that's what I was expecting. Going to have to work out another way around the problem, I think.

Hmm, it just seems to diminish the point of deny against simply not having permission, to me.

I understood that ownership chaining worked when a user didn't have an explicit grant on an object, but not when they had an explicit deny. I very rarely use...

Yep, that was the problem. I've uninstalled the default instance and replaced with a named instance; but otherwise using the same configuration (the new named instance is the same...

Indeed, usually the way to get stuff done!

Ok, so after a quick test changing the port for the named instance, this is now clearly only listening on that ip and...

Is that true even though they're using different IPs?

Basically what I'm trying to achieve is that both instances will appear as the default instance on seperate DNS entries for those...