Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Stored Procedure not executing from .Net SqlClient but does Analyz

1 view
Skip to first unread message

eekamouse

unread,
Apr 19, 2010, 7:48:01 PM4/19/10
to
I have an an exec call that is executed from Sync Services, that is visibly
being executed when run a Trace, but does absolutely nothing. If I enable the
trace to show the internal SQL statements of the procedure, it also shows
absolutely nothing.

I have several other procedures called form Sync Services, that work just
fine, and produce the expected output in a Trace.

If I copy the exec call from the Trace and paste it into Query Analyzer, it
runs without any problems, errors, or warnings.

Has anyone seen anything like this before? Is it a problem with Sync
Services or SQL 2008?

There are no errors thrown anywhere when the exec is called from Sync
Services, and like I said, I copy and paste the exact call that shows up in
Trace and it works perfectly when run through Query Analyzer.

0 new messages