I'm not sure if one of the database/server triggers can be used for this - haven't looked at this feature too much.  Is this for SQL or AD connects ?

You need to watch out for over zealous security templates in Group Policy which may seek to remove basic rights the sql server service needs. I've had some issues with...

please don't multi-post.

this is the default for msdb - think carefully about what you are asking, do you really need tran logs for msdb ?  As you only take two tran log...

did you change the service account back to the domain account ?  I'd check out the sql error logs they should tell you what is wrong, I figure your domain...

umm .. I can't post the code as there's too much to explain, but my log shipping copes with this, it doesn't require the ability to query the source server...

I'm just biased , brought up on very high performance oltp databases, back in sql 6.5 I was using multiple raid 10 arrays. My last three contracts all have databases...

you also need to check your backup job, I've seen backup jobs which shrink the log, that disguises the fact the log was growing, as well as adding fragmentation. The...

within reason no real issues, if you drop and recreate a clustered index the logging should be around 1.25 - 1.5 times the size of the table.  Or a data...

experience has taught me that the dbid is better than the name in profiler. It's only a quick lookup

select

* from...

the timings are a red herring unless you are absolutely sure both quereis run with a level playing field, so to speak. What's the io difference between the queries?

could you...

I have in several client sites.

oops! sorry Jeff , slip of the brain.

you may need 1204 too - I figure about 80mb a day ( av ) with trace falgs enabled.

I query the underlying tables and grab the dates to avoid these errors .. it takes some querying but isn't impossible!