View Single Post
Old 11-01-09, 05:15 AM   #5
LovingSticky
plenty of work, no games
 
LovingSticky's Avatar
 
Join Date: Sep 2007
Posts: 559
Default Re: Migrating from SQL 2005 to SQL 2008

Simple Attach/Dettach is not enough. To use version 10 (SQLSRV 2008) functionality, you have to change Compatibility Level as well, in DB Properties/Options.
__________________
Q9550@3.4 + Asus P5Q Premium + 16GB RAM + 2xVelociraptor 300GB + 4xWD Black 1TB RAID-5 on Adaptec 5805 + PoV GTX580 + Dell 3008WFP + Windows 7 x64
Xbox 360 Elite + Kinect + Onkyo receiver + Acoustic Energy Aelite 1/3/center speakers + 46" FullHD Samsung TV
LovingSticky is offline   Reply With Quote