Sanjay

Have you done what it suggests in the error message? Looks as if the problem is so serious that you can't back up the database. Copies of the...

Use PATINDEX to find where the text finishes and the date starts you can use '20[0-9][0-9]' or something like that as your pattern match. Once you've got that, it's...

Your CASE expression returns NEW or OLD, and you're casting it to bit, which isn't valid. Change your CASE expression so that it returns 1 or 0, or cast...

Looks fairly simple - you're just joining all three tables together, and using a MAX or MIN to get the top sale per invoice. Is there any particular part...

I'm saying that's one option, yes.

John

Not as far as I know. But you could manually amend the script as soon as it's generated. Or you could write your own query to return an...

I've never heard of it, but from its name, I'd guess that it's a trigger on the sysarticles table in your published database. Does such a trigger exist? ...

Is that because you haven't changed anything? Try disabling replication and pressing OK, then open it again, tick the box to enable, and see whether the Script button is...

I don't know what's going on, but one thing that may be worth trying is instead of hitting OK, generate a script and run that, one statement at a time....

Mike

The log backup will only be huge if you haven't backed it up for a long time (or, more accurately, if there has been a lot of changes in the...

Mike

Yes, your understanding is correct. That's (one of the reasons) why it's important to make regular transaction log backups. DBCC SHRINKFILE is indeed not recommended for regular use,...

It works on SQL Server 2012. Make sure you choose Surface Area Configuration from the Facet drop-down list in the View Facets window.

John

I think you'd be better off with an alert that notifies you every time there's a blocked process event (if that's actually what you want - you may change your...

I notice this is an old thread, but in case anyone reading it is in a similar position, the steps are much simpler than those recommended above:

(1) Take a transaction...

Yes, good point - Microsoft released a fix prior to SP3 that's supposed to have addressed stuff like this.

The only things I can recommend are updating statistics more often (with...