Nice.  Had not come across that table in msdb...

Well if I can ever persuade the wife that moving to the States is a good idea, then yes, I will post my cv (sorry, resume!) to the job postings!

as well as indexes, make sure your stats are up to date on the slow server.

Yup, it's possible.

We have a 3rd party tool which has all of the stored procedures encrypted.  Aside from finding a decryption tool, it was my resource to finding dependent tables,...

We use sourcesafe too.

I have heard of the new team edition from Microsoft.  I've not used or seen it yet, just glanced over an advert in a magazine.

http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx

You have no backups!??

The only way (I know of) to backup segments of a database will mean a change in your database architecture. ...

By outside system call, do you mean a front end application?  And if so, does this front end application call some stored procedures and you are trying to restrict access...

Well the obvious answer is to look on your backup volumne to see the size of backups!!

However, I assume you mean going beyond the number of backups on disk or tape? ...

Hi there,

Just a quick thought as I have had a similar occurance on scheduled jobs in general.

Althought the scheduled job is enabled, when you click on the schedule tab, is...

Can't say I have seen an internal datastamp against a row.  Maybe there is something in DBCC PAGE but this would be an absolute nightmare to extract...if possible at all.

Just to piggy back on Colin's response.

Speaking to MS engineers, they gave me a guidline of 2ms is excellent read times. 10ms is not very great and 15 or above...

Hi,

Yes this can be done.  Nice bit of complex t-sql!  I don't have time to knock any together now with it being 7pm on a Friday and the wife expecting...

Yes you can.

But bear in mind that when you restore msdb, you may get all kinds of DTS error messages!  I did!

I ended up scripting all my jobs to my...

Must admit, I have not tried this.

I found this link...I only skimmed through and by what I glossed over it seams its a "feature"!

http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp

Are you saying you can't see host name in the column list or is the host name blank?