"tell me why I don't like Mondays"

check out : Moving SQL Server databases to a new location with Detach/Attach

(http://support.microsoft.com/default.aspx?scid=kb;en-us;224071)

if I'm correct, after you changed your systemdate, sqlagent will change the "next rundate/time" to 27/05/2005 12:00AM. So the only thing it does is check wether it has the correct...

Do I really need to wait 4 hours until I can start differential backup? Yes

Do I need to check error code (probably, yes, and how to do this) after full...

Keep in mind some of them are created by implementing a constraint and need to be removed by drop constraint.

Here 's a little testcase to show how you can do...

yep

Check sqlagent master-server

I cannot test it right now, but if i remember correct, it would for...

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 :