Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Call by value and call by reference in procedure and function, with NOCOPY.
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How to receive output values from stored procedures?
Will count(column) include columns with null values in its count?
What is the sql case statement used for? Explain with an example?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is transaction server explicit transaction?
What is always encrypted?
Can you explain about buffer cash and log cache in sql server?
What do you understand by a view?
What is BLOCK statements in SQL?
Do you know what is difference between stored procedure and user defined function?
How to run sql server 2005 books online on your local system?
What are rest-style architecture's?
