Thanks Steve, but I would want to read these files from c# code. Looks like avanstar does not provide any sdk for this. I am more looking at a driver...

Hi,
Did you get the solution to the problem that is reported. I have the same problem now. Your solution will help me. There is no help on internet related...

Hi Guys,

Thanks for the suggestion, but regarding the complexity of the query it still puzzling me as its a blanket select statement.

I will add index to the table and let...

hi,

Thanks for the help, i tried using sp_OAGetProperty. But i cannot use this because as part of the security issue this command is blocked by the administrator.

I am building...

Thanks to all,

Just gave a quick check, you were right in telling that the trigger holds a lock on the base table and since the after the trigger has completed...

Thanks for the quick reqply Jason and Ramesh,

I will explain exactly what i would like to do. The table "test_table2" will be initially empty. Records into the table will be...