It's interesting to see the wealth distributions in different countries. A similar evaluation was done here a couple years back, though I have serious doubts about it's accuracy. Mainly because...

Agreed. The only thing I owe money on is my house,...

You're looking for the inserted and updated tables. In an update, inserted will contain the new values and deleted will contain the old values. Only the rows affected by the...

Leo (10/19/2008)

---

But what do I do if transaction log is getting bigger, for example -

Transaction log initial size 4GB [that is okay and I am happy with this size],...

Thanks Jonathan.

No problem. 🙂

Ok, so what exactly will you be passing to the function? Something like 'C:\Somedir\SomeOtherDir\'? What do you want returning from the function?

Also, what do you need it for?

What...

Did the drive the snapshot is on or the drive that the source DB is on run out of space?

There's no way to repair a corrupt snapshot. The only...

MarlonRibunal (10/18/2008)

---

Well, I did not ask the *obvious* question. What is the compatible SQL Server Data Type for C# Type DirectoryInfo? I want to pass well, again it's quite *obvious*,...

Garadin (10/19/2008)

---

In ASP for example, you can do:

sql="SELECT * FROM TABLE WHERE Field ='" & MyVariable & "'"

rs.open sql conn2

Instead of

sql ="Exec dbo.MySP @Variable =" & MyVariable

rs.open sql conn2

So...

That's showing that both SQL and the OS think that the...

Jeff Moden (10/18/2008)

---

The bottom line is, almost never write explicit RBAR like cursors and WHILE loops and be very, very careful to consider what may constitute hidden RBAR like UDF's,...

Don't.

Post the requirements for your update (table definitions, sample data, desired results), and we can help you write an update...

Probably.

I think at this point we...

The error message is fairly clear. The data types don't match. A VARCHAR(max) is not the same as a DirectoryInfo. What are you expecting to be passing to this function?

You need transaction log backups in full...