Answer / subbu

User-defined data types can be used when several tables
must store the same type of data in a column and you must
ensure that these columns have exactly the same data type,
length, and nullability.

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

How does recursive cte works in sql server?

0 Answers  

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

How to integrate the ssrs reports in application?

0 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

---

Explain system rowset functions?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What is spatial and temporal data?

0 Answers  

---

How to specify the collation for a character data type in ms sql server?

0 Answers  

---

What is default port number for sql server 2000?

0 Answers  

---

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---