Hi Ajit,

The table structures in my case was diferent for each files. At that time due to urgency of project, I switched to TSQL and bcp in menthod using xp_cmdshell....

Hi,

I had once faced a situation where the transaction log was full. Below are some steps you can refer to;

Solution 1:

=======

DBCC SQLPERF(LOGSPACE)

BACKUP LOG Comapny WITH TRUNCATE_ONLY

DBCC SHRINKFILE (Company_log, 500)...

Hi,

You can create a script using the extended stored procedure "xp_fixeddrives" to check the space usage in each of the hard drives.

Regards,

Shodhan

Thanks for your opinion, but can you please elaborate more on this.

Regards,

Shodhan