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 a fill factor?

0 Answers  

---

What is difference between primary key and foreign key?

0 Answers  

---

What is the process of indexing?

0 Answers  

---

How to get @@error and @@rowcount at the same time?

0 Answers  

---

What are locks in sql?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

what is checksum in sql server.........???

0 Answers   TCS,

---

Explain about service Broker functions?

0 Answers  

---

How to get the definition of a stored procedure back?

0 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---