Answer / subramaniam

sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and
give the date and time for this particular job

Can we shrink data file in sql server?

0 Answers  

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

What is self join in sql server joins?

0 Answers  

---

Explain nested join?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

How do you manipulate data?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What is the sql server 2000 version number?

0 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

Can you explain about buffer cash and log cache in sql server?

0 Answers  

---