master..spt_values is not found in Azure SQL database

• Narine M

  SSCrazy

  Points: 2672

  More actions

  January 25, 2018 at 1:17 am

  #326499

  master..spt_values is not found in Azure SQL database

  Error on executing this is on azure sql db,

  Msg 40515, Level 15, State 1, Procedure SP_**, Line 16
  Reference to database and/or server name in 'MASTER..spt_values' is not supported in this version of SQL Server.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 25, 2018 at 1:35 am

  #1977263

  Correct, that table won't be there, it's not expected to be there.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Narine M

  SSCrazy

  Points: 2672

  More actions

  January 25, 2018 at 3:00 am

  #1977278

  Is there any alternate solution, need to migrate our sql database to sql azure. In many stored procedures that table is used.

• Narine M

  SSCrazy

  Points: 2672

  More actions

  January 25, 2018 at 3:02 am

  #1977279

  How to create that spt_values in SQL azure master database.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 25, 2018 at 3:25 am

  #1977283

  Narine M - Thursday, January 25, 2018 3:00 AM

  Is there any alternate solution

  No idea. What are you doing with that table?

  Cross database queries (including to master) are not, afaik, permitted with SQLDB.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass