dbcc updateusage with count_rows

sp_updatestats

Rebuild all indexes (individually)

DBCC for DATA_PURITY

Change page verification to CheckSum (from Torn page)

Create a new backup

Perform test by the application team(s)

MJ

if there is a chaqnge in the table how will that be replicated?

Changes will be replicated based on the transactional replication schedule that you specified during configuration.

MJ

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