in queryanalyser run :

 restore headeronly FROM DISK = 'path\yourbackupfile.BAK'

I hope this helps.

from BOL :

Use sp_denylogin to explicitly prevent users from connecting with SQL Server, regardless of their Windows NT group memberships

With revoke you "drop" the user's login-id from the login's...

I don't know of any executionpriority you can set, but you can set deadlock-priority.

set deadlock_priority low -- I wish to be the victim in case of deadlock !

Guess what : I found this litle article ...

The waittype and lastwaittype columns in the sysprocesses table in SQL Server 2000

available at http://support.microsoft.com/default.aspx?scid=kb;en-us;822101

how about :

select ft.fno as DocGestao,

,round(sum(fi.ecusto*fi.qtt),2) as ValorGestao

,ml.adoc as DocCTB

-- ,(select (case when sum(edeb)=0 then sum(ecre) else sum(-edeb) end)

--   from ml ml1 (nolock)

--   inner join ft ft1 (nolock)...

Thanks for the reply, but the thread is over 1 year old

The sp-recompiles is what we've worked on, as well as ram-extention.

We've...

I think you only need this :

SELECT

 a.fieldname,

 a.Code,

 CASE a.fieldname

   WHEN 'Thing1' then  b.Thing1

   WHEN 'Thing2' then  b.Thing2

   WHEN 'Thing3' then  b.Thing3

   ELSE 0

 END As Description

FROM ATable a

left join  Thing1...

if you can handle the bit typework you might consider using the replace sql-function.

check BOL.

-- use select for POC-test

-- later alter to update-statement

select myalfanumber, replace(replace(upper(myalfanumber),'A','') ,'B',''),.... as mynumber

from mytable

where...

As you might have found out, there is litle info regarding sysprocesses available on the web. (many using it, but none describing it)

So I fallback to sybase :

You could also use sysprocesses for a quick ref.

This is a system-table, NOT to be modified/updated by anyone but the system !!

But you...

I guess your reboot-policy comes from an NT-4 era

We only reboot if fixes are planned and installed or if our production-plant has a...

I've used PSTAT.exe from the Wk2 resource kit to capture the data,

then transfered the intercepted output to a central place

, imported them into SQL and ran a filterquery to...

print screen on a stone plate ??

I've got 50+ servers to monitor.

Thé big thing with any RDBMS (sqlserver/oracle/db2/...)  is to work set-oriented. Once you get that in the fingers, things will work smoothly.

Maybe...

Let's hope your worktables are no #- or ##tables

These are only available within their own connection.