Hi John

Yes all the users are in the same database. And all the users have same name as their respective logins.

Thanks.

I have to fix both types (windows, sql) of orphan users.

Thanks.

But I think this is one by one process to fix orphan users.

Thanks

Ok, Thanks for help.

Hi Gail, My OS is 64bit Windows server 2008 R2 Ent. it means If I have 2 processors this 80-90 value should be devided by 2. And final value would...

Hi Gail,

If check %processortime for SQL Server instance it shows average 80-90 but at the same time if I check %processortime for total is shows average 40-50. If one process...

Ninja-I Can see few user's active connections. But most of the CPU are being utilized by background processes.

Bhuvanesh-I need to check the service broker.

Thanks in advance.

Thanks for your help 🙂

Can you provide any scripts for SQL Server 2000 as well.

Does this run on both boxes 2000 and 2005. I executed this script on 2000 box but it threw errors.

//

Server: Msg 156, Level 15, State 1, Line 71

Incorrect syntax near...

Ninja-Its data growth in data files.

Thanks all for replies.

It is 32 bit, I read on MSDN if the PLE is more than thousand means there is much Memory for SQL Server to cache the data. But I dont...

Muthukkumaran,

This is not my home PC its client server, I have noticed one strange thing on sever also. Page Life Expectancy continuously remaining 1100+ I just could not understand. Can...

Hi opc,

It would be great if you can post a script that can enable autogrowth for all databases from more than one instances. Because I have a list of servers...