How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

I have made a time ago a file backup in SQL Server 2005. Now, I am using SQL Server 2008. I made a restore to that file and everything went fine.

But, every time I’m trying to add a new table to my DB I get this message I can’t understand why:“Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created”and I get in list only the new table I just added.

I don’t know what this means at all. I only added one table, no primary key, no connections, nothing else and it refuses to make the change and save it, so now I’m stuck and can’t change anything on my DB. How can it be?

What may be the problem? Please help and advise :-( Asked by Ranimi23 20 months ago Similar questions: solve problem restore backup file made SQL Server 2008 Computers > Software.

Similar questions: solve problem restore backup file made SQL Server 2008.

1 Well, you could start with the easy one:You have ... enabled the option Prevent saving changes that require the table to be re-created. ”See if you have a box checked somewhere that says "Prevent saving changes. " .

Well, you could start with the easy one:You have ... enabled the option Prevent saving changes that require the table to be re-created. ”See if you have a box checked somewhere that says "Prevent saving changes.

" "How can I restore favorites list back into my I. Explorer from a HD backup file?" "Any recommendations for an EASY to use pc backup software, that is reliable if you actually need to restore the pc/files" "advantages of sql server 2008" "Does Microsoft charge for each installation of SQL Server 2005 Management Studio if you already own the server software? " "The only way to access Mirra Personal Server (seagate) is from the backup software?

Can´t use it like a regular Drive?

How can I restore favorites list back into my I. Explorer from a HD backup file?

Any recommendations for an EASY to use pc backup software, that is reliable if you actually need to restore the pc/files.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.