CHECKSUM(*) is a neat method to identify different records... thanks for the memory refresh 🙂

To add on Nigel's post, you enhance the query in the following way:

DECLARE @d1 datetime, @d2 datetime

DECLARE @n int

SELECT

...

Try using SQL Server Profile. That would probably be the easiest auditing solution...

SQL Server Surface Area Config MAnager should be the target...hope this helps..

You can always use winrar to compress and divide in parts of 4GB

A great article in my opinion....would be amazing if you have any more of these experiences

A great article in my opinion....would be amazing if you have any more of these experiences

Thanks a lot Mark! That really ws helpful.

Can you also include any error handling and filtering (like where clause) within the xquery?

Thanks again 🙂

search for OPENXML... it will probably be your final solution...

use ping servername

Then the ip address is displayed.

Search for how to use the Bulk and SINGLE_BLOB within Openrowset.. It will do it. You should get started from there...

Hope it helps!

That's SQL Server 2008 🙂

Florian Reischl (3/10/2009)

---

Hello Bruce

Thank you for your answer! In my opinion it "because" a absolutely valid reason :).

I just found a third possibility in MSDN forums...

Try looking into slowly changing dimensions (SCD) within SSIS itself... That should help you

Try changing the maximum size limitation from the database properties.

Try installing MS Sql as a named instanced and not as a default instance. That would usually make things work out for you.