Very Computer

> I am trying to set up a SQL trace which logs to a table using the
> xp_trace_* stored procs.  I have been able to get a slightly modified
> version of the example found in books online under the
> xp_trace_addnewqueue topic working on my development (non-clustered)
> server.  I noticed that when I executed the line "EXEC


> received a "Server: Msg 19098, Level 10, State 1, Line 0 Internal
> Error."  This problem went away and the logging started to function
> perfectly when I executed my script on the development box itself.  Why
> would this happen?  While trying to get this script working on the
> cluster server, I get the above mentioned error message no matter from
> where I execute the script.  Could this have something to do with the
> fact that the SQL servers name is a virtual name and is different from
> the node name.  Does anyone have any pointers?  Thanks in advance.

> Paul Magid

> Sent via Deja.com http://www.deja.com/
> Before you buy.

or the
> node it's running on?  Also, you might want to post this to
> microsoft.public.sqlserver.clustering.

> --
> Richard Waymire, MCT, MCSE+I, MCSD, MCDBA

> > I am trying to set up a SQL trace which logs to a table using the
> > xp_trace_* stored procs.  I have been able to get a slightly
modified
> > version of the example found in books online under the
> > xp_trace_addnewqueue topic working on my development (non-clustered)
> > server.  I noticed that when I executed the line "EXEC


> > received a "Server: Msg 19098, Level 10, State 1, Line 0 Internal
> > Error."  This problem went away and the logging started to function
> > perfectly when I executed my script on the development box itself.
Why
> > would this happen?  While trying to get this script working on the
> > cluster server, I get the above mentioned error message no matter
from
> > where I execute the script.  Could this have something to do with
the
> > fact that the SQL servers name is a virtual name and is different
from
> > the node name.  Does anyone have any pointers?  Thanks in advance.

> > Paul Magid

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

> Richard,

> The result is the same no matter whether I use the virtual server name
> or the node name.  I am beginning to think this might be a bug.

> Thanks,

> Paul

> or the
> > node it's running on?  Also, you might want to post this to
> > microsoft.public.sqlserver.clustering.

> > --
> > Richard Waymire, MCT, MCSE+I, MCSD, MCDBA


> > > I am trying to set up a SQL trace which logs to a table using the
> > > xp_trace_* stored procs.  I have been able to get a slightly
> modified
> > > version of the example found in books online under the
> > > xp_trace_addnewqueue topic working on my development (non-clustered)
> > > server.  I noticed that when I executed the line "EXEC


> > > received a "Server: Msg 19098, Level 10, State 1, Line 0 Internal
> > > Error."  This problem went away and the logging started to function
> > > perfectly when I executed my script on the development box itself.
> Why
> > > would this happen?  While trying to get this script working on the
> > > cluster server, I get the above mentioned error message no matter
> from
> > > where I execute the script.  Could this have something to do with
> the
> > > fact that the SQL servers name is a virtual name and is different
> from
> > > the node name.  Does anyone have any pointers?  Thanks in advance.

> > > Paul Magid

> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.

> Sent via Deja.com http://www.deja.com/
> Before you buy.