Increase Columns Width Of Merge Replicated Table

Dec 29, 2004

We are using merge replication and it is working fine. We are looking for increase in on numeric column 10,5 instead of 7,2. How I can do it?

Any suggession highly appreciated by us.

Thanks

View 1 Replies


ADVERTISEMENT

Increase The Width Of The Columns In Chart

Nov 27, 2007

HI All,
I want to increase the width of the bars, displayed on the columns chart. For better visibility. How can I do that?

View 1 Replies View Related

Transactional Repln,how To Modify The Width Of A Column Of A Table Which Is Replicated

Aug 3, 2006

Hi All,
Is there a way by which we can modify the width of a column of a table which is being replicated without touching the ongoing transactional replication? This is for MSSQL2000 Transactional Replication.

I know (and successfully tried) that we can add a column to a table and that gets propaged to the replicate database and indeed the added column gets reflected there. How to add a column? sp_repaddcolumn or Right Click on the Publication-Properties and it shows a button to Add a Column.

This is what I have tried for modifying the width of a column of a table participating in Transactional Replication from varchar(10) to varchar(100)

MH (source) -> MH1 (Replicate)

The column €ścol1€? had width of varchar(10) and this was altered to varchar(100).


insert into MH..test_mh values(4,'abcdeabcdefff')

select * from MH1..test_mh

exec sp_dropsubscription @publication = N'MH', @article = N'test_mh', @subscriber = N'UKPBDRMTST2', @destination_db = N'MH1'
go

exec sp_droparticle @publication = N'MH', @article = N'test_mh'
go

alter table test_mh alter column col2 varchar(100) null OR

MH1..sp_help test_mh

exec sp_addarticle @publication = N'MH', @article = N'test_mh', @source_table = N'test_mh'
go

exec sp_addsubscription @publication = N'MH', @article = N'test_mh', @subscriber = N'UKPBDRMTST2' , @destination_db = N'MH1'
go


Needless to say, help would be apreciated -
~Mihir

View 4 Replies View Related

Select Columns With Correct Width For Fixed Width Flat File?

Dec 6, 2013

I have like 100 columns and most of them work fine, but some will not work. I need to select the columns with correct width for fixed width flat file.

Here is typical SQL statment that works for most of them.

left(RTRIM(A.City) + Replicate(' ', 25) ,25) as [City]

The above one is not working, but many other works fine like the address. Why would it work for some, but not others?

It works fine if I use any char, but not space. i.e.

left(RTRIM(A.City) + Replicate('*', 25) ,25) as [City]

View 5 Replies View Related

Rename Replicated Table Columns

Jun 10, 2015

I need to rename a replicated table columns.will this affect my current replication (Transactional replication)? Do i have to create a new snapshot and restart the subscriber?

View 1 Replies View Related

Reporting Services :: How To Increase Width Of Textbox Dynamically Or Automatically

Aug 30, 2015

Do we have any option to increase/decrease textbox width dynamically? I know that we have option to increase or decrease height.

View 6 Replies View Related

OLE DB Source To Flat File Destintation Using Fixed Width Columns - Determining Source Column Width

Feb 13, 2007

Hi,

I am trying to create a program that transfers tables to flat files.
At this point in time, I have suceeded in created one that creates delimited files.

However, I am now trying to create fixed-width files as you can do with the SSIS designer, but programatically.

Is there a way to programatically determine the width of a column from the source table? I can not seem to find any kind of function or member that stores this information or allows me to retrieve it.

I know what I need to change in order to set a width for a column, but I just don't know how to find the width without just asking the user to provide one.

View 5 Replies View Related

Moving A Merge-replicated Database For SQL CE

Apr 6, 2004

Is there a way to move a SQL replicated database from one server to another without dropping the publication?
I have SQLCE setup with SQL server 2000; I want to redo the server but needs to move my replication to a temp server and then back.
The problem is that I do not want to drop my subscription and recreate it…it needs to stay the same.

View 2 Replies View Related

All Rows Are Not Replicated Correctly (merge)

Sep 28, 2007

Hi all! Hope you can help us with this one. We installed SP 2 of Sql server 2005 few months ago, and that caused a strange problem with merge replication.

We have about 150 subscribers in one merge publisher, and 200.000 new rows generated each day (retail system). Most tables are filtered.

Replication and filtering works fine, except 0,1% --> 0,2% of rows are not replicated correctly. These "problem-rows" are always replicated correctly to the publisher database, but publisher can't always replicate these rows further to other subscribers. Before SP2 everything worked fine.

Same problem occurs with filtered and non-filtered tables.

SQL Server shows no errors or warnings, everything SEEMS to work fine.

We have to make "dummy"-updates (like update SALES set id=id) in publisher database, to wake up the replicator. And always after these dummy updates all problem-rows will be replicated correctly from the publisher to subscribers.

Why do we have to "wake up" the replicator time to time with dummy updates? Is there a bug in SP2?

View 3 Replies View Related

Merge 2 Columns From The Same Table

Sep 19, 2006

Hi *,

