Forum Discussion
Solved
Reference to database and/or server name in 'Azure.dbo.XXX' is not supported in this version of SQL
I am getting an error that seemingly indicates that I'm trying to use linked server or cross-database query when I am in no way trying to. I've opened a stackexchange question w/ full details but...
David from MSDN forum put me on the right track:
- See what CASCADE DELETE FK constraints there are
- Inspect other table(s)
- See trigger on table with 3 part name in FROM clause
- Correct to 2 part name
- Dance
To see if there are FK relationships w/ DELETE CASCADE:
select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE ='CASCADE'
Hi Robert, thank you for posting the solution! I'm sure other users will have the same question.
Msg 40515, Level 15, State 1, Line 16
Reference to database and/or server name in 'Source.dbo.kiran' is not supported in this version of SQL Server.
Please solve it
- above ans not working