thank you for the question and thanks to all the people that gived more examples to explain it because I have read the microsoft explanation but my comprehension of it...

From what I have seen, the reference is "SQL prompt v4.0" and it is free on trial basic e.g. 14 days.

Seems like a nice software, but I think...

Well, this is more complicated than I was expected, but it is the solution!

Thank you very much!

This was a very very good question.

Event I read the remark section in SQL Server 2008 Books Online about Count_big

(

COUNT_BIG(*) returns the number of items in a group....

Here my story about DB...

Two years ago, I have been told by my boss that I have to create a database and maintain it. The boss knew nothing about...

I am sorry, but I am this poor little new one that is trying to understand SQLserver and, to this question, I do not understand the answer. The question...

Speaking of time, that was a really really good question because it brought me back 30 years ago while I was in school and the professor had to pick up...

The reason that it is "full" by default is because , if I understood well, the model database must always exist on a SQL Server system.

An other thing I learned,...

I think that was a nice question because it practices the capacity to get the details: sometimes, I make error (well it does not append that often :hehe:)...

ouch... "Apex Diff." I don't even know what your are talking about, but I'll check that. It sure would be easier if I knew more about SQL stuff,...

Well, it's been more than 10 days since I ask the question. So, I guess that the merge replication is not possible in my scenario... :alien:

I just have to...

One guy would be in the wood doing environment data stuff (get, analyse, modify data)

After one week, someone will replace him, continue his job and return when the first guy...

Well, I am all ear and open mind to any way that could do the job... Is a manual sync complicated? (note: I am new in the SQL world.)