There are many ways to handle the concurrancy issues, following are few tips to start with :

1. If you are concerned about dirty reads, you could use snapshot isolation to...

one more useful link

http://sqlservercode.blogspot.com/2006/01/use-xpcmdshell-to-get-all-file-names.html

winslet (11/26/2009)

---

Thanks for the reply,

this table has the column page path, this column navigates the application for the required selection on the page. Not for all the users - the...

Table structure you have given is not normalized. Try to satisfy the normalization principles in the table design. Best solution would be to denormalize the table.

For the output you...

You could also try Aqua Data Studio

http://www.aquafold.com/

Since you are using LEFT JOIN on C,D,E,F, we are under the impression that table A and B has some records which may or may not be there in C,...

I doubt the error is from the column varchar(max) -- ntext conversion.

Can you also confirm error is coming from update statement.

Can you check the column definition of bbcode_bitfield and bbcode_uid...

If possible can you provide the function definition (with just input and output values), so that we could confirm.

Can you confirm if the function dbo.GetStudentAttempt is scalar or table valued?

If it is table valued function, there is a possibility that you get more than one row in the...