Comments
Sort by recent activity
Good Morning Eddie, I still don't think you understand. See #1 in my last reply. The WHERE clause on the Index IS in the script AND on the DB Table. How can I send the files to you? / comments
Good Morning Eddie, I still don't think you understand. See #1 in my last reply. The WHERE clause on the Index IS in the script AND on the DB Table. How can I send the files to you?
To simplify: 1. Our scripts folder is the source. It does contain the filter on the indexes. 2. The SQL Server DB is the destination. The table in the DB contains the filter on the indexes too. 3. When I run SQL Compare, it says that the source file does not contain the filter. 4. I thought maybe it was a visual thing and that SQL Compare didn't really think there was a difference, so I deployed. When I did, the filter was removed in the DB. I will send you a .zip file with the file from our scripts folder AND the DDL from SSMS. Where can I send it. Also, if you want to hop on a Teams call, I can show you. Thanks! / comments
To simplify:1. Our scripts folder is the source. It does contain the filter on the indexes. 2. The SQL Server DB is the destination. The table in the DB contains the filter on the indexes too.3. Wh...