furmangg, I have emailed you directly. Paul
ranjitjain, We get the same error with a number of different queries. We have the latest service pack 2 installed. According to Microsoft, this error...
satya, Thanks I'll try this and see how we get on. Paul
Hi All, 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...
Hi all, 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.
Hi all, I am inserting into a remote table and need to get the identity value that was last created i.e. insert into...
Adriaan, 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...
Adriaan, 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...
Hi all, 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:...
Thanks ranjitjain. I had already spent a while reading that page. Everything on there is specific to permissions. From my experience and my own...
Hi all, 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.
