Check whether the permissions are denied at another level such as group or role

Hi

You cannot access a table or temporary table from a user defined function

Only tables local to the function can be accessed inside the function

Anything global (cursors, tables) cannot be accessed...

Hi

What you have been told about clustered indexes is true? although they make up by increasing the performance of the select queries

try to index with the field that doesnt...

What's the error you are encountering during the update? or

How do you come to know that it ended abruptly?

What application you are trying to update from?

is it a web application...

What's the error you are encountering during the update? or

How do you come to know that it ended abruptly?

That could help

shiva