Answer Posted / bhasskar

sp_configure :
The xp_cmdshell option is a server configuration option
that enables system administrators to control whether the
xp_cmdshell extended stored procedure can be executed on a
system.
—- To allow advanced options to be changed.

EXEC sp_configure ’show advanced options’, 1

GO
—- To update the currently configured value for advanced
options.

RECONFIGURE

GO

—- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

—- To update the currently configured value for this
feature.

RECONFIGURE
GO
SET:
This command is used to set the values to the variables
ex:
declare @id int
set @id=2

State a few properties of relational databases?

1120

---

How can sql server instances be hidden? : sql server security

1132

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1008

---

What is sql server 2000 work load governor?

1050

---

What is 3nf normalization form?

1099

---

What is a cube? : sql server analysis services, ssas

989

---

What is the usage of sign function?

1091

---

How to return the second 5 rows in ms sql server?

1048

---

How to convert a table data in XML format in sql server?

2530

---

What purpose does the model database server?

1084

---

What do mean by xml datatype?

1082

---

Explain logical operators in sql server?

1097

---

Explain transaction server auto commit?

1029

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

974

---

How to Sync Two SQL Azure Databases?

119

---