If a column is already in the table, you can change the following column attributes using the MODIFY clause: length, informat, format, and label. The values in a table are either truncated or padded ...

Ok, for SQL server 2000, I need to change the account it runs under. <BR><BR>I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and ...