I've found they arrive in SPAM sometimes. Atleast in my Yahoo account

select @@version

According to the books online the xp_msver stored procedure gives more information

That needs some deeper digging.

It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.

Do you retrieve all the records you request instead...

That needs some deeper digging.

It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.

Do you retrieve all the records you request instead...

check out

http://support.microsoft.com/kb/839279

You can shrink the database (reclaim unused space) with

DBCC SHRINKDATABASE

DBCC SHRINKFILE

See the books online for more information.

Have you tried increasing/decreasing max worker threads?

Do you have the truncate (remove unused space) on in your maintenance plan?

Sure you do the same type of backup (full, differential,...)?

Have you watched your performance counters?

Perhaps the server is too busy with I/O or something else.

Perhaps a difference on servicepack level of the clienttools.

Do they match the sql server servicepack level?

You will have a performance drop since it needs to communicate with another server.

How large the drop will be depends on the amount of data & network latency.

Your commandtimeout is adjusted to 10 minutes?

Is there any rollbacks of  transactions?

You can post your query in the T-SQL forum if you need to speed it up.

Hello again.

Normally when there is a time-out you get an error.

The stored procedures does return the results in the query analyzer?

SELECT *

FROM Table1

 INNER JOIN Table2

 ON Table1.Date = Table2.Date

AND Table1.Date >= convert(datetime,'20060324') /*always pass universal date, with function on the right allows indexes to be used*/

AND Table1.date < dateadd(d,1,convert(datetime,'20060324'))

Hello.

*Applying a function on the restrictive column is really nasty for your performance as you force out a full table scan instead of an index scan.

This also leads to additional...