Excellent, that is what I eventually found as well. But now my user wants multiple column indexes on the temp table. Any way to create a temp table...

I searched this site and found nothing. The only suggestion I've had so far is to add the user to the Target Server Role on the msdb database, but...

This is in BOL:

Note Indexed views can be created in any edition of SQL Server 2000. In SQL Server 2000 Enterprise Edition, the query optimizer will automatically consider the...

Yes, I am a sysadmin and dbo on the entire database server

The debugger is installed on the server and on my local machine. I am an administrator on my local machine and on the server. I was running the...