remove loginname column from existing trace file?

#1

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries of
interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor to
run the trace under the connected user (currently with dbo privileges)? If
anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs even
better <g>.

#2

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#3

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#4

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#5

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#6

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#7

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#8

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#9

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.

#10

I don't use the tuning advisor much so I can't say if what you are asking
will work or not. But you can load the trace into profiler and then deselect
any column you wish (well mostly) and save that to a trace file which will
then not include those columns.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"geekyguy" <geeky (AT) guy (DOT) com> wrote

Quote:

Hi All:

I created a trace file, and when I ran tuning advisor many of the queries
of interest couldn't be optimized because the user didn't have "showplan"
privileges.

Is it possible to remove the login name column to "force" tuning advisor
to run the trace under the connected user (currently with dbo privileges)?
If anyone could provide a step-by-step I would greatly appreciate it.

If it's possible to do this through the profiler or tuning advisor GUIs
even better <g>.