Answer Posted / 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

Do you know concepts and capabilities of sql server?

1057

---

What is the difference between push and pull subscription? : sql server replication

1212

---

Write an sql query to find first weekday of the month?

913

---

How except clause is differs from not in clause?

952

---

What are the components of sql server service broker?

1015

---

What is the syntax to execute the sys.dm_db_missing_index_details?

1024

---

what is blocking? : Sql server database administration

1038

---

What is data mart? : sql server analysis services, ssas

1051

---

Explain filestream storage of sql server 2008?

1013

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1925

---

What are parameterized reports?

200

---

What is difference between createstatement and preparedstatement?

1086

---

List the data types available in mssql?

1031

---

Can you tell me about the concept of ER diagrams?

1064

---

How to connect sql server management studio express to sql server 2005 express?

1041

---