Error : Reference to database and/or server name in 'tempdb..sp_tablecollations_100' is not supported in this version of SQL Server

Hi 

I got this error while running my code,

"Error : Reference to database and/or server name in 'tempdb..sp_tablecollations_100' is not supported in this version of SQL Server"

Previously I was using SQl Server db, but later I changed to Azure DB.

When I look for this error I found that this is a bug in Azure DB and some one reported it in 2010.

1) https://connect.microsoft.com/SQLServer/feedback/details/624093/sqlbulkcopy-writetoserver-fails-on-sql-azure-if-destination-table-is-temporary

2) http://feedback.azure.com/forums/217321-sql-database/suggestions/3326856-sqlbulkcopy-should-support-temporary-tables-align

3) http://answers.flyppdevportal.com/categories/azure/sqlazure.aspx?ID=51b26995-509f-419e-8545-3a3c16a6fc14

So is that still an issue or there is some solution to this or may be some work around ? As it almost 4 years waved after it was reported. 

 

September 1st, 2015 7:00am

According to the issue tracker in Microsoft Connect, it hasn't been solved yet.
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 11:37am

Hi Aakash,

This feature is supported in Azure SQL DB V12, are you running a V12 or a V11 server?

Regards

Dhruv

September 14th, 2015 1:52pm

Hi Aakash,

This feature is supported in Azure SQL DB V12, are you running a V12 or a V11 server?

Regards

Dhruv

Free Windows Admin Tool Kit Click here and download it now
September 14th, 2015 1:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics