Schema name added to built-in functions

v3.5.30 SQL

With Always Fully Qualify Object Names set to "With Schema Name", attempting this:

Set @ID = SCOPE_IDENTITY()

results in

Set @ID = dbo.SCOPE_IDENTITY()

I'm unable to reproduce this. Can you describe step by step how this text was entered?

Also please check that SCOPE_IDENTITY is listed as a system function in the SQL Assistant Options -> DB Options tab -> SQL Assistance section on left -> SQL Server -> Custom Assistant section (expand on right)

Declare @id int

Insert dbo.Table1
VALUES(@ID)

Set @ID = Sco<Enter>

I'm still unable to reproduce this. Does it happen for other system functions?

Yes it does happen for both and functions are listed under custom assistance. Are you using the same version and "With Schema Name"? If I change "Always Fully Qualify Object Names" to None, the problem disappears.

The behavior seems to be inconsistent and different in different targets and SQL Assistant versions. I am not quite sure how exactly this feature is supposed work, but prefixing system function with a schema name is surely incorrect. I submitted a bug-check issue in the internal tracking system and expecting a response from the development team.