A couple of things you could look at instead of using a specific index hint would be to use a query hint or plan guide.

Try using the OPTIMIZE FOR statement...

I would think the problem is caused because you are using dynamic SQL and you have started the transaction outside the dynamic SQL. Additionally, the way you are coding...

Redgate provides a fully functional trial version that lasts for 30 days. Who knows - if you download the trial and show it to the right people, they may...

I have seen these kinds of problems when the client tools used to create the maintenance plan is a lower version than the system where the plan exists.

Verify that your...

Huh - take a look at this article: http://www.sqlservercentral.com/articles/Development/2945/

Also, a simple google search on the...

Not sure of your actual requirements - so, please read the article in my signature if you need additional help.

Try this:

SELECT ID, [month], [year], Period

FROM dbo.OpMonthlyBonus

WHERE Period = CASE WHEN...

Gail wrote a great article I link to in my signature. It would be worth the read for you.

As for using TRUNCATE_ONLY - there is absolutely no reason to...

Please review the article in my signature. To better answer your question we are going to need table definitions (create table statements), sample data (insert statements) and expected results.

mark (5/12/2009)

---

Gail and Jeffery, In understand and agree with much of what you have to say. Regarding frequent backups of the log file, this really does not make a...

The easiest way is to log into SQL Server with the desired account and change the name of the maintenance plan, and then change it back. Open each sub-plan...

mark (5/12/2009)

---

Hi - I know this topic is a little dead, because it was posted in February, However I am going through this same problem now as we just completed...

Been there done that - just remember, this is a 'scripting' language and as such does not tell you when you have made a typo. I have seen where...

I tested that against one of my 2008 systems and it returned "10". Try adding Write-Host $srv.VersionMajor before the if statement and see what is being returned from that...

For objects inside the database (e.g. stored procedures, functions, views, tables, etc...) I use the comparison tools from Redgate (SQL Compare & SQL Data Compare).

For objects (scripts) outside of SQL...

Shawn Therrien (5/11/2009)

---

Jeffrey Williams (5/11/2009)

---

Not sure...