Re: errors calling linked oleDB server stored procedures

From: gerry (germ_at_hotmail.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 11:07:37 -0400

thanks again.

this should work for sp that don't return any values but our goal is to use
sp to control all db access, data retrieval in particular, which is exactly
where sql server is failing.

I just took a quick look to see if it is possible to use adoDB/COM directly
within SQL server the same as we would elsewhere but i don't see anything.
is this possible and i'm just looking in the wrong places?

gerry

""Michael, Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:$4e6UcZLEHA.3064@cpmsftngxa10.phx.gbl...
> 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: How to limited number of rows in a table?
    ... If this is a log table, database blocking should ... Pro SQL Server 2000 Database Design ... > I'll bend on the trigger, but I think a nightly job may be too infrequent ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger: To fill another Database with using Stored Procedures of the other Database
    ... I fill from Database A with triggers Database B, ... add additional information accordingly, this Stored Procedures is ... trigger does not work anymore, even if I do a try catch over the whole ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Tracing user & permissions (triggers and stored p)
    ... staging tables + sql agent job ... >> Please specify the version of SQL Server you are using. ... >> xp_cmdshell is run (proc vs. trigger executes proc). ... >> from xp_cmdshell executes under the security context of the SQL Server ...
    (microsoft.public.sqlserver.security)
  • call to xp_cmdshell from trigger problem
    ... To any SQL Server MVP: ... database that is used to alert and calculate required amounts of assistance ... At first it failed because the trigger called the EXE but the tables were ...
    (microsoft.public.sqlserver.server)
  • Re: implement Save button
    ... When we use a disconnected recordset, i.e. we do not use the databinding. ... you want to make a few steps in database side ... For SQL server we can use the Trigger, which is a special kind of stored ...
    (microsoft.public.vb.enterprise)