for some running totals, something i had open today

SELECT PerfCat,

RLA,

M,

...

i execute this against my central management servers:

EXEC sys.sp_MSforeachdb '

IF (SELECT owner_sid FROM sys.databases WHERE name = ''?'') <> 1

ALTER AUTHORIZATION ON DATABASE::? TO [SA]

'

version says

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1...

thanks for the super quick replies

yes, we are going to look away from the dmv for now

kind of scary though if you don't feel like you can trust one...

i've been...

yes 2008R2 SP1

when i select @@ version or

use sys dm_os_sys_info for the virual_machine_type

i get one result telling me the server is virtual

but if i run systeminfo at command prompt or...

what happens if you run query in management studio?

CHAR() only accepts integer value. what if you drop it entirely

SELECT SUBSTRING(LONG_NAME,0,80) AS LONG_NAME

Are you using 2005?

You need to run the job in 32 bit. For job step, use

Type: Operating system (CmdExec)

Command: C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe /FILE "my_file_location" /MAXCONCURRENT " -1...

yes! this does work, and strangely makes me feel more at peace with the world. thank you.

I haven't gotten into all the existing jobs yet, but have a bunch with

last_run_outcome = 5

last_outcome_message = NULL

last_run_date = 0

and was tinkering with code...

I also had to exclude 5 (unknown) from last_run_outcome in usp_getFailedJob. Had a bunch of 0's in the last_run_date in this case and broke the convert.

I have an hour long commute, so I read.