Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: sp_repladdcolumn while live?

    When the snapshot runs it will only create a snapshot of the table with the new column.  It will not create a snapshot of your entire database.

    I am not sure...

  • RE: sp_repladdcolumn while live?

    I use the following to add a column to transaction replication. 

    sp_repladdcolumn        @source_object = '<table name>',

                @column = '<new column name>',

                     @typetext = '<datatype> <NULL or NOT NULL>...

  • RE: How to clear Replication Error

    All tables in all database are exactly the same.  It is a varchar(3000) data type.  I don't want to have to deleted the subscription and re-create it but I know...

  • RE: Slow SQL Server 2000 Performance

    Tom,

    The performance was good at one time and has gotten worse in the past few weeks.

    How do I target specific areas like queries, procedures, application load and connection?

    My network engineer is...

  • RE: Remove Replication

    did you try the following

    sp_removedbreplication 'database name'

    Make sure that all subscription to this publication have been deleted before running the sp.

  • RE: Another Distribution agent for the subscriptiion

    I checked the processes and there is only one process with the sp_MSget_repl_commands.

    The subscription is a pulled subscription and I checked the server with the pulled subscription and there is...

  • RE: Another Distribution agent for the subscriptiion

    How can I tell which process is running the distrubtion agent?

    I ran the sp_who2 and have a list of processes. I see several processes for the distribution database. ...

  • RE: DB Maintenance Plan not running

    The only thing that I changed was I took away system administrators rights from the the Built-In\Administrators user login. When I put back the Admin rights the backups started...

Viewing 8 posts - 1 through 8 (of 8 total)