Hi Marcus,

We are actually migrating this database from sql2000 to sql2005 it works fine in sql2000. A non-sa non-sysadmin sql account can execute this external store procedure...

Hi Marcus,

Thanks! for the reply, sorry I should have been more clear. I see that it has execute permissions on public and I also gave exclusive...

Never mind, I got it. Thanks! a lot for your help.

Hi Jason,

Thanks! a lot it worked I used this way and it worked

;WITH XMLNAMESPACES (

DEFAULT 'http://www.tempuri.org/SearchCriteriaDS.xsd',

...

Hi Jacob,

The table "tblintsearches" has 70k records, this report should run against all these records and I dont have any write access to this table.

...

I have changed my sql this way

select x2.value('@d2p1:Name[1]','VARCHAR(25)') AS email,

x3.value('@d2p1:From[1]','VARCHAR(25)') AS FromDate

from (select cast(xmltext as xml) as col

from tblintsearches

where caseid =...

Hi Jacob,

How do I modify this sql statement to get the result?

select col.d2p1.value('.','nvarchar(max)')

from (select cast(xmltext as xml) as col

from tblintsearches

where caseid = 72

and...

Hi Jacob,

Thanks! for the reply. I dont have control over the XML document not even sure how it gets loaded into the column, I was...

Sorry about that I didnt realize that it didnt post the xml string. I have replaced all " " tags with "[","]".

[SearchCriteriaDS xmlns="http://www.teuri.org/SearchCriteriaDS.xsd"]

[SearchCriterias d2p1:Name="abc@abc.gov-emails" d2p1:SearchTemplateID="-1" d2p1:OnlyNew="true" d2p1:SourceTargetDirection="3" d2p1:SampleSize="100"...