Jeff - Response from select @@version:

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790:...

Thanks Peter, your script worked perfectly.

thanks, but your query did'nt work...i got this from someone and it worked

select ServerName, Alert, alertdate from dbo.TNG_Alerts

where  AlertDate >  (select getdate()-@day)

order by ServerName,alertdate

the data must be greater than yesterday's date, sorry  forgot to include, you have to enter a parameter.

usp__RptTNGAlerts '1'

The parameter entered would bring back data greater than yesterday's date,...

Thanks but I found this:

Select   servername,LEFT (alert, CHARINDEX(' on ', alert) ) as Alert,

LTRIM(RIGHT(alert, CHARINDEX(' on ', REVERSE(Alert)) + 20)) as AlertDate

from tempTNG_Alerts

Thanks for the info but I have never used scalar UDF 's before.

Can anyone assist me with this one.

I don't have any control of the source application, and I also tried to substring but it won't work because the ServerName are not all 8 characters long.

Thanks for the info Sugesh.

Another problem: the spec has changed, I no longer have to separate the columns when I take it to the table. The...

I'm not sure....i asked the SA the same question and he is not aware of backup software running during this time....usually when a drive is backed up, the backup job would...

Mark...I did add the user to the database and gave him db_owner rights to the databases he wanted to access. But it still gave the error.

All that you mentioned above was done before....I am looking for a different solution to this problem.

No, the drive is not a  networked drive.  All backups are locally.

Hi there,

the total size column of the table, is it in KB? 

thanks for the info, it was a lot of help.

I also got this script from one of my colleagues:

select

* from...

We have assigned db_owner rights to a user and it seems as if those rights are not being taken over. I far as the error messages are concerned, I would'nt...