You need VIEW SERVER STATE permission on the server to run commands like sp_who2 etc.

I had no idea about the answer, I guessed it and got it right. 🙂

Off late, there are so many questions on Visual Studio tools in QotD section.

It would...

You can consider using 'linked servers'

Perry Whittle (3/8/2011)

---

Mahommed can you supply more info on the set up you were using?

What hypervisor...

Can you try

select * from sysprocesses

paul.knibbs (3/9/2011)

---

This is odd. I'm sure I've read stuff that implies TRUNCATE TABLE *does* invalidate log backups until the next full backup is run, which means none of the suggested...

Duncan Pryde (3/9/2011)

---

It...

Thanks for the question Duncan. I had a feeling that this question was more at testing our understanding of the truncate statement than the recovery models.

I think there is no point in adding other unique...

Can you set Email Address as Kotak Global Logistics Ltd. in account configuration. Try testing with test email.

I think mentioning your email address as ems@klog.in wouldn't matter.

Chetan, I was not referring to SQL Server 2008 alone. As backup compression is a new feature introduced in SQL Server 2008, I thought we could use third party tools...

I will take a look at the job history. Is the job taking more time to run than usual.

If the job was taking 5 mins to run last week on...

Suri, would you pls revert back to this forum if you are successful in implementing failover using VM.

I had tried and ran into issues as my base OS was...

I would suggest you to do your own research/self learning first. Forums are basically for discussions. I guess many would agree with me.

Thank you Duncan for the feedback.