Keep in mind that several things have changed in 2005. Check the whitepapers for the differences between 2000 and 2005. For instance many of the system tables (like sysobjects /...

Can you explain how the application is programmed to connect to the database. So: what is the connection string used by the application.

Are the users logging in to the application...

Be aware that proper permissions needs to be set on two places. First is as share-permissions (when creating the share) and second in the security tab for the access-permissions.

Check the...

I see several other posters allready beat me to it...

there are several system tables that contain the required info.

Example:

select * from sys.database_files

select * from sys.filegroups

It is an "Operation System Error". That implies the location is not accessable. Either because you don't have accessrights, or because the location doesn't exist / isn't available.

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...