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
When would you use sql joins?
What is de-normalization in sql database administration? Give examples?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
How do users use Report Builder with SQL Server data sources?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is the contrast between sql and mysql?
What are the new scripting capabilities of ssms? : sql server management studio
What is raid? : SQL Server Architecture
Can the query output be sorted by multiple columns in ms sql server?
What is the function of sql server agent windows service?
What are the types of joins in sql?
We need to perform what steps in the following order to work with a cursor?
What is the difference between rank and dense_rank?
In which format does an image save in SQL Server database ?
Can you move the resources after pausing the node? : sql server database administration
