Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why can I drop or create tables outside the MyDB context?

April 26, 2017context create drop mydb outside tables

0

10 Posted

Why can I drop or create tables outside the MyDB context?

1 Answer

0

10 Posted

This is due to CasJobs’ distributed operation and because SQL Server does not allow tables to be dropped or created remotely (from a different server via a linked server connection). For more information, please see the CasJobs Limitations due to Distributed Execution section in the Help page.