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

1974

Explain what is log shipping?

1152

Explain magic tables in sql server?

1067

What is a trace frag?

1096

Explain a join?

1074

Explain index in sql server?

1026

What is the difference between truncate and delete commands?

1079

What is a mutating table error and how can you get around it?

1061

How to receive returning result from a query?

1139

What is inline table-value user-defined function?

1126

Explain the properties of a relational table?

1035

What is federation member?

116

Define union, union all, minus, intersect?

987

What do you understand by integration services in sql server?

972

How ssrs maintain security?

1097