Two things you have to look out for when you run a package from a SQL Server Agent job:

(1) Interactive components. Things like pop-up messages or user applications will...

Do it like I showed you. Change the ORDER BY to DESC instead of ASC,...

Something like this?

WITH Tenancies AS (

SELECTLOC.[place-ref] AS 'Place Ref'

,PLA.address1 AS 'Address1'

,PLA.address2 AS 'Address2'

,PLA.address3 AS 'Address3'

,PLA.address4 AS 'Address4'

,PLA.address5 AS 'Address5'

,PLA.[post-code] AS 'Postcode'

,LOC.[location-sts] AS 'Location Status'

,LOC.[location-type] AS 'Location Type'

,LOC.scheme AS 'Scheme'

,LOC.[mgt-area] AS...

Have you tried using the Upgrade Advisor?

John

An alternative worth considering, since you have a primary key constraint, is to skip the existence check, and instead to handle the error when it occurs.

John

Surely you just want to do this?

UPDATE sy01200

SET INET5 = LEFT(convert(varchar(40),EmailToAddress),LEN(convert(varchar(40),EmailToAddress))-14)

WHERE Master_Type = 'EMP'

John

If you can split it, just order the results by NEW_ID() and reconcatenate.

John

Actually, I'm puzzled. Since the value of @nKeyWord_IdArg isn't set anywhere, I'd expect it to be NULL and therefore no deletion should be attempted. Unless ANSI_NULLS is set...

I think it's this in your stored procedure:

DELETEdbo.Keywords

WHERE@nKeyWord_IdArg = @nKeyWord_IdArg

That's going to delete the whole table (unless @nKeyWord_IdArg is null).

John

MVDBA (6/26/2014)

how is this different from a unique...

Should I append my t log backups or write each t log file to its on file? Of course this will make restoring harder as I will have to restore...

OK, you need to start SQL Server in a simple configuration so that it doesn't load model and msdb, then restore model. There should be plenty of resources out...

Is SQL Server running? What happens if you try to start it?

John

That's how it works. If your job is still running at its next scheduled time, it won't run again until the next scheduled time after that (unless, of course,...

Grant's link doesn't work (for me, anyway), so I'll attempt to answer your questions briefly (although you probably could answer them yourself with a bit of search engine magic).

First, no,...