Yes, that IS possible, but highly unlikely.

It appears that the original designer of the database named all of the ID fields in all of the tables the same. ...

A calculated column is likely the best solution here.

Uh, this is completely untrue.

The distributor cannot be an earlier version than the publisher, but that's about it.

Currently I have...

Ok, Then what are you stuck on? This thread explains it pretty well.

isuckatsql (5/12/2014)

---

"I had a same...

isuckatsql (5/12/2014)

---

Can you create a SQL Trigger on an existing table to populate count values, or do you have to create an empty table, then create an Insert trigger, then...

See this link.

http://www.sqlservercentral.com/scripts/Date/68389/

A calendar table will probably work well for this use.

Please run these separate queries.

sp_configure 'min server memory (MB)'

GO

sp_configure 'max server memory (MB)'

GO

A key piece of information is missing. From the article you referenced, is this a 32 bit version running on 64 bit Windows?

Ok, I will give you that. You...

If this is a 64 bit machine, what did you turn on AWE?

How...

In the article, it states:

For a named instance, we typically only require two commands, because there isn't a case where a client is just connecting to the name of the...

You are concatenating the string incorrectly.

Change the last line to:

where CLAIMNO like Convert(VARCHAR(20), Getdate(), 112) +'80' + Right('000' + @operator, 3) + '%'

What is the error you are getting? That may help.

Also, it looks as if you are trying to use Dynamic SQL

If this is a one time export, have you tried going from Progress to Excel/Text/Access/etc. and then going into SQL?

Correct. But.

I prefer three separate triggers (Ugh!) for task such as this. To me, it's easier to maintain. And it's also easier to sort through the...

kwoznica (2/15/2014)

---

Hello all,

Is this thought the optimal way of logging such activity?

what is a more optimal way to perform logging?

Would a separate trigger need to be created for each...