PBM - Enable the ability to pass more parameters to ExecuteSql() by Phil Brammer

Active

Type:	Suggestion
ID:	649944
Opened:	3/7/2011 8:29:02 AM
Access Restriction:	Public

Workaround(s)

view

It would be great if it were possible to pass parameters to the ExecuteSql() function when building a custom PBM condition.

For instance, the Databases facet does not allow the ability to check for offline databases because they must be accessible in order for a policy to be evaluated.

So, if I want to write a custom condition to check for this, I would like to be able to do:
ExecuteSql('numeric','select status from sys.databases where database_id = @ID')

where @ID is the property available under the Database facet.

Details (expand)

English

Tools (SSMS, Agent, Profiler, etc.)

Extend ExecuteSql() to allow for more input parameters, other than @@ObjectName and @@SchemaName.

Improved Administration

0 attachments

Posted by Microsoft on 6/4/2012 at 11:09 AM

This report is closed as a duplicate since there is a tracking item for the same request from customer.

Best Regards,
Eric

Posted by Microsoft on 3/9/2011 at 5:19 PM

Hello Phil,

Thank you for submitting the feedback. We will consider it for next major release. Meanwhile, the workaround is to have the (database, status) pair written to a string and return it.

Hongfei

Microsoft