Viewing 8 posts - 1 through 8 (of 8 total)
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...
June 28, 2006 at 1:54 pm
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>...
June 28, 2006 at 1:28 pm
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...
June 28, 2006 at 9:24 am
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...
March 4, 2004 at 7:36 am
did you try the following
sp_removedbreplication 'database name'
Make sure that all subscription to this publication have been deleted before running the sp.
September 26, 2003 at 8:57 am
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...
September 26, 2003 at 8:36 am
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. ...
September 26, 2003 at 7:26 am
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...
September 24, 2003 at 11:00 am
Viewing 8 posts - 1 through 8 (of 8 total)