Type store procedure for WCF SQL adapter

Asked By rubyjmorales 10 points N/A Posted on - 06/14/2012

Hello,

I want to know some basic stuff of SQL. Suppose I use WCF SQL adapter to store the log messages to database. But some characters are needed to be skipped in XML. Is there any way to other than typed store procedure to avoid the characters?

• Status: Open
• Question Views: 1184
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Biztalk Server

Answered By Parsh Auguston 0 points N/A #141255

Type store procedure for WCF SQL adapter

Some web servers allow you to use certain type of scripts that skip such invalid characters that might cause the problem. Since you might not own such type of server, it means that you either have to stick with the stored procedures or with the option of switching to a new server.

The last possibility is if you think to make the script yourself.

1. First see what type of characters you want to skip.
2. Then define a script that would check each message before entering in the log.
3. The script must not change the other elements of the message as it defeats the purpose of having it.
4. After the script has been written, use it to see if it is working.

About Parsh Auguston

Questions
2

Answers
152

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 08/04/2012
• Question Category: Biztalk Server