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

Explain error and transaction handling in sql server?

1056

---

What is a non equi join?

1021

---

How to list all dsn entries on your local machine using odbc_data_source()?

1089

---

Explain transaction server auto commit?

1085

---

What is snapshot report?

172

---

What is xml datatype?

1126

---

What is triggers and stored procedures?

985

---

What is implicit cursors?

1123

---

what is bit datatype? : Sql server database administration

957

---

What are the 3 types of schema?

1171

---

What are the advantages of using third-party tools?

1035

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1158

---

What do you understand by coalesce in sql server?

1123

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

1099

---

What type of locking occurs during the snapshot generation? : sql server replication

1371

---