SQL Noob,

Is the problem with the CURSOR or with the UPDATE STATISTICS statement?

If cursors are a problem try using table variables 🙂

i don't know much about the websphere but i think you can call webservices. if that is the case then you can interact with sevice broker using webservices

can you paste the top part of your stored proc, you might have made a mistake.

I was able to execute the script below and return 19000 characters. you can try...

You would think that they should have mentioned that in the download. 🙁

...marketing tricks.

But irregardless, I would recommend this package to any SQL developer.

Thanks, that managed to enable the menu option but unfortunately it seems my trial has expired.

i can't remember well but i think it was for the prompt. But the menu option for SQL refractor is disabled in Mgmt Studio.

Thanks Matt,

I know that they are separate products. Below is the content of the readme file that comes with the sql prompt bundle that i got.

--

SQL Prompt Bundle

=================

(c) Red Gate...

i used to pass an xml string as NTEXT with no problems and i did not need to put the xml declaration.

i had the same experience as above. I was using .net 1.1 and sql 2000 backend. when ever we changed the underlying tables, it was hell.

the upside is probably that...

Use table variables to replace your use of temp table.

declare @tmpTableA table

(

MyId uniqueidentifier,

DatabaseName varchar(500),

Path varchar(1000)

)

SELECT * FROM @tmpTableA

DECLARE @idoc int

DECLARE @doc varchar(4000)

SET @doc ='

<provider>

    <OrgID>Test1</OrgID>

    <OrgName>Test Org 1</OrgName>

    <OrgAbbrev>TO1</OrgAbbrev>

    <AlsoKnownAs>Org1</AlsoKnownAs>

    <Description>This is a test organisation</Description>

    <Keyword>test the organisation</Keyword>

    <Category>TestCat</Category>

    <AAACategory>1</AAACategory>

    <Matching>

        <Source>Bank1</Source>

        <RefID>TO1</RefID>

    </Matching>

    <Matching>

        <Source>Bank2</Source>

        <RefID>TO1</RefID>

   ...

and remember not to run foul of MS licensing schemes. 🙂

use DBCC CheckDB to check for problem with your database. Did you verify your backup when you created it?

You cannot change the collation of a UDT. It inherits from the database collation.

You could still include the collation in your select statement if that is what you want...

you get a mixture of multiple choice questions and simulation questions. I got about 12 simulation questions out of the 52. You need to know how to use the Studio...