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

What are joins in sql and what are the different types of joins?

0 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

Can we write ddl in trigger?

0 Answers  

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

How to delete a database in ms sql server?

0 Answers  

---

What is deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---