Thank you so much.

I won't leave it like that. Will definetly see wot's wrong with that database. (backup is not properly happening, can't detatch..). I will revert back with...

I will get those details at the earliest. Thank you.

(MDF and LDF are still there..but LDF is huge..can't import)

For time being whot I have done is, I EXPORTed all the...

The problem was that I was not able to take backup properly.

Backup size was shown as 80MB even though the actual size was 2.6GB (It dint give any error while...

Thanks a lot, It's done successfully.

Hi,

That's how we do the upload now..But it gives problem every now then. Gets timed out...sometimes it takes hell lot of time...

Otherwise it's very easy...only a few...

Hi Chris,

Thanks a lot of such a detailed reply. I was waiting till evening (indian time) for reply from someone, but in vein. So I again opened my...

Thanks a lot...It's working...

Hi,

I am able to see the SQL Server Agent and JOBs folder. But am not seeing any of the JOB in jobs folder..That's the problem.

Thanks,

Santhu.

Can you explain a bit more in detail (Auditing).

So that I will take all the precautions and

have some clue atleast henceforth.

Thanks..

Santhosh.

Resotring from the proper location.....

Hi,

Excellant....Done. It's working now. Thank you somuch..

Thanks,

Santhosh

hi,

I did it using a dynamic sql.

create table #dplCodes (dplCode Varchar(21))

--------------------------------------------------------------

DECLARE @STR nVARCHAR(1000)

SET @STR = 'SELECTITEM_CODE'

declare curDPLCodes cursor for

select distinct(DPL_CODE) from DESCRITIONARY_MASTER order by...

Hi,

yeah am trying that...Thanks a lot.

Santhu.

Except one thing.

Number of 'DPL_CODE' will vary..So the name..Client may put as many as they want with wotever the names they like..

So we can't hard code it like following

ISNULL([VP-LISO],0) as...

ITEM_CODE VP-LISO XP-CMO MP-COM

--------------------------------------------------------

1 ...