Answer Posted / 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 View All Answers
What is user defined datatypes and when you should go for them?
What is the security principal at the server level that represents your session?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is log shipping?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are the dmvs?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is use of except clause? How it differs from not in clause?
What is the Main Difference between ACCESS and SQL SERVER?
Tell me extended events in sql server 2008?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can two tables have the same primary key?
Explain how would you store your query in an SSRS report or a Database server?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is Cross Join and in which scenario do we use Cross Join?