Hi renuka,

I just drop the table and recreate it. Thank for your reply.

zombi

Hi,

I think i have to explain my question more clearly. Actually i am maintaining sql server. Active directory is managed by other department. Now sometimes they asked me to add...

Hi Gail,

I will set the maz memory to the 2048 but how about the min memory? and if i set the max memory to 2048 does that affect the sql...

you should remove the wmi error and then use your MOF command it will work. I also had the same problem.

Zombi

hey jeff,

how r u doing? i solve that issue. I had to fix the WMI and now it is up and running.

Thanks for ur contribution.

zombi

Hi everyone,

Do not bother about this post now. i resolved it by my self. It was some problem with the .dll files. so now it is all right.

zombi

Hello,

Where to find for the Brad McGhee's tutorials. Please provide link Thanks,

Zombi

Hi Jeff,

I checked the services it is SQLserver (MSSQLSERVER) so it is a default instance and i checked the edition it is "enterprise edition 64bit":(.

This is our production server...

Hi Jeff,

No worries mate, You tried your best to answer my question. Thank you so much for your time and effort. May i will try to contact microsoft because any...

Hi Jeff,

I have already checked the services from administrative tools-> services all the sql server services are on. Services are ON that is why i can connect to the database....

Hi Jeff,

I am connecting to the same server as i said . When i tried to connect to the configuration manager it throws an error which is

" Cannot connect to...

Hi Jeff,

I am using RDP to install the SP2. This what i get when i go to SSMS-> Help -> About

Microsoft SQL Server Management Studio 9.00.1399.00

Microsoft Analysis Services Client...

Hi Jeff,

When i am trying to update the sql server with sp2 it is not showing me the instance i want to upgrade it just shows the screen shot that...

Hi jeff,

I am connecting to the same server as it is displayed. so I don't think that should be a problem. And what do u think about those START, STOP,...

hi Jeff,

Thanks for you reply. How can i identify that it is cludtered? and if it is then how can i connect to the active node???????? can you please...