This is in reply to Mark's post.

You could also use a variable of type TABLE instead of a temporary table.

I wonder which of the 2 methods is the more efficicent?

...

Just wondering... How many of you agree with and think it is a smart idea to marginalize SQL (database) authentication in favour of Windows (Operating System)authentication?

I personally don't agree with...

Thanks Andy

Removing all Windows Users and User groups helped. Now, admins not ** explicitly** granted access are shut out.

declanm, thanks for your reply too. But, I couldn't find where in...

Thanks Andy

I've already tried increasing the timeout period. Didn't really help. The interesting part is that the problem occurs the first time synchronization is attempted after the initial snapshot is...

Hi

Please do correct me if i am wrong, but i think the only effect the collation setting has on UNICODE data is on the sort order.

Here's what BOL says...

1. Unicode...