Put Set NoCount On at the top of your SP.

I think the only way to do this is to union in a None or blank value into the dataset for the parameter list. You don't have to add...

You would need to share some code in order for anyone to venture a guess as to what is happening.

For security purposes it is recommended that sa have a very strong password and that the account is not used by anyone.

If you have a Windows Domain the...

Basically it is a pain to get multi-value parameters to work with stored procedures. Attached is a zip file that includes:

a simple report that uses a multi-value parameter

the datasource...

Your issue is that you are using DMO in Usp_ErrorLogCheck and you would need to convert that procedure to use SMO for it to work with SQL Server 2005. ...

Again, this assumes that you are just left padding integers.

DECLARE @test-2 TABLE (string CHAR(9)) ;

DECLARE @start INT, @end INT

- this is your range

SELECT @start = 210000001, @end = 210000009

-- this...

Can you connect to the server using another application like SSMS?

Duplicate post. Please post answers here.

Duplicate post. Please post answers here.

Have you checked to make sure that the SQL Server has Named Pipes enabled? YOu can check this using the SQL Server Configuration Manager under Network Configuration.

This works, but it is basically the same as doing it in a join later.

SELECT

SUM(b.occupants) AS 'People at risk (incorrect)',

A.atrisk,

...

The Between will actually work. If the character string is always a padded numeric you can also do an Explicit conversion to int and then the between.

This sets up...

I don't believe you can unless you are setting up your SQL Statement to be from a variable and you build the variable ahead of the OLE DB Command step.

I...

AS I look at your code, I'm wondering if the issue isn't a long running transaction. I'm not sure how SQL Server handles transactions when using dynamic SQL and...