can you show an example that explains what exactly you are looking for?...

are you able to create a short repro-script which demonstrates the problem? I can then run it on my side and see what exactly is happening....

I was referring to changing the default isolation level of the database. I understand from your reply that it is not permitted in your environment. So I am not aware of a workaround which will help you to achieve the required result....

This post is inspired by a question in MSDN forum about disabling certain rendering formats when setting up SSRS subscriptions. This can be achieved by changing the SSRS configuration file as explained below. I never had a real-world scenario where I n...

This is a basic template which may help you to get started CREATE TRIGGER MyTrigger ON MyTable AFTER INSERT, UPDATE AS BEGIN -- Values being inserted/updated can be found in virtual table INSERTED -- DO Your validation by reading values...

I have not tested it, but it looks like the culprit is the default query-result-width (which is 256). Try increasing this and see if that fixes the problem. The following excerpt it taken from the [MSDN documentation][1]. > [ @query_result_width = ]...

...

FILESTREAM data can be accessed by TSQL as well as through the Win32/Managed APIs. Accessing FILESTREAM data using TSQL is not recommended for a number of reasons such as the inability to stream data when reading or writing through TSQL. The recommended...

What exactly is the procedure `usp_PhotoAlbumInsert` does? Probably posting the code inside this procedure will help to identify the problem area. The error message indicates that the row associated with the current FILESTREAM operation is locked by...

There are two parts in this query. 1. The part that joins your relational tables (based on your application specific logic) and produces the desired result set 2. The part that produces an XML document from the result set. When I wrote the pre...