TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Aamir Khan
NA
277
439.1k
Warning While Adding a New Field in Sql Server 2000 Database Table
May 9 2012 7:15 AM
Dear Friends,
I am facing a Warning Message in sql server 2000, while Adding 2 Fields by using
Alter Query.
My Query:
1)alter table Receipt_Detail_New
add BillingName varchar(100)
it shows me the Following Message:Warning The table 'Receipt_Detail_New' has been created but its maximum row size (9886) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
2)alter table RECEIPT_PAYMENT
add BillingName varchar(100)
it shows me the Following Message:Warning: The table 'RECEIPT_PAYMENT' has been created but its maximum row size (11121) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
what could be done in such Cases
Please Reply.
Thanks & Regards,
Aamir
Reply
Answers (
5
)
Custom code in SSRS
Implict & Explict Transaction