Trust the error message: the data file is out of space!

When you modify a column, SQL server will create a new table tmp_MyTable
with the modification you made, then bulk insert all columns to it from your
current table MyTable. If successful, it will then drop MyTable and rename
tmp_MyTable MyTable. If your table is big, it should require a large space
and a long time to do the job.

Gary Xu



-----Original Message-----
From: Himanshu Chaudhari [mailto:himanshuchaudhari@y...]
Sent: Wednesday, February 20, 2002 3:30 AM
To: sql language
Subject: [sql_language] sql error


 i was having  a field as a char one . I opened 
table(accountdetail)  online with the enteprise
manager. when i modify that char field to nvarchar one
 it is giving me modify error . 

ODBC Error : unable to modify table .couldnot allocate
space for object tmp_accountdetail in database because
the primary filegroup is full.


What could be the error .


Thanks

       Himanshu

________________________________________________________________________
Looking for a job?  Visit Yahoo! India Careers
      Visit http://in.careers.yahoo.com

$subst('Email.Unsub').


This electronic message transmission, including any attachments, contains information from PacifiCare Health Systems Inc. which may
be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not
the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is
prohibited.  

If you have received this electronic transmission in error, please notify the sender immediately by a "reply to sender only" message
and destroy all electronic and hard copies of the communication, including attachments.