All Questions

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
2k views

Is it possible to use cross database queries in both Azure and SQL Server 2016?

I'm working on a project that is designed to run on Microsoft's Azure platform. At present we have a few developers working locally on their own machines with the intent of being able to publish the ...
3
votes
3answers
232 views

Permission error when using sys.dm_exec_input_buffer with @@SPID

When I run this blob of SQL on SQL Server 2016 or an Azure SQL DB: --hello world SELECT event_info FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_input_buffer(req.session_id, req....
3
votes
1answer
76 views

Determine minimal permissions required for a given SQL script or session

For security reasons I need to determine minimal permissions required for a given script or session without having to manually audit activity then work it out by hand. I'm assuming this can be done ...
1
vote
0answers
27 views

Syncing On Prem SQL Server with Azure SQL

We have a SQL 2016 instance running production systems at a pretty healthy load within AWS. On top of this we host instances of production databases in Azure for PowerBI and analysis usage. At ...
1
vote
1answer
75 views

Transfer data from the cloud to a local database

I have an SQL Server 2016 Azure database in the cloud called XCLOUD, with many tables big and small, and a local SQL Server 2016 database with the same tables and data called XLOCAL. In all databases ...
0
votes
0answers
160 views

Importing BACPAC file from azure to SQL creating an empty database

Exported Data-Tier_application from an Azure database to create a BACPAC of it. SQL editions I'm trying to use to import the BACPAC: SQL Server 2016 express. SQL Server 2017 Developer ...
0
votes
1answer
385 views

Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors

I'm trying to import a .bacpac created from SQL Azure into a SQL Server 2016 server that has no existing databases beforehand. It will run but run into issues such as: Unhandled Exception: ...