Home Forums SQL Server 2005 Administering Calling a Stored Procedure from a View RE: Calling a Stored Procedure from a View

  • July 22, 2008 at 11:31 am

    #846561

    CrazyMan (7/22/2008)

    Hi Gila

    I found a work around, but iam facing error, the work around is

    select * from OpenRowset ( 'SQLOLEDB','Server=(Local);TRUSTED_CONNECTION=YES;','Exec Temp.dbo.Software') as a

    Ouch. That's extreme. And a bad idea.

    Please explain why you need the results of a proc in a view.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass