Post reply

Import sql server 2005 stored procedure to sql server 2000

  • November 29, 2005 at 7:20 pm

    #169810

    Hi,

    i have sql server 2000 and sql server 2005(trial) installed on different machine. What i want to do is running the aspnetdb database on 2000.Ofcourse i can only run aspnet_regsql on 2005.

    I already now have my aspnetdb.mdf on 2005. What i want to do now is to import this database on 2000. I used export from 2005 but stored procedure did not transfer. How can i get this and transefer to 2000 from 2005?

    many thanks.

  • November 30, 2005 at 2:52 am

    #606650

    Expand the SQL Server 2005 database in SMSS then > Programmability > Stored Procedures

    Right click your stored procedure > Script Stored Procedure As.. > CREATE To > File...

    Run this script on your SQL 2000 server.

  • November 30, 2005 at 10:31 pm

    #606947

    Thank you very much..

    I will try this.. Im sure thats the way.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply