Since you can't concatenate the arguments in sp_add_job use this (it declares variables for each of your concatenated properties and uses the variables as the arguments):

DECLARE...

I agree with MarkusB that either the user login doesn't exist in the SQL server or the Password is incorrect.

Your posting contains secure information that you should never post on a...

I'm not familiar with ColdFusion so I can't help you with the code needed to process the failure but, to make a package fail on error you need to modify...

The error tells you that a connection with your SQL Server could not be established, this could be because the credentials supplied (Hostname, port, instance name etc) are not valid,...

I recently responded to a similar need and this worked for them.  See if this concept applies for you... Transforming table rows to columns

Basically you're looking...

here is a sample connection that I use with VB.  Set the connection timeout to 30 (lower values still take 30 seconds, part of the MDAC I assume)

Dim oConn As...

Execute the connection method / function of your remote program...  (I am making the assumption that you are the programer), set your connection timeout low, if the connection succeeds then the...

I don't know of a function to give you what you are looking for that already exists in SQL Server (not that it doen't exist, i just don't know about...

I'm not aware of any performance gains regarding the database that a procedure is stored in (not there isn't I just don't know of any).

There is no reason to create...

You can use the function I wrote to parse the name (get it here: UDF: Parse a delimited list of paramters )

Then your statement should look like this:

select (select...

it's the extra And "+ ''' AND and [Platform] = ''PDA''' "

change it to + ''' and [Platform] = ''PDA'''

also is PDA always the filter if not do this:

CREATE...

There appears to be problem with the actual data stored in the variable @date.  I ran the below statement and it works just fine...

Can you post the results of "Select...

Andy,

Don't be sorry, this is what makes forums great.  A user posts a question hoping to get the answer to solve some major problem he/she is having.  Other users post...

Try this:

-----------------------------------------------------

--      GET TABLE COLUMN NAMES FOR INSERT         --

-----------------------------------------------------

DECLARE @tblColumnString TABLE(iRowId INT IDENTITY(1,1),vcColumnName VARCHAR(255))

DECLARE @i INT

DECLARE @iFirstColumn INT

DECLARE @vcColumnString VARCHAR(8000)

DECLARE @vcColumnName VARCHAR(255)

DECLARE @vcExecSQL VARCHAR(8000)

INSERT INTO @tblColumnString Select name from...

You're looking for a Pivot function...  for SQL 2000 there are alot of posts here, do a search for Pivot script on this site... same for SQL 2005 which has...