event classes in sql server

Question Posted / ranjit kumar routhu

2 Answers
7667 Views
Accenture, AFE, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

event classes in sql server..

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

event classes in sql server..

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

Post New Answer

More SQL Server Interview Questions

How to create a new schema in a database?

0 Answers

what is unique and xaml nonclustered index

0 Answers

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers Satyam,

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers

What is the difference between functions and stored procedures?

0 Answers Accenture,

What do you mean by an execution plan? How would you view it?

0 Answers

What are examples of triggers?

0 Answers

What are the features of Embedded SQL

0 Answers HCL,

Explain what role entity and relationship play in an ER diagram.