Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Delete old backup

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

  • RE: Delete old backup

    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...

  • RE: how to find a Server .. IS Physical machine or Virtual Machine

    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...

  • RE: Excel Source File

    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,...

  • RE: Excel Source File

    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...

  • RE: Transaction Log file size issue

    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)

Viewing 6 posts - 1 through 6 (of 6 total)