Hi,

Considering just performance, put your logs on the fastest disks you can.

The performance of the transaction log is probably the single biggest contributor to overall performance so ideally you want...

Hi Glenn,

In your script you're checking for spid 1, which is background spid. All spids lower than 50 are background spids.

To get it to work try looking for an...

Hi Carl,

In that case I think you can get away with just check the sysjobservers table.

You want to check that the last_run_outcome is 1 (ignore BOL in this case, it's...

I guess you'll have to decide on a value for @minPrice and @maxPrice in the case that they are null.

something like:

isnull(CAST(@priceMin AS varchar(4)),0) --uses 0 if @priceMin is null

If 0...

Andrew,

have you tried updating the record using an update statement?

Try something like this:

update

set JobType = 'Variations 1'

where ContractJobTypeId = 6186

I can't be sure I've used the right columns as...

Ok,

I see what the problem is.

Put this statement at the top of your procedure:

set concat_null_yields_null off

When you cast @maxPrice (or @minPrice), if @maxPrice is null you'll end up with a...

Hi Johann,

I'm assuming that you're running sp_executesql @SQLCmd or exec(@SQLCmd) somewhere inside the proc.

Unfortunately only you can tell what's going wrong with the query as you have access to the...

Hi Carl,

I'm not sure what you're trying to do but why can't you use the job's very own success/failure flow logic? Or are you trying to interrogate a job's...

Hi Johann,

The problem is because you are casting @priceMin and @priceMax as varchar(4) but the value 10000 is 5 characters long so you would need to cast it to varchar(5).

That...

I don't suppose that consideration would be given to international candidates.

p.s. You'd be hard pressed to find a better foosball player (I mean DBA)

The service account that a job is running under depends on who owns the job. If owner of the job is a sysadmin account then it is the service...

Thanks for the follow up Greg and I'm glad you've come to a position of at least understanding what's going on - despite a few splinters

Ken,

In terms of migrating your data from a 32 bit SQL Server to a 64 bit SQL Server there shouldn't be anything to worry about. Just treat it like...

Dominic,

Unfortunately that is not possible. In this kind of situation, where you need to manipulate the resultset returned from an sp using T-SQL, the best approach is to manipulate...

Greg,

to check ansi_padding setting use the databasepropertyex function. ansi_padding is set at the database level. I suspect that it must already be on because I'm pretty sure that...