In my last place of employment we used both Sybase and SQL Server.  Everything worked well as long as we kept the collation (code page, for us old folks) the...

My understanding (which may be flawed) is that if you bought the SQL Server with the 'per cpu' option, then you can hit it with as many folks as it...

Try adding a length specification to the variable definitions:

@dhb_service char(255), @dhbname char(255)

or make them varchar(255), or whatever matches the datatype you're looking up.

This

select

getdate() where 0.0 > 0

will return nothing.

You have to convert the strings to numerics

select

...

Can you run the Profiler and then connect the web servers one at a time?  The Profiler trace should tell you what the server is working on.

What permissions do you have on the table, and in the database?

Please post the actual query you're trying to run and the table DDL, including indexes.

What error messages do you get...

If the table has a uniqe value on which the result set is being ordered, you can do something like:

create table junktable (p_key int not null,

fielda int not null)

go

insert junktable (p_key,...

Check with the DBA to make sure you still have permissions to insert to the table.  If the permissions are OK, ask him or her to run the traces mentioned...

Can you turn on a profiler trace, or an odbc trace, to trap the sql and any associated errors?

Can you log in to the sql server OK?

Do you know of...

How are you trying to add the data and what, if any, error message are you getting?

I used to do this all the time.  You have to install the Sybase Open Client on the machine on which the DTS packages will run and you have to...

Your 15th trip throught the while loop gets a row and prints.  Your net loop through doesn't get a row and setus the status, but you print regardless so it...

I used to work for a place where 60 hour weeks were the norm.  The strange thing was that the group of people working together had a real chemistry and...

I'm not sure I understand the question. Do you have two points and need to know if they are within 1 or 5 miles of each other?  Do you have only...

Could you get the execution plans for the two queries and see what is different.  Sometimes a service pack will include tweaks to the optimizer that might (gasp) de-optimize some...