With this code:
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.
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.