event classes in sql server
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 8 Yes | 2 No |
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
....
| Is This Answer Correct ? | 1 Yes | 0 No |
What does it mean to normalize data?
How can you get @@error and @@rowcount at the same time?
Explain table valued parameters in sql server? Why tvp used?
Explain stored procedure?
How to find the service pack installed? : sql server database administration
What is mapping schema?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
what is the difference between table and view
What is a NOLOCK?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the different types of cursor?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)