Hi,

I think I have missed two word in above comment which created confusion.

What i meant was truncate & shrink transactional log file only after taking full backup.If your database is...

Hi,

I think I have missed two word in above comment which created confusion.

What i meant was truncate & shrink transactional log file only after taking full backup.If your database is...

Hi,

I think I have missed two word in above comment which created confusion.

What i meant was truncate & shrink transactional log file only after taking full backup.If your database is...

good story.

One more lesson to be learned from above story to add the Maintenance Job of Truncating Transactional log files regularly so that you dont run out of space.

Hi,

I will suggest not to store the files in SQL Server 2000. Only store the path of the file in a row. That means you need to design your application...

Please try this function. this is very commonly used function in SQL Server.

SELECT * FROM [dbo].[fnSplit] ('232,33,546,2,4,5,7,8,1091,223,3434', ',')

CREATE FUNCTION dbo.fnSplit(

@sInputList VARCHAR(8000) -- List of delimited items

...

Hello Everbody,

Thanks for your reply. I got another way to fix above issue. To read status of sp execution i will be writing SELECT queries WITH (NOLOCKS) option. which will provide me uncommited data...