Read about ostress at http://support.microsoft.com/kb/887057.

MJ

If you still have your 2000 instance available then change the password on it and move the logins again.

MJ

I am able to run it with datareader role membership alone. Check for an EXPLICIT deny then.

MJ

What an answer!!!!!!!!!!!!!!

Fabulous!!

Manu

Remove it manually.

MJ

You should select the drive that you have already added under SQLGroup for SQL Server Data Files.

MJ

As previous poster said check it under the table you created it on. If you still cant view it then there might be some permission issue. Check for trigger...

Try tuning your query before you jump on to MAXDOP settings. Might be the missing index case here. Missing index might lead to parallelism selection by optimizer as stated at...

Try dropping/recreating the same login with same rights. I presume somewhere a explicit DENY is holding you back.

MJ

Thanks for sharing the solution.

MJ

Use Target Server Memory and Total Server Memory counters under Memory manager object in performance monitor to check the sql server memory usage.

http://sqlserverpedia.com/wiki/Memory_-_Performance_Counters

MJ

1. dbcc updateusage with count_rows

2. sp_updatestats

3. Rebuild all indexes (individually)

4. DBCC for DATA_PURITY

5. Change page verification to CheckSum (from Torn page)

6. Switch to dblevel...

How to install client tools only (Setup)

http://msdn.microsoft.com/en-us/library/aa197918(SQL.80).aspx

MJ

Do you still see pkey and fkey relation on tht table? If yes then check sysobjects table for their creation date. It might have happened that someone dropped it and...

Clive,

That script is not mine(lol). I got it from this site only. Hope script works ok for Tara and saves her time and effort.

Manu