Lynn Pettis (7/9/2012)

---

Just to add a little more to this discussion, if there is a large amount of data in the table and you are using SSMS to modify the...

So, making clear what others are saying is... No. You cannot simply add a column to an existing table wherever you want. However, by using the Design option in...

Check out this[/url] article by Jeff Moden for your "running total" problem.

It is not about it being in an SP, it is because the connection is dropped and SET options are connection specific. So... No, you cannot have this persist outside...

Try this:

EXEC sp_MSunmarkreplinfo 'databaseName'

I'm not sure I completely understand... but could you use the ROW_NUMBER() function?

Take a look at this:

MERGE tableName AS t

USING #tempTracking AS tt

ON t.keyColumn = tt.keyColumn

WHEN NOT MATCHED BY TARGET

THEN INSERT(keyColumn, columnA, columnB) VALUES(tt.keyColumn, tt.columnA, tt.columnB)

WHEN MATCHED AND...

Ah. I believe you can use OUTPUT with a merge. I think I have a sample script, but I am having trouble finding it. I will post...

SQL_Baltimore (7/5/2012)

---

SQLKnowItAll (7/5/2012)

---

Ok. Maybe you can achieve the same thing by replicating from the 3rd party and then use DML triggers on your database to insert into a log...

Ok. Maybe you can achieve the same thing by replicating from the 3rd party and then use DML triggers on your database to insert into a log table. We...

Maybe I missed something, but why not just replicate the database and required tables instead of using CDC and then replicating? It seems to me like you are just...

guerillaunit (7/5/2012)

---

Thanks G2 and Dan, I like the BEGIN and ROLLBACK statement combination.

Jeff, this seems like a particularly painful subject for you. I hope someday you'll get over the...

If it is the application user that you want, and you are not concerned about others accessing the database through SSMs or some other way, then just write to a...

Lynn Pettis (7/3/2012)

---

I'm going to throw out the...

Are you running out of space? If not, I wouldn't shrink the file. Just continue to use up the available space.