In addition to the security update described in bulletin MS11-049, this security update also contains all the updates that are included in cumulative update packages 1 through 7.

Anyone got...

Good question I'm moving to Always on soon. I would like to know the answer to this too. Something I have been thinking about too.

Run this

SELECT net_transport, auth_scheme

FROM sys.dm_exec_connections

WHERE session_id = @@SPID;

See what Authentication method you are using.

And you are sysadmin on both servers?

Looks like Keberos issue. Cannot hop you credentials between servers.

All sorts of things to look into.

Server Principal Name's etc. Accounts need to have delegation...

What about the other acoount used for the APP. I imgine they are both domain accounts.

Do you use Kerberos in your environment.

What happens if you use the 'Be made using...

Try granting the SQL AGENT account read access to the remote db in question. The job will be running with those credentials.

Deos the account that runs the SQL agent have access to the DB on the linked server.

Ok, if my secondaries go offline. Can I bring them online

manually and turn one into the Primary.

Thanks, does this apply to when the Primary db falls offline too.

Lets say san administrator removed the disks that held the mdf and Ldf files. This would also force the...

Yes they too have been altered via the GUI.

No. But the restore works via T-SQL with no amendments to the logical names.

Funny issue.

Do you have backups in a shared folder for the AOG databases

Thanks.

Top transaction report doesn’t always report the sproc that is causing the issue.

If the problem sproc in question has increased and is used very often it may not appear but...

select so.name, resource_database_id, Resource_associated_entity_id, request_mode, request_type, request_status,request_session_id, GETDATE() from sys.dm_tran_locks tl

inner join sys.sysobjects so on so.id= tl.resource_associated_entity_id

where [resource_type] <> 'database'

--and so.name <> 'Table_1'

and so.name not like 'sys%'

Try this...

EXCELLENT!!!!