Lynn,

I dont know what you have installed on your computer. :w00t:

Can you give me a clue as to what format will work ?

I am using Config Mgr 🙁

I have attached a screen shot.

Error - Only one uage of each socket address (protocol, network, address, port) is permitted.

0x80072740

Paul,

What other information do you need?

Thanks

Thanks

I reset the domain\administrator password within active directory.

The weird part is that if i create a new domain\generic userid with administrator access, it works fine.

Thanks

http://msdn.microsoft.com/en-us/library/ms365941.aspx

Ok i tried the above link and now get an Access Denied error - 0x80070005

The MS error msg refers to Windows server 2003 but i am on 2008 and this...

That worked, thanks!

In the stored procedure, when i have a single parameter passed to the CONTAINS statement it works. When i have multiple parameters passed, i dont get any results....

Do you mean like this ?

declare @skill1 nvarchar(20)

declare @skill2 nvarchar(20)

declare @skill3 nvarchar(20)

declare @skill4 nvarchar(20)

declare @email nvarchar(1000)

select @skill1 = 'livelink'

select @skill2 = 'sharepoint'

select @skill3 = 'java'

select @skill4 = 'j2ee'

exec usp_getEmails @skill1,...

I tried the following code without errors, but it takes forever 🙁

Thanks

declare @skills varchar (100);

set @skills='"c#" and "livelink"';

SELECT DISTINCT Email

FROM (SELECT Email1,Email2,Email3,Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

where (contains (originalresume,...

I was just in the process of extracting all 🙂

Thanks for everyone's help !

I keep getting a setup error for some reason ?

I have attached a copy of the error.

Thanks

I made some assumptions.

As each record is written to the DB, the primary key increases by one.

I assumed that the emails with the highest key, among the duplicate fields would...

I found the issue. It was NOT the delete SQL code !

Thanks

select distinct email1

from outputresume3

where (contains (originalresume, '"livelink"

and "java"

and "cobol"

and "j2ee"

and "asp"

and "sql"

and "unix"

...