Answer Posted / selvaraj.v

SQL Server 2000 BackUp Database,
Query:
------
backup database selvaa to disk = 'c:\selvaa.bak'

Answer:
-------
Processed 160 pages for database 'selvaa',
file 'selvaa_Data' on file 1.
Processed 1 pages for database 'selvaa', file 'selvaa_Log'
on file 1.
BACKUP DATABASE successfully processed 161 pages in 0.151
seconds (8.687 MB/sec).

Relational calculus is what type of language?

780

---

Can two tables share the same primary key?

682

---

How the authentication mode can be changed?

846

---

Why do you need a sql server?

685

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

718

---

---

How to connect to a sql server using odbc_connect()?

835

---

how many bits ip address consist of? : Sql server database administration

631

---

Why normalization is used?

726

---

Write a SQL command to insert and update only a particular field?

798

---

Why and when do stored procedure recompile?

705

---

What is the difference between left and right outer join?

707

---

What is a benefit of using an after insert trigger over using a before insert trigger?

722

---

How to recreate an existing index in ms sql server?

711

---

How to create stored procedures with parameters in ms sql server?

704

---

How does a profiler work?

663

---