You are right, you cant take the database from 2012 to 2005 as it will not reattach or restore.

Two options I can think of off the top of my head...

DECLARE @a SMALLINT

SELECT @a = cpu_count FROM sys.dm_os_sys_info

IF @a = 1

BEGIN

EXEC sp_configure 'min server memory (MB)',xxxxx

EXEC sp_configure 'max server memory (MB)',xxxxx

...

Somewhere up the north of England, Manchester prefered, London was just to tricky to get to this time around.

Jason-299789 (11/9/2012)

---

Anthony's solution should work, or you could simply alias the converted field and reference that in the Order By

Eg.

SELECT distinct

pd.description

, convert(varchar(10),convert(datetime, pe.enc_timestamp, 103),103) enc_timestamp

, pd.icd9cm_code_id

, dsm.description

, pd.note

...

Does the following work for you?

SELECT

Desc1,

convert(varchar(10),convert(datetime, enc_timestamp, 103),103) as EncTimestamp,

icd9cm_code_id,

Desc2,

note

FROM

(

SELECT

DISTINCT

pd.description Desc1,

pe.enc_timestamp,

pd.icd9cm_code_id,

dsm.description Desc2,

pd.note

FROM

ngkbm_dxcode_to_category_ ndc

join

patient_diagnosis pd

ON

pd.icd9cm_code_id = ndc.txt_icd9cm_code_id

left join

ngkbm_categry_to_specialty_...

Its picking up the column alias instead of the actual column as the sorting object.

Add the pe. alias to the order by or change the column alias in the select...

+1

As your ordering by a VARCHAR, it orders it from left to right not by value as that is...

What post-migration steps have you carried out on the new server?

I am guessing you backed up and restored the 2005 database onto the 2008 server?

Did you run DBCC UPDATEUSAGE, rebuild...

Sorry forgot to add this one in on the definition of a table variable

http://msdn.microsoft.com/en-us/library/ms188927.aspx

COLLATE section

If not specified, the column is assigned either the collation of the user-defined data...

What are you classing as a CPU, a physical socket or a logical core?

You would have to create your own sort of logshipping which restores the logs with the continue_after_error clause, standard log shipping wants the DB to be consistant, so you if...

Connect - SSRS Blocking

http://support.microsoft.com/kb/305977/en-gb

To get the physical number of CPU's in a box

SELECT

cpu_count / hyperthread_ratio AS PhysicalCPUs

FROM

sys.dm_os_sys_info

To get the number of logical CPU's in a...

You can give it the SSIS job step, as all it does is execute dtsexec behind the scenes it doesnt have any dependency on the SSIS service.