this is in the solarwinds DB, NetPerfMon and I had a similar issue with a reorganize query i got ==> http://www.sqlservercentral.com/scripts/index/64469/ and I modified it to apply those ALTER INDEX...

I'm using this index reorganize/rebuild script ==> http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Hi, I had a similar issue when there was no Service Packs installed for MS SQL 2005 and when I had an issue installing SP3 on the same server and...

no issues thanks :hehe:

ricardo_chicas (9/22/2010)

---

Thank you All

I found a really good book about best practices and such

With my sproc i just ran a query for missing index, modified on index to add some...

I think this is my issue aswell regarding McAfee HIPS stopping the Database Services install ...

I will get the security guys to disable HIPS an then I'll try again as...

DB mirroring can be set to pause ...

With log shipping could you just disable the log backup, copy and restore jobs to pause it for a server reboot for example???

Enable...

THANKS 😎

Thanks Gail ... so no DB corruption from the principle will reach the mirror DB ...

So both Log shipping and Database mirroring will not require downtime to setup initially on...

Hi yes it is SP3 :hehe:

I have domain admin rights and tried installing it with this account. I tried with the local admin account 1st...

The server server services update with...

I have a similar problem on 1 of the servers i check ... any updates on your issue?

Hi, I got it installed as per umakanthvydyula and ALZDBA's replies thanx ;-);-)

SP3 for Windows Server 2003???

how many columns and rows is there in this table?

if it's a small table it should not take long to display the table at all without indexes on it ...

hi sql peeps, when I run the query I posted above in a new query window in the management studio it runs without any issues. If I run it in...