I have a process querying this table every 20 seconds
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid from [MyDatabaseName].[sys].[filetable_updates_1991678143] with (readpast) order by table_id
I only noticed it by chance in SQL Profiler when checking something else.. I have 20+ databases, named TEMP_xxx, which I had restored earlier and the query was being run against all of them, every 20 seconds. It was only running against those TEMP_xxx database and one other (real) database (plenty more database on this server/instance)
I had intended to set all the TEMP_xxx databases to READ_ONLY so decided to do that and (might be coincidence) having set them to READ_ONLY the query stopped - but it is still running against the one, real, database (i.e. the one still set to READ_WRITE).
The table [sys].[filetable_updates_1991678143] does not exist in [MyDatabaseName] (as in: I get an error if I attempt a SELECT * FROM).
The phantom query is always run by LoginName=sa, ApplicationName="", SessionLoginName="" Diffrent SID each time.
Nothing useful came up on Google - or I'm not asking the right question!