Forum Discussion

Robert Tigwell's avatar
Robert Tigwell
Copper Contributor
Apr 13, 2017
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...
Data & Storage
storage
  • Robert Tigwell's avatar
    Robert Tigwell
    Apr 14, 2017

    David from MSDN forum put me on the right track:

     

    1. See what CASCADE DELETE FK constraints there are
    2. Inspect other table(s)
    3. See trigger on table with 3 part name in FROM clause
    4. Correct to 2 part name
    5. Dance

    To see if there are FK relationships w/ DELETE CASCADE:

    select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE ='CASCADE'

     

ToniPohl's avatar
ToniPohl
MVP
Dec 07, 2017

Hi all,

 

I (still) have the same issue when using BCP.EXE. Locally, it works:

bcp "select * from myDB.dbo.myTable" queryout mytable.csv -S ServerName -c -T

 

When executing the same against SQL Azure, the following error results:

Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Reference to database and/or server name in 'myDB.dbo.myTable' is not supported in this version of SQL Server.

 

Hope, this will be possible in near future...? Thx.

 

Theodore Sill's avatar
Theodore Sill
Copper Contributor
May 08, 2018

Hi Tony,

 

I ran into the same issue using the bcp utility.  I discovered there is another flag which may be used to specify the database: -d MyDatabaseName.

Resources