4 questions from the last 7 days
0
votes
1
answer
74
views
Call stored procedure in separate session in SQL Server
I tried calling a SQL Server stored procedure in another session.
This is my code:
CREATE PROCEDURE [dbo].[CI_AdHoc_PrepareJob]
(
@JobName NVARCHAR(50),
@StepName NVARCHAR(50),
@Value ...
- 1,416
-1
votes
0
answers
38
views
Why am I receiving this empty xmlns? [duplicate]
I'm switching over a BizTalk port from adapter 'SQL' to 'WCF-SQL' due to the former being removed from the next version of BizTalk, I can receive the message from the stored procedure fine, except for ...
- 15
0
votes
0
answers
38
views
The module being executed is not trusted - for procedure "with execute as" clause
I have a stored procedure in a database OmegaCoreAudit that queries the master.sys.fn_get_audit_file records and stores them to a table in the same database.
The owner of this database is login ...
- 369
-2
votes
0
answers
35
views
I want to create a task which will be calling a procedure and the procedure will be calling a scala file on snowflake [closed]
I want to make a Snowflake task which will call a procedure and the procedure will be calling the Scala file. Please refer the below diagram:
+--------------------+
| Snowflake Task |
|------------...
