Re: Updating Subscriber Question

From: lancemc5 (lancemc5_at_discussions.microsoft.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 10:15:03 -0700

Through profiler I have determined the process is hanging up in the update
trigger when the sp_MSget_publisher_rpc procedure is called. The
MSsubscription_properties table is queried to get the login id for the
procedure. I had to creatively reconstruct this since the procedure has to
be called from the trigger. The login id is null in this table and is
causing a problem. I manually updated the login id to 'sa' but the procedure
will not select the correct information. I can run the select statement by
itself and retrieve the proper information. However, running my test
procedure will not return any of the needed information. Hopefully, you can
help me now that you have this information.
Thanks,
Lance

"Paul Ibison" wrote:

> Lance,
> can you run profiler - this is really strange.
> You do an update on a row which hangs and yet you can still query the same
> row.
> The only thing I can think of is an instead of trigger.
> Anyway, profiler should narrow things down, and the current activity window
> should reflect at least some change.
> Regards,
> Paul Ibison
>
>
>

Relevant Pages

  • Re: Auditing changes made to table design (syscolumns table)
    ... With out using profiler the only way I know of is to get this info from the ... Keep in mind I know the database and the tables I would ... I attempted to write a trigger to log when a change was made to the ... > certain criteria against every transaction. ...
    (microsoft.public.sqlserver.security)
  • Re: inserted in Trigger auswerten
    ... Ich habe mich mit dem Profiler ... Meine Trigger funktionieren übrigens gut. ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: which statement fire the trigger ?
    ... >> Andrew J. Kelly SQL MVP ... Triggers do not have specific events in Profiler. ... trigger show up as SP:StmtStarting/Completed events, ...
    (microsoft.public.sqlserver.programming)
  • Re: Can SQL Profiler Track a Field in a Table?
    ... Profiler can track the execution of statements, but cannot be used to track ... then I would suspect faulty trigger logic. ... MyDate is supposed to update with a getdatevalue. ...
    (microsoft.public.sqlserver.server)
  • Re: Logon triggers
    ... it's not that if you mess up the login trigger that no one can ... You can still connect on the DAC (Dedicated Administrator ... Connection) to drop the trigger. ... Event Notifications since in the future I want to log DDL & SQL Config ...
    (microsoft.public.sqlserver.security)