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 is the usage of sign function?

1168

---

How to create a simple stored procedure in ms sql server?

1079

---

Is it ok to shrink transaction log?

1048

---

What is query optimizer in sql server?

1066

---

Explain features of analysis services?

1075

---

What is data source document?

1085

---

What is a database in ms sql server?

1100

---

Explain “@@rowcount” and “@@error” in sql server?

1124

---

What are the database objects? : SQL Server Architecture

1091

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2450

---

What is meant by dirty read?

1037

---

What is implicit mode in sql server?

1151

---

What are the advantages to use stored procedures?

1175

---

What is the cpu pressure?

1103

---

how you can configure a running aggregate in SSRS?

199

---