I think I found the reason and answer here

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=103751&SiteID=1

Does anyone have any further info on IgnoreRoot = False?

Thanks Piotor - saved my week.

Thanks.

Are you getting an L or a £ ?

I modified your code to include collation and got 2 x L, I need to match L to L but it is...

Desperately trying to stimulate intrest...

I understand (high level) what XML is and also what an XSD is, its the word Link that I dont get. The contect is in electronic...

Thanks for this. I'll see if I can get some help from our stats guys to translate the equation into SQL, I should have paid more attention in maths!

Agree with you on that however I'm OK on SQL but would not know where to start in SAS.

Thanks. I am trying to automate the creation of test and control groups for marketing purposes against a total population of 20,000 accounts. There are approximately 16 mailing campaigns but...

You may be looking in the database engine rather that the integration services engine.

In object explorer click connect and go down to Integration Services then connect to Integration Services, then...

Try

RESTORE DATABASE MyDB WITH RECOVERY

Allen

The transaction log is still written to in Simple recovery mode.

Hi

typo in your code I think

DECLARE @strErroMsg VARCHAR(100)

SET @strErroMsg = 'Test Error '

RAISERROR( '%s master not found.', 16, 1, @strErroMsg )

Allen

Has that affected the index scan you mentioned earlier, are these now an index seek in the execution plan? You can...

I think this depends on auto create statistics in...

Bingo (I hope) try CREATE STATISTICS and see if the execution plan changes

I'm not sure if DBCC UPDATEUSAGE and UPDATE STATISTICS do the same thing (anyone comment?).

It may be that stats dont exist you may need to run CREATE STATISTICS