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

well ... maybe the are ...

try to add an "order by 1,2,3 " at the sqlserver side as wel as at the access side.

Maybe then you'll see the data is...

- is that database configured "autoclose on" ?

- if yes, it needs a restore-step to be opened again.

(keep in mind SSMS doesn't autorefresh the object-browser pane)

- is your sqlserver "member" object a view or a table ?

If it is a view, can you post the ddl ?

-Are you using a linked table to...