If you don't have issues with SSMS then you know all data is available. Because your app does get all data from DB2, the connection is most likely also correct....

What if you query from SSMS. Can you get all data from D1 or also only part of it?

I agree with GSquared. One addition to the quote: if you use a lot...

If you use a manipulation (like LEN, UPPER, etc) on the left side of a comparison, then SQL is unable to use existing indexes of that column. If there is...

Hi Phil,

If you need better response I guess you should also post this in a (VB) programming forum.

I think you should create an ODBC within Excel-VBA to the SQL server....

I totally agree with Michael allthough he should use the URL format 😉

http://www.sqlservercentral.com/articles/Best+Practices/61537/

You can use UNION to combine the matching columns of both the TAB1 and VIEW1. When you select a GROUP BY from this result and include a counting of rows,...

Hi,

Your view contains a list of columns belonging to one or more tables. Can you give us the underlaying table definitions? Does the view contain the same table you want...

You have to give many more specifications about the job: what it does, how long it runs, after what time the CPU starts to increase, etc. before we can give...

Maybe this can do the things you want:

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm

First:

Do you really need every DISTINCT and GROUP BY? These are performance killers, so if you don't need it, don't use it. If it is needed, try to first select...

Maybe obvious, but

- did you enable the job (checkbox on: job properties - general)

- did you enable the schedule (checkbox on: job properties - schedule - edit)

Please clearify:

1 You create a new job

2 You schedule the job to run once

3 The job runs without error

4 You re-schedule the job to run once (again)

5 The job runs...

At the end we found the problem is due to a bug in the connection.

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PageID=1&PostID=3055387

One of the transactionID's is timed-out and rolled back, but this is not reported back...

Found the problem:

The statements in the batch-process are executed under different TransactionID's while everyone thought it was under the same one. Sometimes the application ends a transaction without issuing a...