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

Can we use trigger new in before insert?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

What is a document index?

0 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

What do you mean by an execution plan?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

What are trace files?

0 Answers  

---

What is join query?

0 Answers  

---

What will be the maximum number of index per table?

0 Answers  

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

---