In my application I have a process which picks the scanned
files (tif format) from a shared location and it links to
application and shown on it.The actuall issue is that my
process picks the file before it is completly written or
scanned which results in displaying few parts of the image
or incomplete image.I need to check if the file is not
completly scanned or written then do not link it to
application.Please help if any body tell me that how can i
check that file is in written phase or locked through
DTS.thanking you in advance


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


How to Rebuild Master database in sql server 2005.

2 Answers   Wipro,


if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,


Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,






optimization techinques

0 Answers   Wipro,


Tell me the phases a transaction has to undergo?

0 Answers  


Define self join?

0 Answers  


What is indexed view?

0 Answers  


What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,


What is the maximum size of a row in sql server?

0 Answers  


Comment,Datatypes are unlimited

0 Answers   IBM,


Categories