This will get you the last backup by type:

SELECT D.name, B.type, MAX(B.backup_finish_date)

FROM sys.databases D

LEFT JOIN msdb.dbo.backupset B ON D.name = B.database_name

GROUP BY D.name, B.type

ORDER BY D.name, B.type

This may...

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...