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 stored by the model? : sql server database administration

958

---

What is SQL Server?

1219

---

What are filegroups in sql server?

1065

---

How to change server name in sql server?

1188

---

What are entities and relationships?

975

---

What is mapping schema?

1030

---

Explain ms sql server reporting services vs crystal reports?

923

---

What is nonclustered index with included columns ?

969

---

How do you migrate data from mssql server to azure?

165

---

What are the difference between primary keys and foreign keys?

966

---

What is the difference between substr and charindex in the sql server?

1106

---

Define Business Edition in SQL Azure?

100

---

Explain primary key and foreign key constraints?

1035

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1039

---

What is an indice?

1039

---