Hi Dhan,
To find polygons that SQL Server considers invalid, execute the following in SQL Server:
SELECT * FROM <table_name> WHERE <geometry_column_name>.STIsValid() = 0
Where <table_name> is the problem table and <geometry_column_name> is the name of the geometry column within that table.
You can make them valid (according to SQL Server rules) by executing the following update:
UPDATE <table_name> SET <geometry_column_name> = <geometry_column_name>.MakeValid() WHERE <geometry_column_name>.STIsValid() = 0
------------------------------
James Nolet
GIS Manager
Caf Consulting
Mentone office, VIC, Australia
------------------------------
Original Message:
Sent: 01-21-2025 19:34
From: Dhanushka Sandanuwan
Subject: Erro loading polygon in MapInfo Pro
I was getting the following error message.

Then I added "MI_STYLE" column in the SQL Server using the following script
ALTER TABLE <table_name>
ADD MI_STYLE varchar(254) NULL;
Now, I'm able to add the polygon layer to MapInfo. However, when I zoom in or pan, I get the following error message

Please advise
------------------------------
Dhan
VIC, Australia
------------------------------