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

What is filter index?

942

---

Explain what are partitioned views and distributed partitioned views?

934

---

what type of index will get created after executing the above statement? : Sql server database administration

967

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1188

---

Can we call stored procedure in view in sql server?

889

---

How do I determine how many instances of sql server are installed on a computer?

999

---

Can we use pragma autonomous_transaction in trigger?

951

---

Are resultset updatable?

945

---

Do comments need to go in a special place in sql server 2005?

850

---

Different types of keys in SQL?

1088

---

How except clause is differs from not in clause?

945

---

How to access the inserted record of an event?

1043

---

What are the different types of replication are there in sql server 2000?

1031

---

What are the disadvantages of using the stored procedures?

1092

---

Write an sql query to find first weekday of the month?

908

---