microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.45k stars 734 forks source link

@sqlcmdRI variable short. #285

Open warwickrudd opened 1 year ago

warwickrudd commented 1 year ago

The @sqlcmdRI variable used for versions > 14 checks the sys.idex_resumable_operations view. However depending on the length of the DBName being checked the current NVARCHAR(100) throws an error with the above view not existing, as it is truncated. I have resolved in my local copy by increasing the size of the parameter.