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

What is nonclustered index on computed columns?

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

Does group by sort data?

0 Answers  

---

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

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

What is a covering index?

0 Answers  

---

What are functions

3 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What is bcnf normalization form?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

Where are full-text indexes stored?

0 Answers  

---