I am running a Powershell script (SQL PowerDoc) and I'm getting this error on some servers.
Also Unknown Permission type CRCF
I'm not sure where to look to find this issue on the server to fix it. Any suggestions?
I am running a Powershell script (SQL PowerDoc) and I'm getting this error on some servers.
Also Unknown Permission type CRCF
I'm not sure where to look to find this issue on the server to fix it. Any suggestions?
Hi subnet192,
How are things going on? Do the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
CRVW = CREATE VIEW, CRCF = CREATE CERTITICATES-
These codes appear in the column sys.database_permissions.type. I don't know about SQL PowerDoc, but apparently it does not know about this permissions (which looks like a shortcoming to me).
Is this something from Microsoft or a third party tool?
Powershell script /module for documenting sql environment. Hasn't been updated in a while but I'm running this against an older sql server... Thanks for your input. I'll see if I can modify the tool...
Hi subnet192,
In addition, you can try to use Microsoft Assessment and Planning toolkit (MAP) to discovery information about your Windows deployments and SQL Server instances, and automate the collection of inventory data about your database landscape. Please refer to this tutorial which might help.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
14 people are following this question.