Hello,

The BOL Topic “Version and Edition Upgrades” suggests it is a viable upgrade path, but obviously practical experience proves otherwise. (Got to admit, I have never tried it).

May be MS’s...

Hello,

I am just wondering why you do not want to use an Identity column?

Regards,

John Marsh

Hello again,

I have a product table and a competitors table. I made a compatibility table with two column. ( productID, competitorsID ) for this. I think is that what John...

Hello Ran,

When you say the SP “completed successfully”, are you trapping all errors e.g. with Try and Catch blocks? It is possible for SPs to run through to the end...

Hello,

SQL Server takes advantage of Connection Pooling. This means Connections aren’t always immediately closed when they go out of scope, rather they are returned to a pool and then available...

Hello again,

Sorry to hear that. I just had vague memories of seeing an error very similar to the one you are experiencing when I was working with file paths, and...

Hello,

I suspect your SSIS package is opening up multiple connections, causing you to exceed the limit of 10.

Is there any particular reason why it is set at 10, or...

Hello,

Hopefully this article will help answer your questions:-

http://articles.techrepublic.com.com/5100-10878_11-5173108.html

Regards,

John Marsh

Hello,

I wonder if this is being caused by escape character translation i.e. needing two slashes to represent one. Just a thought …

Regards,

John Marsh

Hello,

You can get to the SQL Server Logs via SSMS again under the Management Node. (In SQL 2005 anyhow).

By Event Log I mean the Windows Logs such as Application, Security,...

Hello,

Did you look through the SQL Server and Event Logs when the issue happens? I am hoping that as the error message says, “the Connection has been established”, then a...

Hello,

You can build an initial SSIS Package with the Data Import Export Wizard. Just go through the screens and use the “Write a query to specify data to transfer” option,...

Hello,

I believe you are trying to model the relationship between your company’s products and the competitor’s products – correct?

Presumably each of your company’s products can have multiple competitors. I would...

Hello,

If this is not related to your connection issue then it is worth looking in the Event Log and SQL Server Error Log for any relevant (and hopefully more detailed)...

Hello again,

It is worth checking the setting for Maximum Number of Concurrent Connections. You can find this via SQL Server Management Studio (SSMS). Right-click on the Server in the Object...