3
votes
Accepted
Unable to alter CDC tables
Cause
This has never been supported.
From the documentation (emphasis added):
For CDC to function properly, you shouldn't manually modify any CDC metadata such as CDC schema, change tables, CDC ...
- 90.2k
1
vote
transactions without a corresponding session in sql server
My guess is that they belong to internal sessions used by SQL Server engine. I have an instance on my desktop, which I just started in order to check that, and after executing that same query the ...
- 5,926
1
vote
Accepted
Sql Server: Query to parse and validate codes
One relational way you can do this is by splitting your #SourceData first (fortunately you have access to the STRING_SPLIT() function despite being on an outdated version of SQL Server), then getting ...
- 39.5k
1
vote
Sql Server: Query to parse and validate codes
-- first thing that comes to mind:
SELECT
sd.ID
, sd.Codes
, CASE
WHEN NOT EXISTS (
SELECT x.[value]
FROM string_split(sd.Codes, ';') as x
...
- 49
Only top scored, non community-wiki answers of a minimum length are eligible