I think that...

IIRC, to do this the database needs to be cleanly shut down. If your transaction log is totally lost due to a corrupt or crashed drive, I don't believe...

Based on your sample data, what should the expected output look like? Manually build us a table that represents the expected results.

Means one of the triggers some where along the line is failing.

Since you disabled the first trigger and things worked, go to the next and work your way forward until...

joshd 1807 (5/4/2012)

---

The only roles the two users have are public, read, and write and they're both setup identical in the database.

I'm wondering if it's a case of 32bit vs....

It depends. What were you making when you were there? How much do you think they will pay?

bopritchard (5/4/2012)

---

Here is the lay of the land. I've got a .net application I'll call APP1 and two SQL server instances I'll call SQL1 and SQL2.

On SQL1 there is DB1...

Best thing to do is contact Microsoft.

Technically, as long as no users make changes to database objects (CREATE/ALTER/DROP tables, stored procedures, functions, etc), then you can use the Developers Edition...

Matthew Cushing (5/4/2012)

---

I would Lynn, but I just started a new job and I don't think they'd appreciate me posting stuff from our internal apps.

I hear that it'd help with...

Could you post the DDL for the table, some sample data to populate the table, and the expected results based on the sample data.

During the Sprint planning, as the group is selecting tasks to work in the next Sprint, it is possible for the team to select lower priority tasks based on capacity....

Without seeing the DDL you are trying to use to create the mirror between N1 and N2 we can only guess.

Are you trying to create this mirror to a different...

Downloaded and restored your DB last night. Went to bed right after, long day.

DBA_SQL (5/4/2012)

---

This is the table, where I would like to update with NULL values on the Lastname column with other columns.

Lastname ...

Edward-445599 (5/4/2012)

---

Hi, Okay so the sum of these values is greater than Max INT I tried to

cast(sum(length) as bigint)

But still no luck so how do I sum intergers when...