Thanks for replying, John. Basically we wanted to stop using logon trigger because a minor mistake with the configuration of logon trigger can lead to locking down the whole instance....

Thanks everyone.

I'll work on these suggestions and will post on how it worked out.

Cheers!!

Thanks for the replies.

Well, I am trying to fix something that was already in place for sometime and I have no clue on how the front end works. So the...

That is correct, John. Its a named instance.

Thanks for your reply. I am able to ping thats why I am able to connect using port no. My problem is that I am not able to connect without...

We've been doing it at least once a week for last couple of months. Got it right. +1

I hope u r having SQL version > 2000. So forget about old ways of checking fragmentation and look for sys.dm_db_index_physical_stats for better results. Look for avg_fragmentation_in_percent and u need...

Use backup log with TRUNCATE_ONLY option to truncate the log entries from .ldf file and run a full backup. It should work. But I would really recommend to have your...

Can you run below command and see how many files are there in the backupset?

restore headeronly from disk='backup file path'

It might be the case that backups are getting appended to...

Nice question Shanjan. Thanks. +1

Hello Jason,

We had similar requirement where applications such as biztalk, sharepoint are restricted to use MAXDOP=1 but on a shared server there were many other applications too which were performing...

Thanks Gail. We faced the problem again today and this helped a lot.

Thanks guys!!

The last time we faced this issue was on a Friday and tempdb grew during off hours i.e. when there was no one actively monitoring. When I was informed...

Thanks for the basics question. +1

Good one. Thanks for this. +1