event classes in sql server
- 2 Answers
- 6905 Views
- Accenture, AFE, I also Faced
- E-Mail Answers
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 are the steps you can take to avoid “deadlocks”?
Explain the truncate command? : SQL Server Architecture
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can group by be used without aggregate functions?
What is the difference between for xml raw and for xml auto?
How to download microsoft sql server 2005 express edition?
What is an sql server agent?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to enter date and time literals in ms sql server?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
What are the different types of stored procedures?
What is the recursive stored procedure in sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
