471,575 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,575 software developers and data experts.

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 2838

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
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.