Hi,
We are merge replication more than 20 databases . Currently we added
one new column to a table so it will be added only in last, and now only in
this table the rowguid is not the last column.
I want to know because of this is there is any problem in replication.
Please give me a solution as soon as possible
thanks,
Soura
Soura,
the rowguid column doesn't need t be the last column, and sp_repladdcolumn
is all you need to use in this circumstance.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label databases. Show all posts
Showing posts with label databases. Show all posts
Wednesday, March 28, 2012
rowguid ?
Hi,
I tried to make a replication between two databases, a merge
replication...
But at the end, when the replication agents started, I found lots of errors
that tells me
that it don't knows who is the column 'rowguid'. This column was added only
on the publisher.
Can somebosy tell me what is wrong? what is the right solution?
Thank you in advance,
Alex
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
".:alex:." <alex_77ro@.yahoo.com> wrote in message
news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I tried to make a replication between two databases, a merge
> replication...
> But at the end, when the replication agents started, I found lots of
errors
> that tells me
> that it don't knows who is the column 'rowguid'. This column was added
only
> on the publisher.
> Can somebosy tell me what is wrong? what is the right solution?
> Thank you in advance,
> Alex
>
>
|||your's book title is:
"A Guide to SQL Server 2000 Transactional and Snapshot Replication"
but I need info about merge replication. In fact a little help, I no need to
learn the replication mechanism , etc... because isn't my job. I need a
little info
like I found here:
http://www.databasejournal.com/featu...le.php/1438231
Thank you for your attention,
Alex
PS: I'm mechanical engineering too ;)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||Can you post the error number, and possibly the exact message.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||I don't know a number or the exact message, because I disabled the
publisher and I cannot reproduce the scenario from my station (in this case
the test computer) because I cannot start de SQLServerAgent.
I will research ...
Thank you anyway
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMiaskjgFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Can you post the error number, and possibly the exact message.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
sql
I tried to make a replication between two databases, a merge
replication...
But at the end, when the replication agents started, I found lots of errors
that tells me
that it don't knows who is the column 'rowguid'. This column was added only
on the publisher.
Can somebosy tell me what is wrong? what is the right solution?
Thank you in advance,
Alex
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
".:alex:." <alex_77ro@.yahoo.com> wrote in message
news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I tried to make a replication between two databases, a merge
> replication...
> But at the end, when the replication agents started, I found lots of
errors
> that tells me
> that it don't knows who is the column 'rowguid'. This column was added
only
> on the publisher.
> Can somebosy tell me what is wrong? what is the right solution?
> Thank you in advance,
> Alex
>
>
|||your's book title is:
"A Guide to SQL Server 2000 Transactional and Snapshot Replication"
but I need info about merge replication. In fact a little help, I no need to
learn the replication mechanism , etc... because isn't my job. I need a
little info
like I found here:
http://www.databasejournal.com/featu...le.php/1438231
Thank you for your attention,
Alex
PS: I'm mechanical engineering too ;)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||Can you post the error number, and possibly the exact message.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||I don't know a number or the exact message, because I disabled the
publisher and I cannot reproduce the scenario from my station (in this case
the test computer) because I cannot start de SQLServerAgent.
I will research ...
Thank you anyway
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMiaskjgFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Can you post the error number, and possibly the exact message.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
sql
Rowguid - index in system table
Hi,
I am dealing with merge replication.
The missing statistics event points out [MSmerge_tombstone].[rowguid] in all
our databases. Noticed that no specific index for rowguid created in
[MSmerge_tombstone] table specific on this column.
We would like to know why there is no index created on this column.Do we
need to manually create this index?
Does this missing statistics is an indication of potential problem. If so
what could be the corrective action(s) ?
Thanks,
Soura
indexes are only used if the table is greater than 100 pages. This means
that if more than 1500 rows exist in your tombstone table it would benefit
for queries which are done on the rowguid column alone.
The most significant column in the queries is the generation column and also
on the tablenick and rowguid columns. There are indexes on these columns.
Which queries/procs are complaining about the missing statistics? Does
autocreate and auto update statistics help with the performance of this
database?
Also note that by default the metadata tables are cleaned up each time the
merge agent runs so they should be small.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:16760881-928B-4137-A542-D430C97ACC78@.microsoft.com...
> Hi,
> I am dealing with merge replication.
> The missing statistics event points out [MSmerge_tombstone].[rowguid] in
> all
> our databases. Noticed that no specific index for rowguid created in
> [MSmerge_tombstone] table specific on this column.
> We would like to know why there is no index created on this column.Do we
> need to manually create this index?
> Does this missing statistics is an indication of potential problem. If so
> what could be the corrective action(s) ?
> Thanks,
> Soura
I am dealing with merge replication.
The missing statistics event points out [MSmerge_tombstone].[rowguid] in all
our databases. Noticed that no specific index for rowguid created in
[MSmerge_tombstone] table specific on this column.
We would like to know why there is no index created on this column.Do we
need to manually create this index?
Does this missing statistics is an indication of potential problem. If so
what could be the corrective action(s) ?
Thanks,
Soura
indexes are only used if the table is greater than 100 pages. This means
that if more than 1500 rows exist in your tombstone table it would benefit
for queries which are done on the rowguid column alone.
The most significant column in the queries is the generation column and also
on the tablenick and rowguid columns. There are indexes on these columns.
Which queries/procs are complaining about the missing statistics? Does
autocreate and auto update statistics help with the performance of this
database?
Also note that by default the metadata tables are cleaned up each time the
merge agent runs so they should be small.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:16760881-928B-4137-A542-D430C97ACC78@.microsoft.com...
> Hi,
> I am dealing with merge replication.
> The missing statistics event points out [MSmerge_tombstone].[rowguid] in
> all
> our databases. Noticed that no specific index for rowguid created in
> [MSmerge_tombstone] table specific on this column.
> We would like to know why there is no index created on this column.Do we
> need to manually create this index?
> Does this missing statistics is an indication of potential problem. If so
> what could be the corrective action(s) ?
> Thanks,
> Soura
Tuesday, March 20, 2012
row level security and Integration services bulk inserts don't work
Hi i followed Microsofts "Implementing Row-and-Cell-Level Security in Classified Databases Using SQL Server 2005"
this works fine when i insert delete data on a normal script (mangement studio)
my project runs in a SSIS package, different users. i cannot do a bulk insert using OLEDB data Destination i get the following error
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabelMarking". This may be caused by a conflicting hint specified for a view.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabelMarking". This may be caused by a conflicting hint specified for a view.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabel". This may be caused by a conflicting hint specified for a view.".
Error: 0xC0209029 at Data Flow Task, OLE DB Destination 1 [1741]: The "input "OLE DB Destination Input" (1754)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (1754)" specifies failure on error. An error occurred on the specified object of the specified component.
Are you using the "fast load" data access mode with the "table lock" option checked?|||
Hi Duane.
Access Mode = OpenRowset Using FastLoad
Fast Load Options = TABLOCK,CHECK_CONSTRAINTS
these are the default values in the OLE DB Destination. is this correct?
|||
Yes, those are the default values.ajedi2k wrote:
Hi Duane.
Access Mode = OpenRowset Using FastLoad
Fast Load Options = TABLOCK,CHECK_CONSTRAINTS
these are the default values in the OLE DB Destination. is this correct?
What type of connection manager are you using in the OLE DB destination?
|||I'm using a OLE DB connection to an SQL server 2005 DB.
is this what you mean?
|||
my bad,
i was actually inserting to a view, and view had triggers.
must set FastLoadOptions = FIRE_TRIGGERS
works fine 
row level security and Integration services bulk inserts don't work
Hi i followed Microsofts "Implementing Row-and-Cell-Level Security in Classified Databases Using SQL Server 2005"
this works fine when i insert delete data on a normal script (mangement studio)
my project runs in a SSIS package, different users. i cannot do a bulk insert using OLEDB data Destination i get the following error
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabelMarking". This may be caused by a conflicting hint specified for a view.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabelMarking". This may be caused by a conflicting hint specified for a view.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabel". This may be caused by a conflicting hint specified for a view.".
Error: 0xC0209029 at Data Flow Task, OLE DB Destination 1 [1741]: The "input "OLE DB Destination Input" (1754)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (1754)" specifies failure on error. An error occurred on the specified object of the specified component.
Hi Duane.
Access Mode = OpenRowset Using FastLoad
Fast Load Options = TABLOCK,CHECK_CONSTRAINTS
these are the default values in the OLE DB Destination. is this correct?
|||Yes, those are the default values.ajedi2k wrote:
Hi Duane.
Access Mode = OpenRowset Using FastLoad
Fast Load Options = TABLOCK,CHECK_CONSTRAINTS
these are the default values in the OLE DB Destination. is this correct?
What type of connection manager are you using in the OLE DB destination?
|||I'm using a OLE DB connection to an SQL server 2005 DB.
is this what you mean?
|||
my bad,
i was actually inserting to a view, and view had triggers.
must set FastLoadOptions = FIRE_TRIGGERS
works fine 
Row Level Security
I am looking into row level security and found a good article:
Title: Implementing Row- and Cell-Level Security in Classified
Databases Using SQL Server 2005
URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
Is this still a good approach to take for a secure database? If not,
what would you recommend?
Are you aware of any sample project and DB that implements the above
approach?
ThanksHi,
as there is no row-level security bya default in SQL Server you will always
have to implement it for yourself. Implementation which I have seen
implemeted row level security (using the SUser_Name) with functions like
suser_Name() up to solution with passing hashes or certificates to SQL
Server. Row Level security is still an appropiate solution for making a
granular access to your data.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
<hufaunder@.yahoo.com> wrote in message
news:1173046321.597432.77820@.n33g2000cwc.googlegroups.com...
>I am looking into row level security and found a good article:
> Title: Implementing Row- and Cell-Level Security in Classified
> Databases Using SQL Server 2005
> URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
> Is this still a good approach to take for a secure database? If not,
> what would you recommend?
> Are you aware of any sample project and DB that implements the above
> approach?
> Thanks
>
Title: Implementing Row- and Cell-Level Security in Classified
Databases Using SQL Server 2005
URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
Is this still a good approach to take for a secure database? If not,
what would you recommend?
Are you aware of any sample project and DB that implements the above
approach?
ThanksHi,
as there is no row-level security bya default in SQL Server you will always
have to implement it for yourself. Implementation which I have seen
implemeted row level security (using the SUser_Name) with functions like
suser_Name() up to solution with passing hashes or certificates to SQL
Server. Row Level security is still an appropiate solution for making a
granular access to your data.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
<hufaunder@.yahoo.com> wrote in message
news:1173046321.597432.77820@.n33g2000cwc.googlegroups.com...
>I am looking into row level security and found a good article:
> Title: Implementing Row- and Cell-Level Security in Classified
> Databases Using SQL Server 2005
> URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
> Is this still a good approach to take for a secure database? If not,
> what would you recommend?
> Are you aware of any sample project and DB that implements the above
> approach?
> Thanks
>
Subscribe to:
Posts (Atom)