I figured out.

first I did an insert on the ones that met the (not exists) parameter

then did my select query

Nevertheless, thanks for your input.

XC

I tried creating a UDF but it does not allow me to use an INSERT statement.

CREATE FUNCTION udf_GetEvaluationIdByProjectId(@project_id int) 

RETURNS int

AS 

BEGIN

 Declare @count int

 Declare @id int

 Select @count = Count(id)...

The other account did have permissions, I just didn't want to log as the admin of the machine. 

Is there any tools I can use to test my security?  I...

Thanks!  That worked. 

I have tried that but when I try to start the service again I get the following error message.

Error 5: Access denied to start the MSSQLSERVER service