HEllo All, I am in a problem in my sql database.I have a DB in sql 2005.I just want to rename that DB and want it in sql 2008 without losing its data.For examble,i have a mdf and a ldf file of a DB named "Hello" in sql 2005 with a 1000 data,i want to save this DB in sql 2008 in another name "HAi".Anybody please help me.......
+2
A:
Just go into SQL Server Management Studio, select the database, and press F2.
Dave Markle
2010-10-14 10:50:48
thanks for your advise but its not working
Aneesh
2010-10-14 11:18:03
You likely don't have permissions to do this. You should also post your error messages and proper details about exactly what you are trying to do and how to do it.
Dave Markle
2010-10-14 12:42:10