Post reply

How to transfer database of sqlserver 2000 to 2005

  • May 17, 2009 at 11:11 pm

    #200554

    Hi,

    I install sql2005, and transfer my database of 2000 to 2005 (attach my database to 2005 ) but stored procedure and function and fulltext don't transfer . why?

  • May 18, 2009 at 2:05 am

    #996167

    The stored procs and functions are held in the database so will be there when you attach the datafiles. When looking at Management Studio they are in the programmability group under the database.

    The fulltext indexes/catalogues will have to be rebuilt.

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

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