469,077 Members | 1,457 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,077 developers. It's quick & easy.

Ansi Padding

Dear Friends,

I have a table in which is having some fields which does not allow nulls.
I need to make few of them TO ALLOW NULLS
I went throug SQL Server Enterprise Manager, then right click on the table and then went to the Design view, at that time itself a message got displayed that
"You are not logged on as the Database Owner or Sys Admin You must not be able to save the changes to the table which you do not own"

Then when I was trying to put a tick in the Allow Nulls option and then trying to save the changes, it displays
'One or more columns have ANSI PADDING OFF
AND WILL BE RECREATED WITH ANSI PADDING ON"

I clicked on OK and then MY SYSTEM IS ALMOST STUCK.

Any body can help me on this matter.

I just want to make certain fields TO ALLOW NULLS.

Million Thanks in advance.

Warm regards
Thomas Philipose
Oct 18 '06 #1
0 2809

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Red | last post: by
2 posts views Thread by Knoxy | last post: by
13 posts views Thread by Amarendra | last post: by
2 posts views Thread by Sandy | last post: by
36 posts views Thread by phil-news-nospam | last post: by
reply views Thread by tphilipose | last post: by
12 posts views Thread by Kislay | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.