Re: errors calling linked oleDB server stored procedures

From: Michael, Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 03:07:04 GMT

Hi Gerry,

Thanks for you reply.

Here is a bit more infomation for you. Looks like an interseting
workaround to cretae a dummy table in your database that executes the
stored procedures.

Instaed of calling the procedures directly, you could just insert a row to
the linked server. This approach will not work to execute a stored
procedure that accepts parameters. Also, you could insert your parameters
into a table and then trigger the stroed procedures with the parameter
inserted into the table. In this way, I think you could trigger your stored
procedures in your database.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

Relevant Pages

  • Re: errors calling linked oleDB server stored procedures
    ... within SQL server the same as we would elsewhere but i don't see anything. ... > workaround to cretae a dummy table in your database that executes the ... I think you could trigger your ... > procedures in your database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 2950 - Reserved Error on form refresh/requery
    ... and I can't leave the client with an unusable database while I try to ... The requery is on the form (so the data displayed in the sub-forms refreshes ... The triggering event is a listbox after update that does 2 things only: ... can trigger others, and so the problem may occur only when a specific ...
    (microsoft.public.access.formscoding)
  • Re: Help with INSERT TRIGGER - fails with error.
    ... You didn't declare any PRIMARY KEY in this database. ... In an INSERT trigger, ... but I can't get it to work because it references ntext fields. ...
    (comp.databases.ms-sqlserver)
  • Re: Safe delete idea for discussion
    ... to use a stored procedure instead of trigger ... select getdate, 'AuditLog', AuditLogID ... > restore database Recovery ... >>> that writes an entry into a DeleteLog table ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Lookup Tables, the right way?
    ... model is comes in un-learning what you know about file systems. ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ... with a trigger that you can do with DRI and more. ...
    (comp.databases.theory)
Loading