Answer Posted / gtp

RESTORE DATABASE NewDatabase
FROM DISK='D:\Backup\NewDatabase.bak'
WITH
MOVE 'NewDatabase' TO 'D:\ActiveDB\NewDatabase.mdf',
MOVE 'NewDatabase_log' TO 'D:\ActiveDB\NewDatabase_log.ldf'

What is snapshot report?

153

---

How to update muliple row in single query?

999

---

What are the benefits of normalization?

1044

---

What is transact-sql language?

1006

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

959

---

How many types of subqueries are there in sql server?

934

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1019

---

What are the five major components of a dbms?

881

---

What is the use of group by clause?

900

---

What is index fragmentation in ms sql server?

1023

---

Tell me what are cursors and when they are useful?

909

---

Difference between primary key and clustered index?

933

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

893

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

971

---

What is db stored procedure?

815

---