I have a table with 2 columns A1 and Firm. A1 holds "dirty data" and there are no NULL values. Firm holds "clean data" for some of the rows in A1 but not for all. So there are quite a few NULL values in this column. I want to replace the value in A1 if there is any data in Firm (value <> NULL).

Rigth now, I solve this issue with a simple VB.NET script:
Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) ' If Row.Firm_IsNull Then Row.Standard = Row.A1 Else Row.Standard = Row.Firm End If ' End SubEnd Class


Any ideas how to solve this issue without custome code?

Thanks!

View 1 Replies View Related

Enumerate Subscriptions In A Merge Replicated CE Database?

Jun 27, 2007



How can I list all of the Subscriptions in a CE Database that was created with the .Net System.Data.SqlServerCe.SqlCeReplication.AddSubscription method?



After I create the CE database in an sdf file, I can connect to it with SQL Servr Mgmt Studio, then see the list of Subscriptions in the Object TreeView, under "Replication"



But I can't find that Subscription list in any properties or methods of System.Data.SqlServerCe.SqlCeReplication or System.Data.SqlServerCe.SqlCeConnection



Should I be looking in RMO features like Microsoft.SqlServer.Replication??



We want to confirm that a local CE database was last synced from the expected SQL Server database by checking the Publisher property of each subscription in the CE database.



Thanks

View 3 Replies View Related

Addition Of Columns In Table, Which One Use In Merge Replication.

Nov 29, 2004

Dear all participants,

I manage complete online system for two locations, connected via dialup lease line. I have to used merge replication for the same data should be at both locations. It is working fine, I don’t like disturbe it but current requirement is addition of two column in one table which one as also use in merge replication.

How I can add aforesaid columns in table x, column name c1 numeric , c2 character?

What is impact on replication?

Let me know step by step.

Thanks in advance.

Thanks R.Mall

View 1 Replies View Related

Snapshot Replication - New Columns Not Replicated

Oct 10, 2005

I added couple of new columns to the distribution database and those new columns are not being replicated.

View 3 Replies View Related

How To Define Programatically The Width For Columns??

Nov 21, 2006

Hi everyone,

Either Sql2k or Sql25k are targeted if you answer to this thread. When we have source/destination files we usually wish to define its properties, the width for each field and so on. My question is related with this, how do such by-hand tasks via scripting inside the own ETL? Tedious tasks are if there are more than 20 columns.

Is it possible? I think so regarding 2005 but about 2000 I haven't idea at all how to begin. Issue comes when one programmer must alter lots of columns due to for example, a new file format from mainframe is released.

Thanks in advance for your time or advices,

View 1 Replies View Related

SQL Server 2012 :: Increase In Usage Percentage Of All Columns

Aug 24, 2015

I have a table which gets updated with the usage figure every week. Any similar t-sql which returns the increase in usage percentage of all the columns.

View 8 Replies View Related

Report Page Width With Dynamic Columns Through Parameters

Apr 18, 2007

I found the following paragraph while searching on here:

************************************************************************
You could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
************************************************************************

That is exactly my problem. I have lots of dynamic columns which causes the width of the report to be wide. Thus even though at run time the report only shows columns within a page, the report itself consists of a lot of white spaces after the selected columns. Does anyone know a solution to this? If not, I guess creating the rdl with code manually is the only way? Please advise. Thanks in advance.

- Will

View 6 Replies View Related

Deleteing Columns From A Saved Fixed Width File Connection Object

Jun 12, 2006

How do I delete columns in a fixed width column file connection object, after I've saved it I can't remove columns anymore?

View 1 Replies View Related

Subreport Width Expanding Beyond Width Of Container Report

Mar 4, 2008

I have a subreport on my main report, and the subreport contains a matrix. When I run the report, the subreport seems to expand beyond the width of the main report. The matrix itself does not expand beyond the width of the body of the main report, but for some reason it seems that the subreport does. The subreport does not contain any headers that might be messing up the width. If I cut and paste the matrix from the subreport directly onto the main report, and remove the subreport, it prints fine. But as soon as I include the subreport on the main report it prints with blank pages because the subreport expands beyond the width of the body of the main report. I have checked the width and margins on the subreport and compared to the width of the main report and all looks good. Can anyone help?

Thanks.

View 7 Replies View Related

Max Width For Input Fixed Width Column

Jun 1, 2007

Is there a maximum width for fixed width column?

I'm trying to read in a flat file (which, admittedly, has one very wide column), and it keeps breaking because of truncation when it tries to read in the file.

Any ideas?

Jim Work

View 5 Replies View Related

Scaling Width Of Report To Fit To Page Width

Apr 9, 2007

Hi,

I've a report projects where each report has a number of columns and the spec is to have all the columns print-out on the same page. Is there a setting that will auto-scale these columns to fit to the page or will I have to edit the font size and widths manually on each report to fit to the page?

Thanks for any comments.

View 4 Replies View Related

How To Modify Colum (alter Table) Of Table That Is Replicated?

Jul 20, 2005

