for example
create or alter abc.user_sp1(id int)

begin

select @var1=col1, @var2=col2
from abc.table1 a join table2 b on a.id=b.id
where condition;
------
Some DML statements
----
end

The message "No replicated transactions available" is showing when you are checking the synchronization status and the sync job is always running once u start. This is happening because the...

Thanks Sean for your post..

For this example it works fine..

Just consider these examples...

'US Eastern District Court'

'Southern District Court of US'

For this also it is giving the same value. Actually...

While Creating database you can specify the collation type you want.

By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS

If you are getting error, you can specify as column name COLLATE...

That is because you are doing bit wise AND operation

1 1 1 1 1 0 1 0 0 0 = 1000 &

0 0 0 1 1 0 0 1 0...

Why you discarded these rows?

100.00 | 00001 | fin | 1

100.00 | 00002 | welson | 2

In what sense, you are grouping and adding the data?

Why it is not an error?

You can do the synchronization with the help of SQL Delta tool...

Pls check it out....

Pls provide the query which gave this error

Could you please try this query

SELECT TOP 10 db.name,

[text],

...

Full Text Indexing for exact match

If the search content contains apostrophe and the letter next to it is among (d,m,s) it won't work as it is specifying the date time...

I got the answer. It is because am checking this condition for status in one of the triggers..

Thanks to All

You have wrongly declared @criteria as int. It should be varchar. First you have to form a query. Then execute it..

Pls check the below code.

DECLARE @CriteriaA VARCHAR(10), @CriteriaB varchar(MAX)

SET @CriteriaA...

Pls check this.. May be useful

http://mssqltipsandtricks.blogspot.in/2012/08/how-to-schedule-auto.html

I think it is because you are trying to replicate the identity column, which is similar to insert explicit value in a identity column.

So, please check the below link may...