duplicate post https://www.sqlservercentral.com/forums/topic/change-password-for-service-account-for-sql-agent-in-active-active-cluster

answer given there

no need to pass anything as a parameter.

In each database just setup a synonym pointing to the corresponding log db and on your code you just use the synonym in...

not a problematic file at all - fixed positions for all columns so its easy to process.

Do NOT use the import wizard - you need to manually process the file...

• This reply was modified 6 years, 1 month ago by frederico_fonseca.

again you talk bollocks - OP is not worried about, neither does he/she cares, about how SQL decides to store the data - what matters, and it is a significant...

there may be a misunderstanding of what you consider a NULL value on the column - if a Column is NULL then there is no char to replace at all...

what type of replication do you have setup ?

if SQL Server replication then only the tables you select for replication will be replicated.

If SAN replication then all objects on the...

AG = Availability Group

WCF = Windows Failover Cluster

for more info see https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-2017

Adding to the above - if any one customer is "misbehaving" you can (and probably should on this situation) use Resource Governor to limit the use of server resources.

But unless...

Not sure about the correct answer to you so maybe others will give required feedback.

but why not drop the user completely and replace it with a GMSA instead? that way...

also take in consideration the SQL Server licensing - physical vs virtual isn't the same and having standard or enterprise also changes what you can do with it.

example using your...

Unless you already have a monitoring tool in place then there is nothing you can do to report past events

If you do have a tool then use it.

If not then...

what if it was the following?

Values (1, 12, '2019-09-01T07:00:00')
     , (1, 12, '2019-09-11T07:00:00')
     , (1, 11, '2019-08-15T07:00:00') -- one...

yes - that is what I said was wrong - both the 12/120 and the ()

It will depend on the version of SQL Server

If 2012+ then yes otherwise that db won't exist and will not prove that SSIS wasn't installed.

The only way to know for...

when the source data incorporates date ranges that span a few month they it is sometimes possible to analyse the data as part of the load process and see which...