HI Jeffery

I feel pretty dumb for not trying the disable. I did remove the DB's from the user on the primary and noticed that then they were removed from...

Using Windows Auth - you don't need to create a login on the primary node, only the secondary node.  Then - create the user in the database for that windows...

Side note: take a look at DATEFROMPARTS and DATETIMEFROMPARTS instead of concatenating strings and converting to datetime.  For example:

[Date] = DATETIMEFROMPARTS(year(DateOfServiceFrom), month(DateOfServiceFrom), 1, 0, 0, 0, 0)

Or...

I don't know of any way to do what you are asking - nor would I even try doing that.  I would look at ways to improve the performance of...

Not sure what you are getting at...

If copying to a new table -...

• This reply was modified 3 years, 4 months ago by Jeffrey Williams.

The data in the log file is used to roll forward and/or roll back changes that were in progress during the backup.  Once that process has completed - the log...

I would probably set this up with 2 packages in the project.  The first package uses a script task to traverse the folder(s) where the zip archives live - using...

You could add them to the SQLAgentOperatorRole - that would allow them to start/stop local jobs.  You really need to review this document: https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-ver16

I would not - under any circumstances...

One other note - if this was something I was developing I would not build this in T-SQL.  I would use Powershell to get the list of instances and use...

Are you looking at running this from an agent job or within a stored procedure?  If so - then you need a linked server and you can either use 4-part...

• This reply was modified 3 years, 4 months ago by Jeffrey Williams.

Yes - it can be done but you have to write some C# code in a script task to open the archive, loop through through the results - and extract...

What I meant was after this file was generated I could alter the output to correct the issues. The initial creation of the file was some generated process from...

Do all of the files have a similar issue?  Perhaps you need to tweak the code to handle the anomalies.  Frederico offered a hint about that above.

And, no......

Another con is managing how long you keep history in the versioned table.  There are several options available - and each one has significant requirements that need to be designed...