Not tested completely, but this type of query can be written not to use a temp table or cursor

example below

DECLARE @spid SMALLINT

-- Set desired SPID. If NULL, it will return...

Hi Gail,

I see both our solutions generate the same plan with those five records.

(SQL build 9.0.4053)

As Dave mentioned now you have an order, it can be coded.

I've rewritten my example using your example, plus added a variable for record you want first.

set nocount on

declare @firstpos...

You will need to order the data by something. In this example I created a unique id using the row_number function by ordering on column b.

-- Setup test table &...

Yes, and this will become even more so with 2008r2, which I beleive will run on a core o/s install

hence no local GUI.

Profile the sql server using the 'sql profiler' tool, and that will show you what t-sql is currently running on the server. It may be best to add the hostname...

If you are UK based, you could always go to the free community day in November in Newport, Wales

(http://www.sqlbits.com/)

In the short term you can also use the sql profiler to capture failed logon attempts (remember to add in the hostname field).

Also you can use the server side tracing...

I'd ask questions and read up!

What happens to performance if you extend LUNS? etc.

Colin has some good SAN/DB articles at the following URL

http://sqlblogcasts.com/blogs/grumpyolddba/archive/tags/SAN/default.aspx

Sorry it was a few years ago since I linked to exchange, but I did keep a few bits of code (below) which may help.

-- adding a linked server

   EXEC...

You can create a linked server to exchange 2003 using the active directory provider, add the linked server security. Then you can query the exchange server.

The easiest way is to copy multiple packages is to use another DTS package to copy the packages.

See http://www.sqldts.com/204.aspx for more details

Here new development is primarily on SQL2005.

The first challenge is to decide what components to install, and what surface area configuration settings to use e.g DAC. Functionality hangs together eg If you...

http://www.sqlsecurity.com has a hotfix database where you will see the pss hotfixes listed (3 so far)

Also you can search the microsoft web site for kbsql2005presp1fix to find fixes which...

Again option #1, but it would have been nice to see an orange cube (the same shade as the '2005 Ready to launch' items)