Viewing 15 posts - 301 through 315 (of 1,363 total)
Read about ostress at http://support.microsoft.com/kb/887057.
MJ
October 8, 2009 at 6:21 pm
If you still have your 2000 instance available then change the password on it and move the logins again.
MJ
October 8, 2009 at 3:44 pm
I am able to run it with datareader role membership alone. Check for an EXPLICIT deny then.
MJ
October 7, 2009 at 4:44 pm
What an answer!!!!!!!!!!!!!!
Fabulous!!
Manu
October 7, 2009 at 4:25 pm
You should select the drive that you have already added under SQLGroup for SQL Server Data Files.
MJ
October 6, 2009 at 2:24 pm
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...
October 6, 2009 at 7:03 am
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...
October 6, 2009 at 6:57 am
Try dropping/recreating the same login with same rights. I presume somewhere a explicit DENY is holding you back.
MJ
October 6, 2009 at 6:46 am
Thanks for sharing the solution.
MJ
October 5, 2009 at 5:55 pm
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
October 5, 2009 at 5:34 pm
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...
October 5, 2009 at 5:20 pm
How to install client tools only (Setup)
http://msdn.microsoft.com/en-us/library/aa197918(SQL.80).aspx
MJ
October 3, 2009 at 3:50 pm
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...
October 3, 2009 at 3:36 pm
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
October 3, 2009 at 2:40 pm
Viewing 15 posts - 301 through 315 (of 1,363 total)