In case you missed that message?!?!

I'd really like to have those answers.

Can you print the @string command and post it here?

What error are you getting when executing?

Can we know the rest of the process?  I'm not sure you are using the right tool for the job.

Have you tried with '1' instead of 1?

Also check the execution plan for implicit_conversion which would confirm vladan's theory.

And run the job every 2 minutes at least so that at most there is a 6m59s delay before the queuing and execution.

Dev server??

DBCC FREEPROCCACHE

Now you can search these forums for parameter sniffing to get more info on that topic.

I wouldn't expect any problems with that approach (without fully knowing your system).

Now to conclude... You only backup daily (I do too but with trans backups every 30 minutes >> we...

I don't see why this would be a problem (aside from creating a bug in the web application).

The real problem here is why do you backup only once a month?!?!?!

Can...

Sorry but I don't know the answer to that one... I guess we'll know at the same time.

But if I were you I'd keep reading those articles... they'll come in...

NOT NULLS means that the column is not nullable.  If there already is data in the table and you need to add a non nullable column, then you have to...

ALTER TABLE dbo.TableName

ADD ColName INT NOT NULL /*optional from here*/ CONSTRAINT DF_TableName_Init DEFAULT (0)

You got a little bit of reading ahead but it's really worth it, for everyone involved.

http://www.aspfaq.com/etiquette.asp?id=5006

http://www.sqlservercentral.com/columnists/siyer/2645.asp

We can't answer this type of question without having the tables ddl (with indexes and keys) along with the query and execution plan.  ONce you provide that we'll most likely...

Add an sql step at the end of the first job and type in this line :

exec msdb.sp_start_job @job_name = 'jobname'

That will start the 2nd job.

Now that would be an interesting test...  Count the recompiles of each execution plans.

Anyone got time to set this one up?