News

That means that if you intend to execute PowerShell scripts/commands from SQL Agent Job steps, the service account that the SQL Server Agent is running as must have appropriate permissions.
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.
The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community Technology Preview 2.0. The CTP was announced by way of the company's online Microsoft Data Amp 2017 event hosted ...