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

What are subquery and its properties?

979

---

What is view in sql?

852

---

What are the results of running this script?

861

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

956

---

What do you mean by cardinality?

848

---

Explain mixed authentication mode of sql server?

989

---

What is clustered primary key?

958

---

What is a virtual table in sql?

943

---

What do you understand by triggers and mention the different types of it?

879

---

Explain the cursor lock types?

982

---

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

919

---

What is linked report?

119

---

Define self join?

987

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

887

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

946

---