We have two tables with triggers already on them. Each table has three triggers, two of which are "Instead of" triggers. Can we still do CDC on these...

It has LRU'd out of memory cache. That's why you cannot find it anymore.

No, it returns zero. The FK appears to be working. Remember the process is like this:

ParentTable ChildTable ...

Excellent, thanks.

Jonathan,

What about turning the blocked process threshold off when you are done?

Jon,

How about if I just want a normal blocked process report trace (without the XML). Would you have a template (or column settings and filter) you recommend?

Did you run column statistics? Also, don't forget to check the index, table, and file fragmentation. Diskkeeper or another third party tool is good to defragment database files...

No, you are missing the point. Apparently, this application does some sort of compile on statements saved to a table to validate them, albeit, before use. The question...

I have problems with getting it to run. I am getting errors on the single quotes (Unicode probably). Is there an easy way to fix it?

Error on line 285 cursor_documentation 'already exists'

Failed on line 311, Invalid object name 'sysproperties'

I see, you still have to run counters. But our clients often refuse to do that. Is there any other query that can yield TPS without running counters?

Yes, it is relative. Steve, do you know of any TSQL commands to get the TPS?

Running SQL Server on a virtual box (particularly production) is not a good idea. You can get into real trouble. In the real world, none of our clients...

Well, I have a LiteSpeed backup and no LiteSpeed program. I have Red Gate software and SQL Backup will not even touch it. Any ideas?

Do you know of any file converter program that will convert a litespeed backup file to a format that RedGate will recognize and use?

Joe