You can try to check if this caused by any CLR. Examples of how to find CLR assembly: http://msdn.microsoft.com/en-us/library/foo9fe0d4fd-950a-4274-a493-85e776278045.aspx

Memory errors on SQL Server 2005 32bit related to...

Something to consider when you set up test environment - make sure you use the same backup to setup databases on servers you are going to compare. You can have...

Mani-584606 (4/29/2010)

---

1. Can we use same port for all the instances in 10 sevrers? for example, 2122 port for all sql instances on all servers? Is that the right way...

Hi,

If you use SQL Server Configuration Manager to change service account (which is recommended way to change it) you don't need to grant any permissions. In other case (changing service...

Hi,

Here is an article that has a lot of information on problem http://support.microsoft.com/kb/969962 (although it describes issue for 32bit SQL Server). We had similar issue on SQL Server...

Hi,

Does SQL Server service account on your primary server run under the local system account? If yes, than "you must create your backup folder on the primary server and specify...

Hi,

The error is "An arithmetic, numeric, string, conversion, or constraint error occurred."

This could be data type conversion (or truncation) error. You need to map data types properly between Oracle and...

Microsoft has an article for this issue: http://support.microsoft.com/kb/811008

I had similar errors just yesterday. This article has information that I use for troubleshooting: http://support.microsoft.com/kb/918483

Christian Buettner (7/13/2009)

---

So I missed the "not" - verrrry tricky! 😀

If it was intended to be tricky, then I admit it was well done.

If not, I assume rephrasing to "ALLOW_PAGE_LOCKS...

Good question!

Try to set verbose logging for the Reporting Services to get more information. The default logging level is "3 - information". Set it to "4" in the [systems.diagnostics] node of...

The question has a note about fitting cursor in memory. This is what BOL says about FAST _FORWARD cursors:

"The most dramatic improvement is seen when processing cursors with relatively small...

Database mirroring will not work for you definitely. Mirror database will not available for reading.

You can use transactional replication or log shipping. Log shipping is easier to setup and troubleshoot....

What can I say more? I am in 94% as well.:hehe: