As global temp tables, used to enforce single-streaming of critical stored procedures, e.g., ##DAILY, are prohibited in v12, can we execute sp_getapplock and sp_releaseapplock to mimic the same functionality?

Yes, this should work. Both sp_getapplock and sp_releaseapplock are available in Azure SQL Database V12.

Thanks,

Mihaela

• Proposed as answer by Joseph IdziorekMicrosoft employee 13 hours 37 minutes ago
• Marked as answer by SAinCA 12 hours 55 minutes ago

Yes, this should work. Both sp_getapplock and sp_releaseapplock are available in Azure SQL Database V12.

Thanks,

Mihaela

• Proposed as answer by Joseph IdziorekMicrosoft employee 13 hours 48 minutes ago
• Marked as answer by SAinCA 13 hours 5 minutes ago

Thanks for the quick response - very glad to see both supported.

Yes, this should work. Both sp_getapplock and sp_releaseapplock are available in Azure SQL Database V12.

Thanks,

Mihaela

• Proposed as answer by Joseph IdziorekMicrosoft employee Tuesday, September 01, 2015 5:32 PM
• Marked as answer by SAinCA Tuesday, September 01, 2015 6:15 PM

Yes, this should work. Both sp_getapplock and sp_releaseapplock are available in Azure SQL Database V12.

Thanks,

Mihaela

• Proposed as answer by Joseph IdziorekMicrosoft employee Tuesday, September 01, 2015 5:32 PM
• Marked as answer by SAinCA Tuesday, September 01, 2015 6:15 PM

Yes, this should work. Both sp_getapplock and sp_releaseapplock are available in Azure SQL Database V12.

Thanks,

Mihaela

• Proposed as answer by Joseph IdziorekMicrosoft employee Tuesday, September 01, 2015 5:32 PM
• Marked as answer by SAinCA Tuesday, September 01, 2015 6:15 PM