Select your Publication Right Click Go to Publication Properties -> Agent Security you will the find the user credential to be used for SnapShot Agent and Log Agent

You cannot call insert like that, = operator works while you are updating any row or table.

Another option other then suggested above would be, Initilizing the subscriber from backup, this saves a lot of time of applying snapshot to subscriber,

The intial snapshot apply would also...

Bhaskar.Shetty (5/23/2013)

---

What is the problem I see here is your statement to check the Departuredate is wrong, from the below query it will return the rows where departuredate is less...

I mean when you change the datatype of num1 or num2 from varchar to int, it will not parse the value 858.621 because the int will not hold decimal places....

What is the problem I see here is your statement to check the Departuredate is wrong, from the below query it will return the rows where departuredate is less the...

First Query

declare @LeaveDate datetime

SET @LeaveDate = '04/19/2013'

select * from leavecard where @LeaveDate between StartDate and EnDate

Second Query

declare @LeaveDate datetime

declare @Name varchar(50)

SET @LeaveDate = '04/19/2013'

set...

The 858.621 value is not an int value should be cast with decimal or numeric.

Generate the data result in that manner, probably with two different query's and column list.

Check the setting of Copy INSERT, UPDATE, DELETE stored procedures for this article should be set to true.

Provide User info while connecting using -E or -U switch,

-E : Is Trusted connection

-U : UserName to connect and later it will ask for pass to connect

That's something to do with your authentication server on which you are a user, and you might be selecting windows authentication mode while connecting to sql server, What happens when...

GilaMonster (5/22/2013)

---

You wouldn't want to do that and it would be entirely useless to do....

GilaMonster (5/22/2013)

---

Parameter...

GilaMonster (5/22/2013)

---

I would disagree there, stats that are more than a day old and have a single row change absolutely do not need updating. That's almost as bad as blanket...