I'd agree 100% with this, we had the exact same problem and resolved it by rescheduling the second backup to a time after the first one had finished

Declare

 @RCPT VARCHAR(500),

 @MSG VARCHAR(400), @SBJCT VARCHAR(100)

select @SBJCT = '! LOW FREE DISK SPACE ON ' + @@Servername

DECLARE @EMAIL VARCHAR(600)

SET @EMAIL = 'EXEC master.dbo.xp_sendmail

    @recipients = ''' + @RCPT + ''',

    @message =...

It sounds to me as if the del command is waiting for a response from your batch.

It depends on whether the dba had set it so only sysadmin role members could use it.

lol

Don't forget, you can use the select top 100 percent trick in a subquery to allow you to do the orderby in a view.

create view test

as

select * from (select...

I'm fairly sure that I saw that this had been fixed in SP4

Yep, that's already a feature of QA.

Just click on the drop down box next to the execution mode (where you say whether the results should be in text or a...

A very interesting topic all round, especially for me as it's what I'm currently trying to look at doing on our system.

As they say 'Every little helps' and I for...

Hi Alex,

Fortunately it's not all doom and gloom, I've been sucessfully working with Clusters for the last few years and whilst I agree that it needs a fair amount...

You'll need to map the old logins to ones on the new server (and if you want to keep the same ones make sure that the SQL logins exist first).

Have...

I can't say for definate but I've fairly sure that I've read an article recently saying you should change the account via Enterprise manager (I think it was related to...

First star wars quote found I did 

How simple is the select statement and are there indexes available to support it (especially on the columns used in the where clause or in joins)

Putting the statement in an...

I'd agree, we had a similar issue once and it was entirely due to network issues (the router was set at 100MB/s (it was a while ago) and the NIC...