Hello again,

This could relate to your “Connection Error” post i.e. the SSIS Package is the cause of the maximum number of concurrent connections being exceeded. (Please see my post on...

Hello,

One of the reasons that you can get this message is because the maximum number of concurrent connections is being exceeded.

I wonder if that is true in your case, as...

Hello,

It is not essential to install the BizTalk DBs on different Instances, but this is (often) done to improve scalability, performance and/or availability.

May be take a look at this MSDN...

Hello,

I have not tried it, but I assume you could use xp_cmdshell to execute an SC Query against the FullText service.

This article has sample code for doing that against other...

Hello again,

With Triggers eliminated then permissions would be the most likely cause.

It could also have been an issue with a constraint on tblComparison, but as you mention the same SP...

Hello,

Could you script out and post both the SP and the Table definitions?

Regards,

John Marsh

Hello Mike,

It may be difficult to diagnose without the State part of the Error Message. Do you get a corresponding entry in either the Event Log or SQL Server Error...

Hello,

It is possible to have multiple Publications from the same database.

How up-to-date does the data on the test DB need to be? I am just wondering if Snapshot replication might...

Hello Jason,

Sorry for asking, but just to be sure, the target server does have Mixed Authentication Mode turned on?

Regards,

John Marsh

Hello Mike,

That sounds like a reasonable method to me.

Can you post the full error that you get, especially the Error Number and State?

BTW – Do you get the error when...

Hello,

My first guess is the Message Box is being displayed while a Transaction is open - worth checking anyway.

If so, do you have control over the Source Code i.e. can...

Hello,

At first glance it does seem like a permissions issue.

You could run a Profile to ensure that the expected SQL Statements are being sent to the DB, and if...

Hello,

Can you afford the 15GB space? If so, then probably best to set the Log file at that size. It would prevent another process (or user) from grabbing the free...

Hello,

I think you will have to do this on a message by message level, by configuring “With Log” for each error number that you want written to the SQL Server...

Hello Soundari,

You don’t need the workflow to go to the connection (they are sort of independent of the workflow). You would instead want the package to move on to your...