Hi Savita,

Please follow below steps

1.Goto start->run

2. type services.msc and click on ok

3. Check for the sql server agent service...

Hi Gail,

LogFile size is growing rapidly. Can we use the backup log with truncate_only option to clear the log except the active log and...

I had checked in activity monitor. Its showing BACKUPTHREAD and another one IO_COMPLETION

Hi,

As per below link it does not take much time as it moves only 32 pages at a time. Thanks for the information.

...

Hi Anshu,

As per your current scenario you will be able to login to the box if you are administrator on the box....

Hi Perry Whittle

Solution you had given me is correct for my solution. Currently I am checking the permissions and will...

vmssanthosh (3/19/2010)

But you do not have to be rude like this.. you could have just ignored his post.. thats how people starts here... At the start itself no body answers...

Hi Bhuvnesh,

One humble request from users like you. Please dont reply if you dont understand the question or dont know the answer for...

Thanks for the reply.

Solutions which you had given works only for user synchronization i.e. fixing the orphan users. Here I am not asking about orphan users and fixing them. Let...

Refer this link to resolve your issue.

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

Hi,

You can download desktop engine edition from http://www.microsoft.com/downloads/details.aspx?familyid=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

Thanks

newbie2sql

Hi,

Check out this article. http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/

Thanks

newbie2sql

Thanks for the info. But how do i find for indexes both...