Hold the phone:

You have an XML String that you are storing

And you need to read it using the sp_xml_preparedocument procedure

not sure what the problems is here..

please post more of what...

I found my self not only laughing but thinking of people that fit each category.

We in the IT field (Programmers, DBAs, Admins) must forgive the mere mortals. They no not...

thank you for the reply.

nope.. sorry

I ment sp_sqlexec

Look in the Master database under stored procedures.. you will find sp_sqlexec

there is how ever a stored procedure sp_executesql

The difference?? Well sp_executesql is an extended stored procedure

sp_sqlexec...

did you try using sp_sqlexec ??

Try this

declare @r SMALLINT

,@sql VARCHAR(200)

SET @r = 60

SET @sql = 'kill ' + CAST(@r AS VARCHAR(5))

exec sp_sqlexec @sql

hope this helps

William O'Malley

There may be a better way but this is what I thought of

declare  @string varchar(500)

 ,@xmldoc varchar(1000)

 ,@xmlDocReturn int

 ,@returnString varchar(200)

-- create xml document

SET @string = 'have a nice day'

SET @string = REPLACE(@string, ' ','" /><item value="')

SET...

Well it's not all that easy to explain really..

Lets say that you have a Parent Component relationship setup. And the View or Select that you are using puts records in...

Yeah I ended having to put a test in there that I forgot to check and see how many entries there were.

Thanks for the feed back

I have a few questions:

1) Has the directory changed for the file from when it was working till now?

2) Do you have access to the directory?

3) Does the account that...

I have 2 questions:

1) can you show the code for the borrowed procedure that you are using?

2) Why don't you want to use SQL Server's xp_sendmail for this?

Edited by -...

often when talking to non-tech end user I will just try to explain maybe give an example and tell them I will look into it.

When talking to a fellow developer.....

I got one for ya.

When the same person asks the same questions over and over and over...

I just want to get Mid-Evil on em.. Grrrrr.

Ok.. I feel better now.

🙂

Will

Bump..

I have to agree. This is the best site by far for information when it comes to SQL Server

quote:

---

Good idea, please post it.

I'd prbably attack it by getting the ASCII code and incrementing that, rolling over on Z, but that's...

quote:

---

womalley,

This one is much faster and better. Can you manage to get something that scripts JOBS? I tried it with these but...