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).

Mention the uses of stored procedures.

563

---

What is a performance monitor?

548

---

What are the difference between primary key and unique key? : sql server database administration

517

---

How to start sql server browser service?

550

---

How you can change the database name in SQL SERVER?

658

---

---

How would you add a section to a table?

560

---

How to stop log file growing too big?

565

---

How to retrieve error messages using mssql_get_last_message()?

519

---

What is the difference between migration and upgradation in sql server?

597

---

What is a file group?

604

---

Explain external key management in sql server 2008

494

---

What is the difference between primary key and unique constraints?

503

---

What is sql stored procedure?

593

---

How to create a testing table with test data in ms sql server?

546

---

How to replace null values in expressions using isnull()?

636

---