|
|
-
Jacob Sebastian Commented 11 Days ago through Ask | 10 Points
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....
|
-
Jacob Sebastian Commented 11 Days ago through Ask | 10 Points
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....
|
-
Jacob Sebastian Commented 22 Days ago through Ask | 10 Points
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...
|
-
Jacob Sebastian Commented 26 Days ago through Ask | 10 Points
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 = ]...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
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...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
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...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
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...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
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?...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
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...
|
-
Jacob Sebastian Commented 1 Months ago through Ask | 10 Points
TRANSACTION ISOLATION LEVEL is set on the database level and there does not seem to be an option to configure a default setting on the user/login level. After establishing a connection to the server, each session can change its own isolation level based...
|