BIDS stands for BI-dev studio.

With sql2000 you need to be granted exec of the debug procs.

http://support.microsoft.com/default.aspx/kb/817178

http://support.microsoft.com/kb/280101/

prefer coalesce.

Not only because it is ansi, but also because it can do more for you.

isnull(thecol, thereplacement)

coalesce(thecol,thefirstreplacement, usethisifthefirstreplacementisNULL,...)

and I've had some issues with sql2000 when using isnull is certain...

With sql2005 the (sqlproc) debugging stuff has been shifted towards BI-dev studio.

This feature is NOT available if you only install the BIDS version MS ships with SQL2005.

Open BIDS

open the server...

grant VIEW SERVER STATE to xyz ;

Check "GRANT Server Permissions " in BOL.

This is SQL2005 Right ?

Have a look at the rank functions that can be embedded in the sqlstatement.

Then you would only have the e.g.

Select *

from (

SELECT Rank() OVER (PARTITION...

Jeff Moden (4/21/2008)

No, no... it DOES work correctly. The examples can all be converted to some form of numeric data type including the ones I just showed which are...

Jeff Moden (4/18/2008)

I agree... even with a CTE, I'll try to return as few rows and...

Indeed, I forgot about the currency signs. :crying:

Thank you for providing the faulty example.

They'd better remove ISNUMERIC...

Indeed, you'll need to add the index yourself.

This script can help:

http://www.sqlservercentral.com/scripts/Indexing/61391/

how about adding a "calculated" column wich contains the actual sort-value.

This way it will take some space, but you can index the column and you don't have to figure it...

When implementing "remote foreign keys" keep in mind that if the other instance/db is down (or in maintenance), your instance will suffer as well !

Maybe you'll be better off replicating...

- with sql2005 you can only see the data you are entitled to.

- you need to grant 'view system state' to see it all.

Do you realy...

- keep in mind "hostname" is data the client needs to provide.

- with e.g. access, when creating a linked table, it keeps the hostname data that has been provided by...

- I think you've posted in the wrong forum (sql2005 backup)

- what kind of isolation level are your applications using.

avoid repeateble read as much as you can.

sp_blocker_80 shows the...

- did you try just adding the correct date to both columns ?

- and then just query

datediff(MINUTE , startdate, enddate) as elapsttime_Minutes