Showing posts with label hican. Show all posts
Showing posts with label hican. Show all posts

Monday, March 26, 2012

MSrepl_tran_version - needed or not?

Hi
Can someone please tell me, when i setup a publication for
transaction replication (push only), sometimes it says:
"SQL Server requires that all articles in a publication
allowing updatable subscriptions contain a
uniqueidentifier column named 'MSrepl_tran_version' used
for tracking changes to the replicated data. SQL Server
will add such a column to published tables that do not
have one"
But other times it does not ask to do this, and i have
successfully had a replication running without the
requirements is says. Do i need it or not?
Hi
If you want the changes to be replicated from the subscriber to publisher,
using immediate updating or queed updating, it becomes a requirement that
uniqueidentifier column is needed. If you dont want the reverse update, then
you may not need that column. Hope it helps
shrini
"gravity" <anonymous@.discussions.microsoft.com> wrote in message
news:1be901c42700$200f1880$a301280a@.phx.gbl...
> Hi
> Can someone please tell me, when i setup a publication for
> transaction replication (push only), sometimes it says:
> "SQL Server requires that all articles in a publication
> allowing updatable subscriptions contain a
> uniqueidentifier column named 'MSrepl_tran_version' used
> for tracking changes to the replicated data. SQL Server
> will add such a column to published tables that do not
> have one"
>
> But other times it does not ask to do this, and i have
> successfully had a replication running without the
> requirements is says. Do i need it or not?

Friday, March 23, 2012

MSQL Update

Hi
Can anyone help me with the MSSQL following problem:
I want to update the field "Date" with today´s date in a Tabel named Customers
I want to click on a "button" that runs something like:

Update Date with Today´s date where CustomerName = TextBox.text

Thanks in advance for your helpstring strSQL = "UPDATE [Customers] SET [Date] = GetDate() WHERE CustomerName = " + TextBox.Text

basic, basic, basic