Change or disable the alert. It makes no sense to have an alert for a condition that is already exceeded.

Bhuvnesh (5/4/2012)

It means that there should not be any connection (some process is using) with those files but why this case doesnt get applied on...

Great advice from Gus, but one thing I'd also add to my list to circle back on is to make sure that you round robin to all groups before too...

There are scripts here on this site to help you automate this. Ideally you restore all backups every day. If not, pick a few test workstations, set up restores on...

Are you using roles here for security to be sure the two users have the same access?

Is there perhaps some other trigger on the table that is causing issues?

Can you...

I think you're both off track slightly here. Apple doesn't do well because of sales. They do well because they've made very intuitive products that work great in some ways,...

How does it display in SSMS? If you look at the raw data, is it correct?

I'm guessing that you have some word wrap issue in SSRS. Does the text box...

Probably, and glad it's moving faster.

Large deletions across a table should be done in batches of 10,000 or 100,1000 or some reasonable level that allows you to stop it if...

The distributor cannot be a lower version than the publisher, that's the issue.

If you log ship to ServerB, it will work, but if you failover, you are stuck on 2008...

Are they all located in the same network area? Same subnet, physical location?

Check the Event logs for service information.

Pass, you type it, you're on the hook for it.

How does what help?

If this is just text data, is there a reason you can't just index the text data? If it's in Filestream, I know you can full text...

What updates? Are you talking about updating at the source or destination? It's not clear from what you are posting.

Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need to build some join so...