Comments
Sort by recent activity
@Jon_Kirkwood Thanks for your response. When I run any of these queries, I receive the error. Msg 220, Level 16, State 1, Line 2Arithmetic overflow error for data type smallint, value = 33304. Having the queries helped direct me in the correct direction. The issue is with the system views that Microsoft has provided. By querying the sys.syscolumns I receive the error because some of the columns have a colid (as well as another field or two) that is larger than the smallint. If I query the sys.columns the column_id field it is fine. In their views sys.columns.column_id is defined as int and in the sys.syscolumns.colid it is defined as smalint. Thus the issue. This has allowed me to trace down reported issue on MS SQL Server related to this error. I need to look at why preferences of using sys.syscolumns rather than sys.columns table / comments
@Jon_KirkwoodThanks for your response. When I run any of these queries, I receive the error. Msg 220, Level 16, State 1, Line 2Arithmetic overflow error for data type smallint, value = 33304.Having...
Any new updates if this will ever be moved into the backlog to fix. It has been hanging out there for a long time / comments
Any new updates if this will ever be moved into the backlog to fix. It has been hanging out there for a long time
Found the best response. Make sure you are using version 3.5 Link is here. https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe / comments
Found the best response. Make sure you are using version 3.5 Link is here.https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe
Found the best response. Make sure you are using version 3.5 Link is here. https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe / comments
Found the best response. Make sure you are using version 3.5 Link is here.https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe