Hello!
Please, help with the subject. SMO generates only this:
USE [DB1]
GO
/****** Object: DatabaseRole [VIP_RDR] Script Date: 05/28/2007 03:48:05 ******/
CREATEROLE [VIP_RDR] AUTHORIZATION [dbo]
Securables are not included for some reason.
Thank you.
Well, SMO does not do that.
So - "manually", using GRANT (together with select from sys.objects if you can distinct database objects using select clause)
Good luck!
