Database

select name           [Database], 
       collation_name [Collation], 
       case 
          when collation_name like '%\_CI\_%' escape '\' then 'Case insensitive'
          when collation_name is null then 'N/A'
          else 'Case sensitive'
       end
from sys.databases;

select sys.tables.name  [Table],
       sys.columns.name [Column],
       collation_name   [Collation], 
       case 
          when sys.columns.collation_name like '%\_CI\_%' escape '\' then 'Case insensitive'
          when sys.columns.collation_name is null then 'N/A'
          else 'Case sensitive'
       end
from sys.tables 
     inner join 
     sys.columns
     on sys.tables.object_id = sys.columns.object_id;

SELECT     COUNT(idstudent) AS IDStudentCount, idstudent,<br />
                          (SELECT     TOP (1) t1.years<br />
                            FROM          myTable AS t1<br />
                            WHERE      (t1.idstudent = myTable.idstudent)) AS Years<br />
FROM         myTable<br />
WHERE     (idvalidat = 2) AND (idmodule = 11)<br />
GROUP BY idstudent<br />
HAVING      (COUNT(idstudent) = 2)

SELECT id_student,
       COUNT(*) as years
FROM   T1
WHERE (id_MODULE=11 )
AND   (id_validat= 2)
GROUP BY id_student
HAVING (COUNT(*) = 2)

obarahmeh wrote:

in both options it does not accept to create this replication because the source table has no primary key

obarahmeh wrote:

And so, I think I should choose either "Transactional publication" OR "Transactional publication with updatable subscriptions"

obarahmeh wrote:

But are you sure that this method (Transactional publication with updatable subscriptions) makes update conflict

obarahmeh wrote:

why SQL 2008 contains this method if there is a problems when we use it

obarahmeh wrote:

what is the ideal solution for making replication in SQL server 2008?