Michael Valentine Jones (9/23/2009)

---

If the table is big, and you need good performance on...

csalazar-607991 (9/23/2009)

---

--Consulta

DECLARE @Consulta VARCHAR(MAX)

--Ruta del documento

DECLARE @Ruta VARCHAR(MAX)

--Ruta del documento

SET @Ruta = 'C:\BKP\ImagenesBackup_' + CONVERT(VARCHAR(11),@Fecha) + '_.xml'

--Consulta

SET @Consulta = 'EXEC xp_cmdshell ''bcp "SELECT CodigoCaso,CONVERT(XML,REPLACE(REPLACE(REPLACE(CAST(Imagenes AS VARCHAR(MAX)), CHAR(9),''''''''), CHAR(10),''''''''), CHAR(13),...

I know this can work.. Also, yo might set DelayValidation to True for the package so that it re-validates at run-time instead of now..

CEWII

In reference to the compiled 30 times point..

I rarely compile the sproc without there being other than whitespace changes. I really like explicitly saying "this is the version I...

I'm really surprised by that, I have code that does exactly that and I have received the failure mail..

CEWII

My experience suggests it usually will, it will even abort the cmd.exe that called it.. There are very few cases it won't and all of them are execute process...

tiffanyjanetblack (9/23/2009)

---

yes, it appears I will have to manually change that ini file for deployment to each instance

on the SQLDEV box.

However, I am not sure that will solve my...

What is the command you are executing?

You could create a view that assembles the fields either Jack's way or Michaels's way..

CEWII

Silverfox (9/23/2009)

---

You...

Unfortunately for you that all sounds about right.. If they can grant access then there is nothing to prevent them from granting access to themselves, therefore by default they...

Have you looked at a return value..

DECLARE @retval int

EXEC @retval = master.dbo.xp_sendmail ........

SELECT retval = @retval

CEWII

Well, I don't want to give him a big head.. But he has a good saying for this topic..

CEWII

I think Jeff Moden says it best..

Stop thinking ROW, start thinking COLUMN..

CEWII

Well what part isn't clear?

You can't use the easy way in Agent to run it, but you can use that to get most of the command line.

You need to find...