Hi all - finally found the solution to this so thought I'd post it. Turns out they had upgraded the .net driver on the source box; what they don't...

FYI, we finally got some support from Microsoft on this.  They had me reinstall the ASPState database using the scripts that were actually included with the updated .net driver.  At...

All very good information, thank you - I tried the dbcc opentran, and unfortunately there is not a persistent open connection - just ones that start and then are dropped. ...

That is helpful - is there any way to force a checkpoint every so often, from the server rather than through the application?

We assume something has changed, but we don't know what yet.  My inquiry is more along the lines of how transaction logs can be generated like that when it is...

I guess I am wondering too what is "normal" for this situation - do most people delete expired sessions frequently?  Or what SHOULD be done?  I can't find any documentation...

I had never used SQL Profiler before, thanks for the advice - seems like it will give us what we're looking for.

Hmmm, that's really helpful Richard... thanks!  But are you linking FROM Oracle TO a SQL Server?  Am I understanding that correctly?  How do you do that, can you give me an...

Hmmm... well, I know this is going to come up, too.  What about if I need the alpha characters only?

For example, starting in the 4th position, I need to pick...

Great!  Both work perfectly and are exactly what I needed... thanks!

Helps a bit, but the main thing I'm still interested in is if we would have to purchase an additional license if we put it on another server.  I don't...