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 ssl in sql server?

0 Answers  

---

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

---

How to recompile stored procedure at run time?

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

0 Answers   QuestPond,

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---