Hello!I have an MS SQL-server with an database, that runs replication. In thisdatabase there is an table with an columni want to extend; varchar(50)->varchar(60).But I get this error (using design window of Enterprise Manager): Cannotdrop the table 'MytableName' because it is being used for replication.Thanks for helpBjoern

View 1 Replies View Related

ALTER TABLE SWITCH PARTITION On A Replicated Table

Apr 10, 2007

A customer wants to implement table partitioning on a replicated table.



They want to hold 13 months of data in the table and roll off the earliest/oldest month to an identical archive table. The table has a date field and partitioning by month makes sense all around.



So SWITCH PARTITION is the obvious solution to this, except for the fact that the table is replicated (transactional w/no subscriber updates).



What are his architectural or practical solutions to using table partitioning and replication?











thx

View 5 Replies View Related

Replicated Table Is Not Updated

Jun 19, 2008

Dear All,
i've made repliaction stup using the information guide below. all the things are done axactly. now i've inserted a row in the publisher. but i'm not getting the record at the subscriber database. please let me know where i'm missing

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 8 Replies View Related

New Column For Replicated Table

Sep 20, 2007

Hope to be my last question.
I used Transacational with update sub method. When adding new column to replicated table. Do I need to generate new snapshot again? Just want to know how can I apply the new schema to subsciber DB without doing all regenerate snapshot, recreate all tables and bulk copy.. Please help

View 2 Replies View Related

Altering Table Replicated

Feb 2, 2007

How can i change my Table Structure that is replicated?

I need to add a new field.

View 1 Replies View Related

Is It Possible For A Table To Increase Size When Deleting Records?

May 24, 2007

No transaction log involved, only the table itself.



Use sp_spaceused "table_name" to check the space used.



It seems the table size actually increased from the beginning to the middle of deletion, at the end of deletion, its size decreased.



Recovery mode set to be simple, autoshrink turned on.



The tables tested are about 50MB ~ several GB in size, all have the same behavior. The size increased about 5%~10%.



Since the deletion is called from another software, I want to know if it is possible for SQL Server to have this behavior or it is absolutely the 3rd party software's issue



Thanks!

View 2 Replies View Related

Alter Table In Replicated Database

Apr 26, 2003

How can I do an alter table in some table that replicated database ?
I got the error message when I try !

View 3 Replies View Related

Computed Column In A Replicated Table

Apr 10, 2015

I have a strange problem. I have a computed column in a replicated table, the Formula is as follows:

(isnull(hashbytes('SHA2_256',CONVERT([varchar](256),[AccrualReference],(0))),(0))) the column is also Persisted.

This gets around a case sensitivity issue and is used as the Primary Key column, which works well.The problem is that this table is then replicated to another server. On the subscriber the value of this computed field is being returned as 0x00000000 for every row, so this must be the ISNULL function doing its job. But why? The AccrualReference is the true PrimaryKey and is never NULL.

If I remove the computed specification and set the field up as varbinary(64) the value then gets replicated. This then means maintaining a different table schema for in excess of 500 tables.

View 2 Replies View Related

Table Mantenance Within A Replicated Database

Jul 20, 2005

When I try to remove a table, it complains because it's part of apublication. I could script the publication and subscriptions suchthat they can be deleted, the table removed, and then added again.But, I not sure if this is the 'best' approach.Anyone faced this challenge before?Regards,gary

View 1 Replies View Related

Drop Trigger From Replicated Table??

Apr 14, 2007

I created a trigger on a replicated table in a publishing database on SQL Server 2000. When I attempt to ALTER TABLE ... DISABLE TRIGGER ..., I get a message that I cannot alter the table since it is part of a publication. Does anyone know if I would be able to issue a DROP TRIGGER or ALTER TRIGGER on a replicated table?



Thanks,



Gerald

View 1 Replies View Related

Changing A Primary Key In A Replicated Table

Jul 20, 2006

Hi

We have a merge publication - I want to change the primary key for one of the tables (add another column to the primary key)

How do I do it ?

Currently there is no data in the table - which I guess might help..

thanks
Bruce

View 3 Replies View Related

Change Table Column Width

Mar 14, 2000

I know we could change the data type or width of a table column in SQl 7 database, but I am not certain if this column is a primary key. Can we change a primary key column width? If we can, how about this column as a foreign key in another table? Will it be automatically updated to the same width? Thanks in advance for your input.

View 1 Replies View Related

SQL Server 2014 :: Sudden Increase In Table Size?

May 5, 2015

I save Table size and recs. no every day. and check it some days.

...
insert into @t
exec sp_msforeachtable 'exec sp_spaceused ''?'''
...

But Today I saw sudden increase size in a table. about 128 MB in a day. (Average Growth fro this table was 4 or 5 MB in a day)This growth was for Only 4222 Records. While for more number of records (about 7000) in yesterday we had only 2 MB GRowth!

This Table information (Now):

sp_spaceused 'Table1'

Result:

name ---Rows --reserved --data

Table1--1021319--460328 KB --283104 KBI Try to gess The reason. I copy These new records to another table.But The result was more strange : on new table the size of these record was : < 1 MB I copied All records to another table . The size was : 148 MB (while this is 283 MB in my real database)

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved