add column disaster

Hi all, got a disaster on my hands,
ive added a field to a merge replication through the enterprise manager, in
the create manage publications, and its propogate ok to one server, but to
another server, when the merge agent runs, the agents timesout trying to add
the field, and its locking the users at the subscriber out, this table has
about 3 million rows in it. ive tried deleteing the contents, and even
truncating the contents of the table at both publisher and subscriber, but
this also locks out the users.
so the problem is that i cant run the merge agent as the field wont add at
the subscriber, times out and stops, so non of the data changes in the other
tables are getting fed accross.
Any help would be great cheers Andrew
use profiler to determine what process is locking with the merge agent
running on the subscriber and kill it. Try to keep all users off this
problem subscriber until it has completed.
"andrew bourne" <andrewbourne@.vardells.com> wrote in message
news:u7qot480FHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi all, got a disaster on my hands,
> ive added a field to a merge replication through the enterprise manager,
> in the create manage publications, and its propogate ok to one server, but
> to another server, when the merge agent runs, the agents timesout trying
> to add the field, and its locking the users at the subscriber out, this
> table has about 3 million rows in it. ive tried deleteing the contents,
> and even truncating the contents of the table at both publisher and
> subscriber, but this also locks out the users.
> so the problem is that i cant run the merge agent as the field wont add at
> the subscriber, times out and stops, so non of the data changes in the
> other tables are getting fed accross.
> Any help would be great cheers Andrew
>

AD group in SQL Server

Hi there
I have some AD groups added to SQL Server. Now this groups was renamed in
the AD, but in the SQL Server there is the old name shown. How can I
syncronize the name of the AD with the name displayed in SQL Server?
Thenks for helping
Juerg
I think the only way to do this (other than dropping/re-adding) is to update
the sysxlogins table..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JZ" <JZ@.discussions.microsoft.com> wrote in message
news:05C976B7-5230-4745-BB1F-E7560F1FA7BC@.microsoft.com...
> Hi there
> I have some AD groups added to SQL Server. Now this groups was renamed in
> the AD, but in the SQL Server there is the old name shown. How can I
> syncronize the name of the AD with the name displayed in SQL Server?
> Thenks for helping
> Juerg

AD group in SQL Server

Hi there
I have some AD groups added to SQL Server. Now this groups was renamed in
the AD, but in the SQL Server there is the old name shown. How can I
syncronize the name of the AD with the name displayed in SQL Server?
Thenks for helping
JuergI think the only way to do this (other than dropping/re-adding) is to update
the sysxlogins table..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JZ" <JZ@.discussions.microsoft.com> wrote in message
news:05C976B7-5230-4745-BB1F-E7560F1FA7BC@.microsoft.com...
> Hi there
> I have some AD groups added to SQL Server. Now this groups was renamed in
> the AD, but in the SQL Server there is the old name shown. How can I
> syncronize the name of the AD with the name displayed in SQL Server?
> Thenks for helping
> Juerg