No worries, took me a while to find it as well:)

You can expand the box below the Post Options box to see the last ten posts while replying

another way..

WITH TableOrdered as

(SELECT Col1, Col2 , ROW_NUMBER() OVER (ORDER BY Col1) AS TheOrder

FROM YourTable)

select Col1,Col2 from TableOrdered

where theorder = 2

Is SQL Browser Running?

have you enabled the databse to allow remote connections?

Can you post up the query and table defs ? then you should get some help..

Yes you can use the Shrink File task in SMSS,

Create a script from this if you want to know what has been run.

It is only meant for one user, but you can buy additional licenses for as many users that you need for Dev, Test and Demo.

are you able to ping the server?

No worries,

you could use the Left and Right functions.

I am not aware of any performance difference between the two and couldn't find anything aobut it on BOL.

SELECT cast(substring(CAST(yrqtr AS VARCHAR(6)),1,4) as int) as yr,

cast(substring(CAST(yrqtr AS VARCHAR(6)),5,2) as int) as qtr

from DwEnterprise.TimelyDischarge_Rpt

SELECT substring(CAST(yrqtr AS VARCHAR(6)),1,4) as yr,

substring(CAST(yrqtr AS VARCHAR(6)),5,2) as qtr

from DwEnterprise.TimelyDischarge_Rpt

go to Surface Area Configuration Manager under SQL tools on the server

Click on the db and remote connections,

click on the radio button for Local and Reomte Connections.

Also ensure...

Can you ping the server?

have you enabled remote connections on the sql 2005 server?

Either turn on casade deletes so that the foreign key refernce row is deleted as well, or delete the foreign row first.

This needs to be done with cautioin...