Answer Posted / bhaskar
Use sp_configure to display or change server-level
settings. To change database-level settings, use ALTER
DATABASE. To change settings that affect only the current
user session, use the SET statement.
E.g.
sp_CONFIGURE ’show advanced’, 0
GO
RECONFIGURE
GO
sp_CONFIGURE
GO
You can run following command and check advance global
configuration settings.
sp_CONFIGURE ’show advanced’, 1
GO
RECONFIGURE
GO
sp_CONFIGURE
GO
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does partitioning improve performance?
What is the filtered index?
what is denormalization and when would you go for it? : Sql server database administration
Which sql server is best?
What is a file group?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to assign null values to variables or columns?
How to query multiple tables jointly?
Can We Use Data-grids For Our Report In Ssrs?
Tell about MOM Tool(Microsoft Operator Manager)?
Explain different types of locks in sql server.
List out a number of the wants to setup a SQL Server failover cluster?
What are database states in ms sql server?
How sql server executes a statement with nested subqueries?
Is foreign key unique?
