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 stored procedure?

0 Answers  

---

What is the tcp/ip port on which sql server runs?

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  

---

Define views.

0 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

What is rtm version in sql server?

0 Answers  

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

What does set rowcount do?

0 Answers  

---