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
What are ddl triggers and types of ddl trigger?
How do I manually uninstall an instance of sql server 2016?
What are the advantages to use stored procedures?
How do you set a trace flag in sql server?
What the difference between UNION and UNIONALL?
Explain activity monitors
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How can we delete Duplicate row in table?
Explain filtered indexes?
Why the trigger fires multiple times in single login?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
You want to implement the one-to-many relationship while designing tables. How would you do it?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
