Azure Data Studio does not recognize schema changes until I close and reopen
0
votes
0
answers
117
views
I've been searching for an answer to this, but no one seems to be asking exactly this question. I created a Notebook in ADS to run a lengthy series of scripts to populate and then export from a temp table. I received an error
String or binary data would be truncated
. One really nice thing about ADS is that it tells you *what* data would be truncated! Anyway, the string was 101 characters long, while the column was defined as varchar(100)
. So, I increased the column to varchar(255)
in SSMS. But ADS continues to give me the same error. I tried changing the connection to another DB, then changing it back - no joy. I tried disconnecting and reconnecting the DB - still no joy. Finally, I had to close and reopen ADS before it would recognize the column change. Any ideas why this might be happening, and how to correct it? Because it's not terribly useful this way.
Asked by CB_Ron
(291 rep)
Aug 17, 2023, 07:25 PM