SQL Server 2008: Parameters with T-SQL statements

Question

I want to know if it is possible to show a parameter with some T-SQL statement.

For example, there is a PARAMETERIZATION parameter. One can set it with such statement:

SET PARAMETERIZATION FORCED

How to know parameter's status?

Mark · Accepted Answer · 2010-08-18 18:11:50Z

2

You're looking for DATABASEPROPERTY(). Something like this:

select DATABASEPROPERTY(DB_NAME(), 'IsParameterizationForced')

Note that the possible values for SET PARAMETERIZATION xxx are SIMPLE and FORCED. This query will return 1 or 0 depending on whether the current setting is FORCED.

answered Aug 18, 2010 at 18:11

Mark

11.8k12 gold badges68 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Timofey Over a year ago

great, this is what is exactly wanted :)

Collectives™ on Stack Overflow

SQL Server 2008: Parameters with T-SQL statements

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related