What's incorrect?

If the first column is a key then you shouldn't have duplicates.

You could qualify Andras' solution by first only grabbing dups.

select t1.key, t1.name, t2.name

from (...

I've seen similar issues and struggled with them. For some reason the query optimizer runs things differently in a proc at times.

If possible, it helps to try and clear the...

I completely understand, but please post some specs when you decide. It would be helpful for others. Also, can you post the current server specs.

Colin will have great advice, but...

Markus,

Very interesting. What was the issue with the view? Was this hotfix'ed?

Can you explain what you are trying to do? Any reason you can't do the math inline with your other queries/operations?

With SQL 2008 to be released next year, it's likely those exams will be retired. However there are lots of SQL 2000 instances still running, so I'm not sure your...

The login needs to have the connect right. There is no execute stored procedure needed to create the connection. It just needs the ability to connect, a user mapping in...

I'd use the scripting facility and script out everything related to security. Then search for the old domain and snag those items out into another file.

You need to better define what you are looking for. This is too broad a question to be answered.

You need to better define what you are looking for. This is too broad a question to be answered.

Not sure about the others, but SQL Server 2000 allows you to specify select, insert, update, delete rights separately to individuals or groups (roles) at the table and column levels.

I agree with the info above. I've never seen this as a security risk.

Gail's given great advice. I'd follow what she's listed.

Thanks for the update and glad it's working.

Does tempdb autogrow?

Is there disk space?

Have you rebooted?