Who/what starts the job? sql agent?

You're welcome

I've gotten those duplicates too.

In this case it was a emergency recovery and the indexes were partially corrupted.

Solved by dropping all indexes, running a DBCC CHECKTABLE, removing the duplicates (in my...

what kind of field is PersonId? char, varchar, int?

Are you checking the right table? (have you specified an owner like dbo)

Surely possible with a cursor.

Will think about a set based solution.

Does sqlagent has sysadmin rights?

Allows a member of the sysadmin fixed server role or db_owner fixed database role to impersonate another user.

<IMG style="MARGIN-LEFT: 0em" height=11 alt="" src="mk:@MSITStore

sp_grantdbaccess grants access to a database

Use sp_grantlogin to reverse the effects of a previous sp_denylogin that has been executed for a Windows NT user.

Use sp_addlogin to allow a SQL Server...

Work Table? You mean a table to dump all your information in for further processing?

With which tool you see <binary> (EM?)

I see the different values with query analyzer.

Since sa is a systemadministrator, they have full access (no permission checking).

If normal accounts are used you can make views

CREATE VIEW ABC AS

SELECT ... FROM ...

WHERE entry.USER_ID= SUSER_SID

WITH...

SCHEMABINDING:

Binds the view to the schema. When SCHEMABINDING is specified, the select_statement must include the two-part names (owner.object) of tables, views, or user-defined functions referenced.

Views or tables...

Any scheduled jobs?

If you know it happens every hour, you could set up a trace for it in sql profiler.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp

lngResult = SQLConfigDataSource(0, _

                                           ODBC_ADD_SYS_DSN, _

                                           "SQL Server", _

                                           "DSN=" & JDS_DSN_name & Chr(0) & _

                                           "Server=" & JDS_Server_name & Chr(0) & _

                                           "Database=SvCvMarketing" & Chr(0) & _

                                           "UseProcForPrepare=Yes"...

there is a setting ANSI_NULLS ON/OFF

ANSI_NULLS ON -> left join (NULL=NULL) =false

ANSI_NULLS OFF -> left join (NULL=NULL) =TRUE

RTRIM('ABCD ') strips off trailing whitespace