I love you man, works,  Thanks alor

THANK YOU THANK YOU THANK YOU... that works...appreciated...thanks again

not sure what you're saying...

Let me try to explain it again.

I have a field called dat_Submitted_on and that field is Integer 4 and the data in there is 1137699938 represent...

it's not working, it come from other application and the data type is int 4

I found it, my mistake, I apologize for that, this is a view combination of others 2 tables on the system

thanks for your help

It's not a new table, I did refresh the Enterprise Manager and nothing.

and

I cannot see the table in query Analyzer Object browser, but again if I run any query from...

thanks, it works

now I need to do this somehow

select @date = select creation date from  (EXEC master.dbo.xp_getfiledetails '\\atlaback\D$\sql_backup\LPUSAS-WINDIAG\WINDIAG2\*.BAK')

this statment it's not working, any ideas?

thanks again

As far I know the delete old files setup on database maintenance plan never works because a bug that shoudl be fixed but I don't know when, base on that...

You're right, was the sql agent permissions to access that drive

thanks

good question, I don't know, I will check this out and get back to you...thanks