I don't think that the problem is with ISNULL or COALESCE, but with the way the optimizer treats the data in the test table. At some point it decides that...

I don't have documentation on this topic, but I can only tell you that I experienced the same behavior when multiple log files are involved.

This shouldn't be an issue, anyway.

Regards

Gianluca

I don't know if this is your issue, but maybe you just need the plugin to manage the DTS packages in SSMS.

Download it from here:

http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlserver2005_dts.msi

Hope this helps

Gianluca

What's the command text for these processes? What's the host originating the process: the same as the SQL Server or a different machine?

jcrawf02 (6/5/2009)

---

Mark (6/5/2009)

---

More of a conjecture I...

Did you try LEN(REPLACE(@charstring, 'A', 'AA') ?

Does it perform better?

You're incredibly lucky: take a look at today's articles:

http://www.sqlservercentral.com/articles/SQL+Job/66421/

Jeff Moden (6/4/2009)

---

If you don't trust it, then use a cursor or write a CLR. But, many people have tried to make the "quirky" update go wrong and they...

If you can't have a VBS, then you need something able to connect to SQL server and issue queries. One thing that comes to my mind is sqlcmd or osql....

It's a bit difficult to understand what you want to achieve.

Are you working with reporting services?

.Net Application?

I suggest you take a look at this[/url] article and then come back...

You could write a .VBS Script to connect to the server and issue msdb.dbo.sp_start_job @job_name = 'yourjobname'.

Hope this helps

Gianluca

Your code runs perfectly, what's the matter with it?

If you want to run it only against a specifica DB, you could try to add the @db param, like this:

ALTER PROCEDURE...

Did you check if the TCP/IP protocol is enabled?

Does the output of NETSTAT show the TCP port configured in SQL Server Network Utility as LISTENING?

Jeff, has your avatar something in common with this?

http://www.youtube.com/watch?v=vF4iWIE77Ts

It's incredible I didn't notice it before!!

Did you try to log in to the sqlserver machine with the proxy account and run dtsrun directly from cmd prompt? It could also depend on env variables.