Hi PaulB

I've used the replication terms of publisher and subscribers to help understanding what will go on only. The workgroup edition does not allow any publisher to be setup, only...

Are you using a domain? A domain using a router to your machines? or a workgroup?

I've taken for granted that was the latter from the ip address

Check for port 53, UDP In and Out. It is that port that's used to query a DNS name in a domain as well as a computer name in a...

Damjan Djurasek, he is able to connect using the IP address therefore the port is not an issue. If the IP would have fail, then configuration, security configuration, sql browser...

Hummm from the IP you seems to be on a "home" network (Class C). DNS names are not resolved for this. If I saw it right you then need a...

yes you're right Michael Valentine Jones, thanks.

However from the application point of view it will be easier to have a string array.

Here's the code in case: (it does not look like the tally table method but it got from there to this solution)

DECLARE @keysArray VARCHAR(200)

SET @keysArray = '1,10,15,100,200'

SELECT neededRows FROM theTable

WHERE...

yes! Thanks JacekO It does help a lot! Forgot that tally table (never used before, so easier to forget!)

I have modified a bit the tally table method to include it...

SQL Server Agent is to schedule tasks inside SQL Server. Not the mean to connect to an instance, this is the SQL Browser Service task to get you that information...

I did find why it was not working, and I did find a workaround for it.

First, this is a known bug at Microsoft:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=214251

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=185170

(Yes two bug report...

Thanks for the article it has providing interesting information about memory usage.

The next step I believe would be to find memory ressources for each applications running on the box. I...

As always, I do like your personal way to write articles.

Just wanted to let you know it!

Indeed, but I would like to do it by using the minimum SSIS scripts components. I do have some spare time right now, so I'll learn a bit more that...

sqlsatyam, through scripting (the last resort option) I don't see why it couldn't

Humm sqlsatyam, I have never done an upgrade from 32 to 64 bits but judging from this article I do think it might be feasible:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693_mem1,00.html

One step at a...