remove loginname column from existing trace file?

#11

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#12

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#13

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#14

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#15

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#16

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#17

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#18

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

#19

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

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.

Thanks Andrew, that worked.

Quote:

"geekyguy" <geeky (AT) guy (DOT) com> wrote in message
news:13415138-F67D-44EA-8965-87FD5C22B976 (AT) microsoft (DOT) com...
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>.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

remove loginname column from existing trace file?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM

Re: remove loginname column from existing trace file? - 09-02-2008 , 03:07 PM