title: how to execute a Stored Procedure via zend framework
body: <p>i have a SP in a stored .sql file.
  is there any way so i can execte it with ZF? i dont have any (?) in it.</p>
  
  <p>my codes are:</p>
  
  <pre><code>USE [PIS]
  GO
  
  /****** Object:  StoredProcedure [dbo].[version]    Script Date: 11/24/2011 12:47:09 ******/
  IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[version]') AND     type in (N'P', N'PC'))
  DROP PROCEDURE [dbo].[version]
  GO
  
  USE [PIS]
  GO
  
  /****** Object:  StoredProcedure [dbo].[version]    Script Date: 11/24/2011 12:47:09             ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE procedure [dbo].[version]
  with encryption
  
  as
  select '2.2.213'
  GO
  </code></pre>
  
  <p>by the way im using sqlsrv database driver &amp; SQLSERVER 2008 &amp; PHP5</p>