@fercasas, You are very welcome to do so, can you also comment with the blog address:-) for everyone to see and visit?

Hi,

the code is long because we deleting multi-files without checking their names,but just knowing the folder name and how old they are... and it will only delete SQL backup files(.bak,.trn)

the...

declare @Virtualname varchar(255)

declare @Virtual varchar(255)

create table #OSinfo(OSinfo varchar (255))

insert into #OSinfo

exec master..xp_cmdshell 'systeminfo'

set @Virtualname =(select ltrim(SUBSTRING(OSinfo,CHARINDEX(' ',OSinfo),LEN(OSinfo)))

from #OSinfo

where OSinfo like '%system%' and OSinfo like '%manufacture%')

if (@Virtualname not like...

well the error reads as follows, this was working a day before

OLE DB provider "MSDAORA" for linked server "CDIHWHPROD2_EIW" returned message "ORA-12154: TNS:could not resolve the connect identifier specified

".

Msg 7303,...

Hi

Does this by any means temp with the oracle drivers?

I installed this for my clients and right after they complained about oracle drivers (haven't looked the error message yet), although...

Hi

I suggest you backup your log file and shrink it (although this is not recommended on SQL best practices but i believe its the best solution at the moment)