tsql help

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Select Cols from dbo.YourTable where DateCol between DateAdd(hh, -1, GetDate()) and GetDate()

ishaan99 SSCertifiable Points: 6261 More actions · Answer 2

But what if there isnt any date column in the table. All i need to check is the number of rows inserted in last 1 hour.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

It takes a log explorer to do that (assuming recovery mode is set to full). There are a few reviews on this site for such products.

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 4

If you have a column defined for insert/update you could query off of that....

Good Hunting!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

"But what if there isnt any date column in the table. All i need to check is the number of rows inserted in last 1 hour."

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 6

I think then that you are SOL unless you buy a 3rd party app to scroll through the Tlog OR enhance your system to have an audit trail...

Good Hunting!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

SSC Guru

Points: 294069

September 1, 2005 at 5:21 pm

SOL?

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 8

S@#^%# out of luck ....

Good Hunting!