I don't like it, but a combination of a trigger and xp_cmdshell will probably help you get there.

Why do you need to do this?  (There may be another way.)

Your first solution looks fine to me, but this will find the character position of the (first occurrence of) space

declare @str varchar(50), @pos int

set @str = '4520-169 FEIRA'

set @pos =...

You need to ensure that SQL Server Agent is running under an account that has access to the network drive you are trying to access.  To check this, from Enterprise...

Dinesh - I probably will not know the answer to this question, but I'm sure that it will help others who do to work out what the problem is if...

A boxer, perhaps?

OK, good point.

Here's one that should work:

select t.transactionnumber

from tbl t

join (select t.transactionnumber from tbl t where t.itemid = 'mouse') t1

on t.transactionnumber = t1.transactionnumber

join (select t.transactionnumber from tbl t where t.itemid =...

Are there any Scheduled Tasks on the server that may be running these jobs?

There will be other guys on this forum who have better experience with this than I (I've never had anything like that many servers to look after), but one way...

Do you have network and admin access to all of the servers?

Maybe you could put your script into a stored procedure and have your job run that?

NULL is definitely a special case in SQL Server and cannot be treated as just another value (because it isn't).  I bet lots of people on here have been caught...

That's the way I would do it - here's some sample code - notice that I have put the connection string in a global variable for ease of use:

 Dim strConn

 Dim...

One way is to put a piece of ActiveX code as the first step in the DTS package.  Perform the IS NULL checks in this step and then:

 if (NULL condition) then

  main...

No need to use set.  Just use

oRS = DTSGlobalVariables("RSTables").Value

you're in VBScript land here - not SQL Server.

You will need to be a bit more specific before we can really help you.

Can you provide a bit more detail about why you need to do this?  What are...