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 sql server query analyzer?

0 Answers  

---

What are the differences between ms sql server & oracle?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What is recompile sql server?

0 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What is database replication?

0 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

Explain steps of normalization?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---