Hi here is the solution for the Delete:

CREATE TRIGGER [dbo].[tr_Currency_Del]

ON [dbo].[Currency]

FOR Delete

AS

Email code here

Go

Thanks for you help John.

I finally got a query that the time is right (I know this because there was a wait for delay for 1 minute in...

Hi John,

This below is the conversion from Milliseconds to Seconds.

Do you know what the conversion should look like for Microseconds to Seconds?

The research that I got from a Microsoft site...

Thanks for the reply John.

I checked the duration, the problem is there is NULL & 0 values in the results and it is in microseconds format. That is why I...

Well, if anyone should ever need this...

Use a cursor to check the query run time...

DECLARE @SPID int

DECLARE c1 CURSOR READ_ONLY

FOR

SELECT SPID

FROM TraceResultsLongRunningQueries

OPEN c1

FETCH NEXT FROM c1

INTO @SPID

WHILE @@FETCH_STATUS = 0

BEGIN

SELECT...

.

Hi There,

I have a similar problem.

I am using SQL 2000 and I am backing up to a UNC path.

I am using this code below:

USE [master]

DECLARE @DBNAME VARCHAR(20)

DECLARE @sql...

Thanks rokuba,

Enabled the username in AD who installed the instance and connected with the Windows Auth and found that the user was a sysadmin member 🙂 Now I have sysadmin...

Hi Guys,

The script worked on a instance where I had Sysadmin rights to the DB.

But there is another server that was installed by the previous DBA with no documentation and...

Thanks, all is now back into 1 job with a waitfor delay in the beginning of the second step and it is working fine!

Thanks again!

Thank you for your help! :hehe: Now it is looking very good 😉

USE msdb;

GO

Alter VIEW dba_JobHistory

AS

WITH JobHistory AS (

SELECT CAST(J.name AS VARCHAR(50))...

Hi Gianluca,

Thank you for the help.

It really helps and give a good result set.

I did modify the code a bit. Do you have any other suggestions to move the header...

Thank you, I am busy doing a transactional backup.

I only have a HDD space issue at this stage.

Hopefully everything will be sorted out now.