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 the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

What is sql server profiler?

0 Answers  

---

What is an execution plan? When would you use it?

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

Can a database be shrunk with users active?

0 Answers  

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---

What are the types of normalization?

0 Answers  

---

What is the New in SQL server 2008?

0 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

Does partitioning help performance?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---