I appolgize for not being clear with the issue, i was off in what i was looking for it was a problem within the .net code. So even if someone...

Resolved

Thank you very much I was able to get the query to perform.

When i run the command the select file_id, name, type_desc from sys.database_files the output is this:

1AdventureWorks_DataROWS

2AdventureWorks_LogLOG

3fg0103SALESROWS

4fg0406SALESROWS

5fg0708SALESROWS

65537sysft_Cat1FULLTEXT