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...?

When I do above process, script does not execute...

Please help me in this problem

Nilesh Pethani

Sorry for including code in comment...

Here is the sample procedure i use to execute without the any SET command, but still it is not working...

```
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

```