Forum Discussion
Error was unexpected: Invalid Object name..
Hi Community, I have this error when I tried to switch to this server. Please advise how to resolve it. /The following SQL Error was unexpected: Invalid Object name: UAT Test.dbo.access contr...
In addition to olafhelper's comment, I wonder if that object reference needs the final name enclosed in square brackets given it features a space in its name? (i.e. if that's literally what's being passed through to SQL)
UAT_TEST.dbo.[Access Control]
Cheers,
Lain
Hi Lain,
The problem is I didn't hardcode anything. Not sure if its related to the SQL unable to find the DB?
Thank you
The problem is I didn't hardcode anything. Not sure if its related to the SQL unable to find the DB?
Thank you