This may be a stupid question
I am going to setup "walk the log" replication as shown
1. Server A dumps its log every 10 min
2. Server B loads the log every 12 min
I know how this works and it is fine and dandy, but can anyone do any transactions on Server B? if so what does that do to trying to keep things in sync and rollback?
Thanks
Pat
I have to make some quick and dirty changes to some open source code I'm working with. I need to be able to look in one table for all records that fit a filter like this:"Select ProductID, quantity, attributes From OrderItem WHERE Orderid = " & sOrderIdFor each row, I grab the ProductID and attributes. Then I need to find the record in another table where the ProductID is the same, and the ListItem field is a substring of attributes. To help clarify, Attributes may be "<b>Color</b>: Black<br>". ListItem would be "Black", a substring of Attributes.Once I find the record I'm looking for, I'll need to update a field in second table.I've been using Strongly Typed Datasets so far. I don't know how to walk down two tables in .NET. I'm also very weak on joins. How do I accomplish this? Diane
View 2 Replies View RelatedI am two table. They are backup of each other. I would like to find out what the columns of a row that need to be sync.
For example
Record with ID = 2345, Update Name (From, to) (IreneLee, Irene)
Record with ID = 2345, Update Birthday (From, to) (1975-04-24 , 1975-04-24 )
Record with ID = 4568, Update Name (From, to) (VictorChu, Victor)
I use this statement
with cte1 As
(
Select T1.ID As 'ID',
T1.Name As 'T1Name',
T2.Name As 'T2Name',
T1.Birthday As 'T1Birthday' ,
T2.Birthday As 'T2Birthday'
from T1 inner join T2 on T1.ID = T2.ID
)
Select * from cte1
(eventually I have to programatically generate the above statement)
Below is the result:
ID T1.Name T2.Name T1.Birthday T2.Birthday
--------------------------------------------------------------
1234 Richard Richard 1971-02-09 1971-02-09
2345 IreneLee Irene 1975-04-24 1975-04-24
3456 Danny Danny 1962-09-08 1962-09-08
4568 VictorChu Victor 1962-09-08 1962-09-08
And I use the below script
DECLARE @tableName varchar(max)
Set @tableName= 'T1'
Select column_name From
(
SELECT column_name
[Code] .....
I need to find out what is different between each similar column (e.g. T1.Name and T2.Name) for each row It looks like I need two loop.
This is what the logic I think I need.
For (row in Rows for JoinTable) {
For(column in Columns for ColumnTable) {
if ('T1'.column <> 'T2'.column) {
Insert ('T1.ID' , 'Update T2. ' + column name, 'T1'.column, 'T2'.column)
into #ChangesTable
} } }
Hi, I'm newbie in SQL, could somebody tell me how do I walk through a table one record at a time without using a cursor please.
Greatly appreciated.
Ann
I'm using Virtual PC on my WinXP PC, with two W2K3 environments runnings as Virtual PC guests. My goal is to use these virtual servers to emulate a distributed SSRS environment--prior to setting up a similar environment on physical servers.
One of the W2K3 guests is my database server; the other W2K3 guest is my report server. Just like with a physical SSRS environment, there are many choices that need to be made during the installation and configuration--any one of which, it seems, can prevent the environment from working properly.
Currently, I'm struggling with getting my virtual distributed SSRS environment to work. I could go into the details, but I figured I'd ask a basic question first: Is anyone aware of a book, magazine article, blog, etc. that goes through a distributed SSRS installation--listing the requirements, discussing the choices, considering the implications, etc.?
Off the top of my head, such a walk-through would ideally cover networking configuration issues (Virtual PC or otherwise), Active Directory considerations, Windows Firewall settings between the servers, SSRS-related service account selections, authentication between the servers, etc.
If no one has produced such a walk-through (!), I'd be happy to write one so that others don't have to deal with the same struggles I'm currently dealing with....but I'd need your help.