SqlServerDsc | module contains DSC resources for deployment | Continuous Deployment library
kandi X-RAY | SqlServerDsc Summary
kandi X-RAY | SqlServerDsc Summary
The SqlServerDsc module contains DSC resources for deployment and configuration of Microsoft SQL Server.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of SqlServerDsc
SqlServerDsc Key Features
SqlServerDsc Examples and Code Snippets
Community Discussions
Trending Discussions on SqlServerDsc
QUESTION
Can I implement the following T-SQL code using a PowerShell DSC resource from the SqlServerDsc module?
...ANSWER
Answered 2021-Feb-13 at 18:07ALTER TRACE is a Server Permission not a database permission. So try SqlServerPermission
instead of SqlDatabasePermission
if such a thing exists.
You might be able to work around this by creating a user in Master for mySQLUser. My guess is that DSC is checking for the existence of a database principal before running
GRANT ALTER trace TO [MyUser]
And that grant will succeed if the login exists, if you can persuade DSC to attempt it.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install SqlServerDsc
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page