Viewing 9 posts - 1 through 9 (of 9 total)
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...
May 26, 2009 at 9:01 am
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...
May 26, 2009 at 8:39 am
Never mind, I got it. Thanks! a lot for your help.
September 23, 2008 at 1:28 pm
Hi Jason,
Thanks! a lot it worked I used this way and it worked
;WITH XMLNAMESPACES (
DEFAULT 'http://www.tempuri.org/SearchCriteriaDS.xsd',
...
September 23, 2008 at 12:52 pm
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.
...
September 23, 2008 at 11:57 am
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 =...
September 23, 2008 at 10:19 am
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...
September 23, 2008 at 9:56 am
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...
September 23, 2008 at 9:09 am
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"...
September 23, 2008 at 8:33 am
Viewing 9 posts - 1 through 9 (of 9 total)