Answer Posted / 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

Comment,Datatypes are unlimited

2070

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1073

---

Explain cursor as data base object?

1048

---

What is difference between unique and primary key?

920

---

How connect excel to sql server?

1002

---

What do you understand by integration services in sql server?

968

---

Explain syntax for viewing, dropping and disabling triggers?

964

---

What stored procedure would you use to view lock information?

981

---

Define normalisation?

1118

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2077

---

How to get nth highest salary from employee table.

1168

---

What is temporal data type?

925

---

What command do we use to rename a db, a table and a column?

933

---

If a stored procedure is taking a table data type, how it looks?

6456

---

Define self join in sql server joins?

960

---