Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mukeshgupta01
Starting Member
4 Posts |
 Posted - 2009-02-01 : 01:47:15
|
| I was trying to alter the column length of a replicated table but SQL SERVER didn't allow me saying it can't alter the column since it's being replicated.In the above scenerio, the replication was setup on two different servers.But if it ran the same query on a local server with replication setup, it allows me to alter the column lenght of replicated table.Can anybody please help me in explaining the behaviour of replication on a local server and different server while altering the column lenght of a table? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-01 : 12:10:42
|
| While altering the column width you have to use Query(Alter table... ALter column) not Management studio GUI features. Remember to check constraints before you do that. |
 |
|
|
mukeshgupta01
Starting Member
4 Posts |
Posted - 2009-02-01 : 13:17:30
|
| I was using the query to alter the column width not the Management Studio. The problem is that the behaviour was diffenent when the replication databases were on same server and different when the replication databases were on different server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-01 : 14:15:04
|
| What Edition ,Version is other server? |
|
|
|
mukeshgupta01
Starting Member
4 Posts |
Posted - 2009-02-02 : 03:01:57
|
| Microsoft SQL Server 2005 - 9.00.3073.00 (X64) Aug 5 2008 14:31:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 09:03:28
|
quote:
Originally posted by mukeshgupta01
Microsoft SQL Server 2005 - 9.00.3073.00 (X64) Aug 5 2008 14:31:47 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
You should be able to change column width with it. What type of replication are you using? |
|
|
|
mukeshgupta01
Starting Member
4 Posts |
Posted - 2009-02-03 : 00:26:25
|
| Transactional replication |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 09:25:44
|
| what is compatibility level of databases in both servers? |
|
|
|
|
|
|
Weird Replication Problem