Yes, sp_rename!

Tks,
Rinaldo

----- Original Message -----
From: "Jeff Mason" <jeffm.ma.ultranet@r...>
To: "sql language" <sql_language@p...>
Sent: Sunday, August 25, 2002 2:50 PM
Subject: [sql_language] RE: sintax error when [ ALTER TABLE]


> Your original question was regarding the ALTER TABLE ALTER COLUMN T/SQL
> command, and I stand by my response that it is not possible to use this
> command to change the replication properties of a column.
>
> If you look at the SQL generated from EM using the technique you
described,
> you'll see that the way EM handles this is to create a *new* table with
the
> CREATE TABLE ADD <column> ... command, copy the contents of the original
> table to the new table, delete the original, and rename the new table to
the
> original name.
> --
> Jeff Mason Custom Apps, Inc.
> Jeff@c...
>
> -----Original Message-----
> From: Rinaldo Zanzini Junior [mailto:rzjsistemas@u...]
> Sent: Sunday, August 25, 2002 8:35 AM
> To: sql language
> Subject: [sql_language] RE: sintax error when [ ALTER TABLE]
>
>
> Jeff,
>
> In SQL 2k just right-click in  - Table/Design Table - and change
properties
> of the field.
> it's work only in SQL2k.
>
> I have SQL7.0.  Installing SQL2k components in other machine,  I can alter
> an existing column to add the "not for replication" in SQL7.0!  It's works
> very well!!!
>
> tks for answer!
>
> Rinaldo
> rzjsistemas@u...
> rinaldo.giroflex@u...
> SP/Brasil
>
>