5 SQL DBAs for

~30 production instances from 2008 to 2014 (mainly 2012)

~25 pre-prod

~10 QA

~45 test/sandbox/dev

~1800 DB up to 2TB (total ~70Tb)

Windows clustered instances, Availability Groups, Transactional replication, log shipping, mirroring,...

The problem is that as Microsoft said, (http://msdn.microsoft.com/en-us/library/dn178483(v=sql.110).aspx), I must apply the SP to the secondary replica first, but on this server, databases are in read-only mode !!!

... after applying the SP2 "SQLServer2012SP2-KB2958429-x64-ENU", there is the above message in the SQL Server log !!!

what do you want more?

ok so, for me, it's "manually" and I don't know how is it possible manually.

Otherwise you can do this with a script (PowerShell).

Take a look here : http://epmframework.codeplex.com/

And see the...

No,

How are you run the check of your policies?

thank you Andrew,

I had looked but I hadn't seen the event "CREATE_LOGIN" !!!

:blush:

hello,

just add the @@SERVERNAME

SELECT

s.server_name as ServerName,

ssg.name as GroupName

FROM [msdb].[dbo].[sysmanagement_shared_registered_servers_internal] s

INNER JOIN [msdb].[dbo].[sysmanagement_shared_server_groups] ssg

ON s.server_group_id = ssg.server_group_id

UNION

SELECT @@SERVERNAME, 'Sql Server'

Is there a way to edit the system functions?

As the system procedures in the database mssqlsystemresource, because I can see them but can't generate script !!

I would like to know...

no, I don't tried create/drop login because now the problem is solved

I do not know how, I just deleted and created some other logins and it seems that synchronization...

I done some tests on a dev environnement and in the master.sys.sysxlgns there is only logins that are defined on the server, I dont see logins that are connected via...

I checked in tempdb and saw nothing special: (

I checked the CREATE VIEW [system]. [Server_principals_new] but it uses system tables that are not queryable as master.sys.sysxlgns, sys.syspalnames... !

For the reboot,...

you don't have an idea of the name of this table or view?

Ok it would be a workaround but why that happens?

Where SQL finds this old login?

Hello,

the problem is that the login is not defined directly on the server, it's a member of a Windows security group and this is the group that is defined.

So I...

Hello,

thanks for your reply but what I really like is doing nothing on the subscriber, as if for him nothing had happened on the publisher.