New answers tagged sql-server-2008
0
votes
Accepted
Always on high availability groups option is grayed out
You cant do that.
From Microsoft documentation:
Prior to SQL Server 2017, and Windows Server 2016, the instance had to
reside on a Windows Server Failover Cluster (WSFC) node to enable the
Always On ...
- 948
0
votes
Capturing datetime of change in SQL Server CDC
Inspired by Gareth's answer, here's a shorter version. This doesn't use DECLARE which is great if you need to create a VIEW (DECLARE isn't allowed in VIEW)
SELECT
sys.fn_cdc_map_lsn_to_time(__$...
- 9
0
votes
Syncing data between onprem and Azure SQL
Keep in Mind that Azure Data Sync Does not accept computed columns in the tables involved in the data sync!
Top 50 recent answers are included