Answer / srinivasa ganamur

Hi,

Step 1 : For this you to create new procedure(plcae all
your statments in this procedure), affter creating the
procedure, run this procedure in tempdb.

Step 2 : using sp_procoption (system procedure), you have
to set startup option.means whenever you restart your sql
server the created procedure automatically runs. The Syntax
of sp_procoption is

sp_procoption @proc_name,
@OptionName,
@OptionValue

@ProcName---> Name of the newly created procedure
@OptionName---> StartUP
@OptionValue---> True

Ex: sp_Procoption 'usp_CustomerDetails', 'StartUp', 'True'

Regard's
Srinivasa Ganamur

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

Explain time data type in sal server 2008?

0 Answers  

---

what are isolation levels? : Sql server database administration

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,

---

What is the usage of sign function?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What is mapping schema?

0 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

How to insert stored procedure result into temporary table?

0 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---