I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it and had it in the background. I’ve randomly been asking questions as I need to look up things. I’m mostly curious how well it works.
This week I asked about CDC and got and interesting response.
This is part of a series of experiments with AI systems.
Updating a CDC Schema
I asked this question of my local mistral model: How do I alter a table in SQL SErver that is being tracked by CDC to add a new column?
That might not be the best way to phrase things, but I was on a call with a customer who was going to enable CDC and wanted to discuss how to manage this with schema changes. I’m not a CDC expert, so I was checking some documentation while chatting and decided to put this query in.
I got these results,
I thought I’d missed something, as I had never heard of sp_cdc_refresh_schema. Sure enough, I didn’t see it on MS Docs.
If I were trying to do this (pretend I’m a copy/paste DBA), I would see this:
So, the next step is to call the AI on this. It finds that it hallucinated and give me other ideas.
It gets worse. Now I create a proc and insert into the system tables, which isn’t recommended.
This won’t work either, but I can see people trying this.
First, if you get advice from the Internet, please always, always use a sandbox to test (what I also recommended to the customer), and second, treat any AI response like it came from a teenager.