I have emailed you directly.
We get the same error with a number of different queries.
We have the latest service pack 2 installed.
According to Microsoft, this error...
Thanks I'll try this and see how we get on.
I getting the following error when trying to parse or execute an MDX query:
Parsing the query ...
Internal error: An unexpected error...
Thomas, I think this is probably the reason.
The table with the highest fragmentation is only using 22 pages.
If 8 of these pages are on mixed...
I have a few indexes showing around 30% fragmentation. Regardless of whether I use an ALTER INDEX with reorganize or rebuild, I cannot get...
It would appear that this can't be done. I am going to use a remote procedure to do the insert and then return the identity value as a parameter.
I am inserting into a remote table and need to get the identity value that was last created i.e.
I have created a stored proc on the remote server which inserts the text column into a temp table.
I then use UPDATETEXT which references...
The problem I have is that I need the full path to the column I am updating. This means by using the four-part name I actually need five...
I am trying to use the UPDATETEXT functionality across a linked server and am not sure if it is possible e.g.
This is BOL syntax:...
I had already spent a while reading that page.
Everything on there is specific to permissions. From my experience and my own...
I hope someone can help me with this as I am completely stumped.
I have a DTS package that uses an activeX script to loop through a bunch...
Separate names with a comma.