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

what kind of lan types do you know? : Sql server database administration

922

---

What is sql or structured query language?

1085

---

Does an index slow down updates on indexed columns?

910

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

---

Do you know what are pages and extents? : SQL Server Architecture

937

---

what is the difference between delete table and truncate table commands? : Sql server database administration

958

---

How global temporary tables are represented and its scope?

904

---

What is in place upgrade in sql server?

987

---

Difference between Logical Page and Physical Page in SSRS.

459

---

How to invoke a trigger on demand?

1025

---

What does null mean?

932

---

What is exporting utility?

951

---

what is a traditional network library for sql servers? : Sql server database administration

890

---

How to list all stored procedures in the current database using ms sql server?

1051

---

What is the difference between a stored procedure and a user defined function?

972

---