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

Explain cdc and sql injection?

957

---

What are the recovery models for a database?

1096

---

How does clustered and non clustered index work?

900

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

What is the purpose of data source?

1018

---

How you can move data or databases between servers and databases in sql server?

1032

---

What is a database table?

951

---

Why normalization is used?

993

---

Define union, union all, minus, intersect?

961

---

What is a primary key?

941

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3857

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1021

---

What is a periodical index?

904

---

Is sql server free?

894

---

What does it mean if @@cursor_row returns a negative number?

977

---