What do you mean by this:

There is already one registered instance running on the same machine(only client connectivity).

Do you mean that you have the client tools installed and...

I would recheck your connection...SQL Server says it can't see the remote drive. If it is even a momentary drop of the connect, it's gone as far as SQL...

Yeah, I know I got it backwards.

I guess I was typing without thinking....too busy of a day. Thanks for pointing it out and correcting me.

-SQLBill

You don't say what performance problem you are having, so I'll take a stab at this...

You are trying to accomplish two things with the SELECT statement.

1. Get DISTINCT rows.

2. Manipulate...

BTW- this is one reason it's not always a good idea to put the system databases on a SAN.

-SQLBill

Where does it say anything about PERMISSIONS??? It says ACCESS IS DENIED. Totally different.

Causes:

1. the SAN is not available.

This can happen on a reboot where...

Enterprise Manager and Management Studio GUIs sometimes get out of 'whack' from the actual information. Try this....

Open Query Analyzer

Run DBCC UPDATEUSAGE('tempdb')

When it finishes, go back to Management Studio, click...

Since we don't have your data, it's hard to determine why it's taking a long time. Put the query into Query Analyzer then, on the menu bar, click on...

The database will reside at the customer site - access to logins/users will not be available to us.

What is to stop the customer from accessing the database directly? For example,...

Steve told you about the JOINs and ONs, but you still do NOT have the ONs after their JOINs.

FROM Inventory AS I

JOIN Block AS B

JOIN Phase AS P

JOIN ProjectSub AS...

SELECT statements do not cause activity in the transaction log (it's not a transaction).

INSERT statements do cause activity in the transaction log (it is a transaction).

So, SERVER3 is being used...

Is there something else happening on the database at the same time that might be blocking the update?

-SQLBill

Just run sp_dboptions 'databasename'. Since you aren't setting anything, it will return all the current settings.

If you add the second parameter, it will return the setting for just that...

Open Enterprise Manager. Expand until you see your database. Right click on it. Select Properties. Go to the tab for the Transaction Log. How many files are listed?

-SQLBill

My understanding is that if you have SQL 2000 client tools and you install SQL 2005 client tools it also upgrades the SQL 2000 stuff, especially the DTS tools. ...