sql server management studio

Question

Hello

i am using sql server management studio 2008 with (evaluation version of 180 days). I have created tables, stored procedure related to my project connected to my local server name. Now i am not able to open it, since evaluation period has expired. How can i recover previously created tables, stored procedure ?????

Answer 1

you can attach the databases (mdf and Ldf ) files to other server and attach the database with them

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Hello

i am using sql server management studio 2008 with (evaluation version of 180 days). I have created tables, stored procedure related to my project connected to my local server name. Now i am not able to open it, since evaluation period has expired. How can i recover previously created tables, stored procedure ?????

refer below post which is similar to yours.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/34f872bb-7d7f-4169-8042-999e38ed4c8f/evaluation-period-has-expired-sql-server-management-studio

---

Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

Answer 3

1. Set up SS 2008 express
2. Try to open the .mdf/.ldf file of the expired database, after you've attached the old DB, using express version

---

Many Thanks & Best Regards, Hua Min

Answer 4

can you tell me procedure???

Answer 5

sgrash,

• Set up the SQL Server 2008 Express edition first. This should help you:

http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx

http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx

• Now attach the mdf files and create a new database as follows:

http://technet.microsoft.com/en-us/library/ms190209.aspx

---

Thanks,
Jay
<If the post was helpful mark as 'Helpful' and if the post answered your query, mark as 'Answered'>

Answer 6

Hello

i am using sql server management studio 2008 with (evaluation version of 180 days). I have created tables, stored procedure related to my project connected to my local server name. Now i am not able to open it, since evaluation period has expired. How can i recover previously created tables, stored procedure ?????

As probably , not an advised method ,but if you have no other options you can change System date of you PC and start the SQL Server.It will start but please be informed that changing system date can have implications on your SQL Server data if you use timestamp column.

Other method would be to perform an edition upgrade to a licensed version

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Answer 7

if i change date of pc, can i get back my previously created tables and stored procedure???

Answer 8

if i change date of pc, can i get back my previously created tables and stored procedure???

Yes they would be there all tables and objects would be there but it might be possible that consistency of column datetime or date might not be guaranteed .This is just amethod to login into SQL Server dont perform any updates if you have other SQL Server you can use SSIS or import export wizard to move data .Its just a workaround to start your system please dont start workign on DB after changing date you would mess up

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers