MS SQL Server - SQL Profiler

Author

SQL Profiler

Marco Pais

2005-03-31, 8:01 pm

Hi there,

I was following an HOW TO article from Microsoft's KB (ID: 224587) related
with SQL profiler.

Once SQL Profiler is opened, they say to click Tools under menu Options and
then make sure that 'All Event Classes' and 'All Data Columns' options are
checked.
Well, I cannot find this options.

Then, they say to include some Event Classes and some Data Columns that I do
not have available. Maybe because 'All Event Classes' and 'All Data Columns'
options are not checked. But, where are these options?

I would apreciate any help. Thanks.

Marco

Tibor Karaszi

2005-03-31, 8:01 pm

That article is for 7.0. In 2000, all the stuff are displayed by default.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/

"Marco Pais" < mpaisIGNORE@foruminf
ormatica.pt> wrote in message
news:uG19$5fNFHA.3512@TK2MSFTNGP15.phx.gbl...
> Hi there,
>
> I was following an HOW TO article from Microsoft's KB (ID: 224587) related with SQL profiler.
>
> Once SQL Profiler is opened, they say to click Tools under menu Options and then make sure that
> 'All Event Classes' and 'All Data Columns' options are checked.
> Well, I cannot find this options.
>
> Then, they say to include some Event Classes and some Data Columns that I do not have available.
> Maybe because 'All Event Classes' and 'All Data Columns' options are not checked. But, where are
> these options?
>
> I would apreciate any help. Thanks.
>
> Marco
>

Marco Pais

2005-03-31, 8:01 pm

The 'Misc' Event Class is not there...

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:uZt4oDgNFHA.1732@TK2MSFTNGP14.phx.gbl...
> That article is for 7.0. In 2000, all the stuff are displayed by default.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> http://www.sqlug.se/
>
>
> "Marco Pais" < mpaisIGNORE@foruminf
ormatica.pt> wrote in message
> news:uG19$5fNFHA.3512@TK2MSFTNGP15.phx.gbl...
>
>

Tibor Karaszi

2005-03-31, 8:01 pm

Again: The article is for 7.0. I assume you are on 2000. Correct?

The categorization for events differs between the versions. Attention, for instance is under "Errors
and Warnings" in 2000. So you either have to look around for the events where they are placed in
2000, or find an article on the subject that is written for 2000 and not for 7.0.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/

"Marco Pais" < mpaisIGNORE@foruminf
ormatica.pt> wrote in message
news:u$dkvGgNFHA.1176@TK2MSFTNGP12.phx.gbl...
> The 'Misc' Event Class is not there...
>
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in message
> news:uZt4oDgNFHA.1732@TK2MSFTNGP14.phx.gbl...
>
>

Marco Pais

2005-03-31, 8:01 pm

Thanks. It helped.
I am using SQL Server 2000 and I could not find some events, like MISC Event
Class events. They are separeted in other event classes.

Thanks...

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:uoV13RgNFHA.1948@TK2MSFTNGP14.phx.gbl...
> Again: The article is for 7.0. I assume you are on 2000. Correct?
>
> The categorization for events differs between the versions. Attention, for
> instance is under "Errors and Warnings" in 2000. So you either have to
> look around for the events where they are placed in 2000, or find an
> article on the subject that is written for 2000 and not for 7.0.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> http://www.sqlug.se/
>
>
> "Marco Pais" < mpaisIGNORE@foruminf
ormatica.pt> wrote in message
> news:u$dkvGgNFHA.1176@TK2MSFTNGP12.phx.gbl...
>
>

Sponsored Links