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

Define full outer join?

0 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

Explain the disadvantages of cursors?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What are built in functions?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

What is database architecture? : SQL Server Architecture

0 Answers  

---

Explain the difference between clustered and non-clustered index?

0 Answers  

---

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,

---

what is a join? : Sql server database administration

0 Answers  

---

What is compound operators?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---