Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tizer
Starting Member
2 Posts |
 Posted - 2010-07-24 : 09:59:07
|
| Hi - I'm in a bit (loads) of trouble here.I developed a site in Visual Studio 2008 using a mssql 2008 database only to find that the website is to be deployed on a mssql 2005 setup.I have since found out that the database is not backward compatible, so I cannot simply restore a BAK file from my 2008 server on the 2005 server.But I have learned that you can script your 2008 database and change the server to 2005 and execute the query - which I did, but I am getting errors (lots of them).I think they are all caused by the first error though:Msg 262, Level 14, State 1, Line 3CREATE TABLE permission denied in database 'mvumbraco'.Followed by lots of:Msg 208, Invalid object nameMsg 1088, Cannot find the objectMsg 4902, Cannot find the objectSo am I right in thinking that I do not have the right permissions to create tables on the database?If so - how do I grant the permissions? What other options do I have to move the 2008 database to the 2005 database? I have only found generate scripts?I've been reading tutorials and trying different things all day and have I have to sleep now - but please - if there is any process you can see that I am doing wrong - please post so I can pick it up in the morningThanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-24 : 10:53:23
|
| Correct. You do not have permission. You need to speak to someone who has admin-level permissions and get them to grant your login the permissions you need. You can't grant yourself permissions.Yes, scripting is the only way you're getting a 2008 database back to 2005.--Gail ShawSQL Server MVP |
 |
|
|
tizer
Starting Member
2 Posts |
Posted - 2010-07-24 : 20:42:15
|
| Thank you Gail - that confirmation stops me running round and reading every article on mssql 2005 & 2008 - which I have been doing :) |
|
|
|
|
|
|
Msg 262, Restore Generated scripts