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...

May be this one? SELECT ( SELECT ckt.Name AS '@Type', ck.Name AS '@Name', cd.Value AS 'val', ( SELECT cl.Name AS '@cl', cu.Name AS '@cu', ch.Name AS '@ch', lb.Name AS '@lob', cd2.value AS 'dat...

You are absolutely right. I made a nasty mistake when I posted the original code samples. I have corrected them. Thanks for catching that....

This post is triggered by a question I recently saw in the BR Forum asking ideas for merging two XML documents. I thought of adding another installment to the XQuery Labs series to explain how this can be done from TSQL when required. The examples giv...

I do not have expertise in Oracle, but I believe you should be able to execute an UPDATE query on the ORACLE database from SSIS. Did you try this? Are you getting an error?...

Pranay, Depending upon the complexity of the environment, there could be a number of different approaches you may want to select from. Based on what I understood from your post, I would suggest you use an SSIS script task to combine all the XML data ...

Mark, It looks like the logon trigger will be executed before the user session is created, so changing the isolation level from Logon trigger does not seem to change the isolation level after the connection is established. Chirag, I suppose yo...

...

...