Answer / ranjit kumar routhu

cursors,t-sql,stored procedures,databse,errors and warnings,
locks,objects,performance,scans,security audit,transactions,
user configurable these comes under sql server profile

Answer / saradhi

Sql Server Profiler lets you record events as they occurin
an instance of MsDatabaseEngine. Event classes and their
event categories are available in the Event Selection Tab
of trace file properties
The Event Categories are
1.Broker Event
2.Cursors Event
3.CLR Event Category
4.Database Event Category
5.Deprecation Event Category
6.Errors and Warnings Event Category.
7.FullText Event Category
....

What is the difference between a clustered index and a non-clustered index?

1 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

1 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

---

Explain steps of normalization?

1 Answers  

---

What is create statement?

1 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

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

1 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

How to send email from database?

1 Answers  

---

Explain user defined functions?

1 Answers  

---

Explain how to integrate the ssrs reports in application?

1 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---