This question was posted on the 2005 forum. There are very different behaviours between 2000 and 2005 when it comes to DDL and replication.

Please, do not double post and make...

>>I'd take dynamic SQL any day over cursors... 😉 <<

I wouldn't. Do you know that your code is easy target for sql injection ?

Also, I would use "union all" ...

Alter table

Alter column new_datatype

just make sure your types are implicitly convertible.

Cheers,

I have done it with Transactional, Not with Peer-to-Peer.

By the way I have changed the datatype, not the name!!

Cheers,

>> Essentially to alter a replicated table remove it from the publication, make changes , and add it back. <<

Not true anymore, in 2005 you can use DDL and replication...

Tail is a term used when trying to recovering a database to a point in time and it reffers to whatever is on the transaction log. I assume they call...

The correct way is to size your transaction log so that you should never need autogrow.

I know you are going to say... it is not possible. Well it is ......

And Set a Primary Key on the table so that the app fails when it tries a second time

Just for the record ISNUMERIC is not reliable either

And Add to that sample DDL and Data.

Help us help you

Cheers,

When you "insert" , "update" or "delete" using a linked server you are starting a distributed transaction. For that to work you need to make sure that DTC is correctly...

- Scan Density [Best Count:Actual Count].......: 12.69% [28904:227762]

- Logical Scan Fragmentation ..................: 51.86%

- Extent Scan Fragmentation ...................: 98.75%

Dude your table is screaming for degragmentation. If you still don't want to...

Watch out for what you ask. Encrypted data can not benefit from indexes, grouping, searches, agregations etc. As long as you are ok with those limitations and have tested a...

Secondary FG with multiple files will speed reads and writes as long as we're not talking RAID 5 here.

Downtime is a need for the operation. I have never added...

I also believe is not the recommended way but I have done it successfully for a *long* time.

backup database to disk='\\ServerName\ShareName\Yourbackupfile.bak' with stats=10

Cheers,