ALTER TABLE incorrect tool-tip
MikeyC
Posts: 249 Bronze 3
With this code:
If you hit ctrl-space it shows information about the media_set_id field in the BackupMediaSet table. The field doesn't exist in the BackupFile table so there should be "no suggestions" like there is if you take the d off the end. (It only appears to show incorrect suggestions if the field name is an exact match to a field in a different table.
ALTER TABLE msdb.dbo.backupfile ALTER COLUMN media_set_id<cursor> VARCHAR(10);
If you hit ctrl-space it shows information about the media_set_id field in the BackupMediaSet table. The field doesn't exist in the BackupFile table so there should be "no suggestions" like there is if you take the d off the end. (It only appears to show incorrect suggestions if the field name is an exact match to a field in a different table.
Comments
Thanks for contacting us. This is an odd problem and I don't have an explanation for it at this time. I'll log a bug about it and let you know what happens.