Our OS patching is handled on a regular cycle with SCCM.   Windows patches are more frequent and regular than SQL patches.

SQL patched are done through SCCM, although there is a...

You can only upgrade 2 versions.   So, 2005 you can do an in-place upgrade to 2008 or 2008 R2.

BUT, guess what.  2008 and 2008 r2 are also no longer supported.

I...

Maybe.  He may be the owner on one node, and not on the other.  I've had that situation.

No, it can be set to read only.  There are no other options.

If you need to have two separate databases that need to be in sync and allow read/writes, you...

Thanks a lot! I really appreciate to everyone and it's very helpful.

Question regarding data synchronization. Actually we are migrating data from different database system to SQL Server which would...

BCP does not go from table to table.  It is an import/export utility that goes to a file.

If you are going from table to table, why won't T-SQL work?

Sure.  Try it.

Some sample code:

DECLARE @cmd varchar(1000) = 'BCP DatabaseName.Schema.Table OUT C:\BCP\ExportStuff.txt /m 100 /b 100 /e ExportStuff.err /c /r\n /t, /S ServerName /T'

EXEC xp_Cmdshell @cmd

Why do you want to...

I would not utilize read-intent for this scenario - that really should only be used for offloading application reads and is not intended to offload reporting users access.

Instead -...

No, there is not a simple way unfortunately.  Unless someone knows something I don't!

Create the read-only logins on both servers, disable them on the primary.

I set up a script to...

I would probably use BCP.

Or, you could download SQL Search and use that!

Thanks. I am looking for HA option with Automatic failover in the event of a system outage instead of manual failover. How about preferred methodology for patching if I...

When shutting down the whole farm environment with two nodes in Failover Cluster/AG, my thinking is to shutdown secondary first and then primary. When bringing up, start with primary...

You are right there The Dixie Flatline... the ROLLBACK rolls back all transactions.

Not sure why I thought it only did the most recent one.

COMMITs happen per transaction though.  So...

Hi,

Can you please let me know what is the benefit of using the 'SET IMPLICIT_TRANSACTIONS ON' in the below code when we already have 'BEGIN TRAIN' which can be...