The problem was only for half an hour. Now I can connect using SSMS and application is also able to connect. I am trying to find what was the reason...

It is 64 bit system and running SQL server enterprise edition in cluster environment(45 node). Max. memory is not set. But I want the temporary solution now.

When we install SQL server we add the current user (Windows login) for login to SQL server. You can connect through the windows login from where it was installed. You...

SElect a.EmpName EmployeeName, b.EmpName ManagerName from Employee a, Employee b

where a.MngrID=b.EmpID

For the same database log size is 55 GB and data file 15 GB though transaction log backup is taken every 2 hour. Can you tell me why this is...

What jobs run between that 12:30 log backup and the previous log backup?

Only full backup runs at 12.00 AM between this time.

We have one job for rebuilding indexes which runs at 2.00 AM every sunday.

DBCC INPUTBUFFER(SPID)

Thank you all for the reply.

Anybody knows T-SQL commands to get the data pages for a particular table.

Hi Adi,

We got microsoft recommendation like this..

An index that is more than 5 percent or less than 30 percent fragmented should be reorganized. In addition, an index that is more...

I got the answer. My SQL server agent was down though it was showing running state. I restarted the agent and it worked fine.

Hi,

I have run SQL server profiler and dont find anything. Any idea if it is the problem with the permission?

No blocking and active transactions found.

Hi,

There is no blocking when the job is executing.

Hi,

Thanks for your reply. As per the reply I need to install SQL standard edition and need to restore all the things.

But I dont want to uninstall evaluation edition, Is...

The index storage space is 55KB.