Re: SQL Send Adapter ... I am trying to use this suggestion without success so far. ... Set the field for the XML part of the SQL insert message to distinguished. ... I am clear on how to create the schema and the ports; ... on how to pass the input XML message to the stored procedure.... (microsoft.public.biztalk.general)
Re: SQL Send Adapter ..."Alan Smith" wrote: ... > 1 Set the field for the XML part of the SQL insert message to distinguished. ... >> I am clear on how to create the schema and the ports; ... >> on how to pass the input XML message to the stored procedure.... (microsoft.public.biztalk.general)
Re: Using stored procedure properly ... You shouldn't put the stored procedure name for Request Root Element. ... When you are generating the schema using the wizard, the first screen asks for NameSpace and Request Root element name. ... (microsoft.public.biztalk.general)
Re: 3 Simple Security SQL Statements ... If I create a schema, can it be configured so that even later, when I ... add a new Stored Procedure, the database automatically adds it to that Schema ...SQL Server you are working with. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ... (microsoft.public.sqlserver.security)
Re: Help in sending Biztalk messages to SQL Server 2005 ... then a stored procedure would be the way to go. ... Use the SQL Adapter to generate an insert schema for you, ... This will actually add an orchestration and a schema to your solution, ... After that when you deploy it will create the SQL port for you and ... (microsoft.public.biztalk.general)
