MikeMCSD
asked on
Changing a field in a table - won't allow
Using the Designer in SQL Server 2008, I want to change a field from :
nvarchar(400)
to
nvarchar(200).
I get the message :
"Saving changes is not permitted. The changes you have made require the following tables to be droppped and re-created . . ".
How can I get around this?
nvarchar(400)
to
nvarchar(200).
I get the message :
"Saving changes is not permitted. The changes you have made require the following tables to be droppped and re-created . . ".
How can I get around this?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is up to you what you're more comfortable using to be honest.
As for Win 7... that's a different (and long) story.
As for Win 7... that's a different (and long) story.
As I have said in http:#a35730110, if there are dependencies like index aso. you need to use SSMS. It will do all necessary steps to perform the change. Doing that yourself in SQL is a PITA.
ASKER
Is it safer to use the Designer instead of SQL when making changes like this?
>> This is a SQL 2008 thing and IMHO it's rather dumb...
You want to see dumb, start using Windows 7. It blocks you from doing a lot of things and I hate it.