title: How to execute SQL Server 2005 generated database query on SQL Server 2008?
body: <p>I need to execute a SQL Server 2005 generated database query (mostly stored procedures) in to SQL Server 2008. Is there anything that I need to keep in mind while doing this process...?</p>
  
  <p>When I do above process, script does not execute...</p>
  
  <p>Please help me in this problem</p>
  
  <p>Nilesh Pethani</p>
  
  <p>Sorry for including code in comment...</p>
  
  <p>Here is the sample procedure i use to execute without the any SET command, but still it is not working...</p>
  
  <pre><code>CREATE  PROCEDURE [dvx_web_MICROSITES_LoadMicrosites]
  AS
  BEGIN
      SELECT
          microsite_id AS ID,
          url as URL,
          [name] as [Name],
          catery_id as CateryID,
          catery_code as CateryCode,
          banner_key as Banner,   
          main_banner_key as MainBanner,
          special_zone_id as SpecialZone,
          homepage_url as MainLink,
          active as Active,
          custom_01 as Custom01,
          custom_02 as Custom02,
          custom_03 as Custom03,
          custom_04 as Custom04,
          custom_05 as Custom05
      FROM
          Microsites
      WHERE
          Active = 1
      ORDER BY [Name] ASC
  END
  </code></pre>