Can anyone tell me how to create a SQL View to a NF Table where DataPerCompany is set to Yes. I know that the normal SQL syntax is SELECT * FROM Database.dbo.Company$Table I can’t find the table in Tables i SQL Server Enterprise manager.
I found the answer. SELECT * FROM Database.dbo.[Table]