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.
Sent via Deja.com http://www.deja.com/
Before you buy.