Ok I've managed to find further info.

There is a slight difference in the execution plans, which becomes obvious when I include the showplan xml statistics profile and not just the...

Hi,

thanks for the reply.

I have run it for about 3 seconds and got 10,000 rows when just have 'transactions' category selected.

I guess what would be good would be a query...

This wasn't browser or memory leak or performance related as such as any other user could use the same browser the same report report on the same pc and it...

Hi Phil,

No its definetly IE 8. 🙂

Thanks for the reply, but I don't think it will be practical as there are 1/2 million documents but thanks anyway.

Hi Lutz,

thanks for the reply.

I am a little confused as my previous post shows that my tables have completely different field names and number of fields so I cannot 'easily'...

I have a table named CUS

This has fields ID, Name, Postcode

I also have a table named PRD

This has fields Item, Value

My end result is this

<Root>

<rec>

<ID>ABC123value</ID>

<Name>Acme Corp</Name>

<Postcode>M1 4XY</Postcode>

</rec>

<rec>

<Item>SQL 2008 R2</Item>

<Value>5000</Value>

</rec>

<rec>

<Item>SQL 2005</Item>

<Value>4500</Value>

</rec>

</Root>

I...

Hi,

I haven't changed from defaults so its still set to 0.

I am now trying to get it force success as result and capture output into a variable which I then...

This solution appears to work.

In my DB that just contains stored procedures the 'web' login has execute permissions, and this database has its trustworthy property set to on.

The 'web' login...

I've had a look at the SCD in SSIS and while it worked very well for a dimension table of 100 records or so.

When I tried it against our Item...

Yes the index rebuild is an overnight job.

I'll experiment with replication as if changing the recovery model breaks transactional replication then I am stuck with trying to identify changes purely...

Hi Brandie,

Thanks for the reply, sorry, maybe I was not clear in my description.

I wasn't suggesting to use Timestamp as a date comparison just a value comparison, as I would...

I have actually found in SQL BOL that using the .NET ODBC as the data source you cannot select 'copy tables' as it cannot see column information and you must...

Hi,

I had already tried that but although I can see the tables when I try to 'preview' the table I get an error message saying 'you have an error in...

the setting are at default, the protocol tab has 'Listen All' set to yes, IP1 has active set to Yes and Enabled set to No and the IP address is...