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
try abc
1.4k
306
487.4k
modifying column type take too much time
Apr 2 2011 2:46 AM
Hello ,
I have 1 table in SQL2005 with 4,00,000 Records . I want to change column type of 1 column from char to varchar. It take too much time & not completes successfully any time .
ALTER TABLE table 1 ALTER COLUMN Comments varchar(5000) null
I also tried with other option like
1)
Add New Column
Update data in that column
Remove old column
Rename New Column to old column name
2) By manually changing from Select Table in object Explorer - right click - modify
But can not succeed in any way.
Also can not be able to use SQL job agent service due to Express version installed at client.
Is there any way to reduce time in this Query in table with hundreds of record.
Thanks in Advance
Reply
Answers (
2
)
get the data of last three hours inserted in the table
Store Procedure not working