We wouldn't expect you to put code on your server without knowing what it does. But you want a specific ability to email results of the run of checkdb....

That would be the easiest solution.

matt6749 (7/30/2014)

---

Well, after a crash course in log files, thanks to everyone here, here's what I believe I have to do:

My hosting company limits my combined db + log size...

You can download a script here that will provide a pretty decent security audit report for you.

http://jasonbrimhall.info/2010/03/19/security-audit/

This script works pretty well.

http://spaghettidba.com/2013/02/27/dba_runcheckdb-v2012/

Gianluca coded it to send results via email as well.

breakfast

Evil Kraig F (7/30/2014)

---

If you're there at that moment, and the threads are active, yes, they're easier to determine. Wait a few days and you wouldn't know the difference...

C'est a vous a decider.

Lynn Pettis (7/30/2014)

---

SQL Guy 1 (7/30/2014)

---

Active Service Pages

Application Service Provider

Also googled:

Appalachia Service Project

Association of Software...

I have heard EMC say that about defrag and I have shown them the difference.

You may have a file queue issue.

Sum the data retrieval and data render time and subtract...

If your data retrieval and rendering haven't changed, I would suspect the network or destination server to be at fault. How is the space and fragmentation on the file...

Trying to set like that will not work.

e.g. Set @ClientID in (...)

Where is the source of this data?

If it is coming from a database, you can use a select instead...

You cannot convert from tinyint to uniqueidentifier.

You will need to rewrite your code to accept the correct data types or change the data type in the table.

Is this thread of any help?

http://www.sqlservercentral.com/Forums/Topic1279635-266-1.aspx

Let's just call a spade a spade. Yes my comment was less than mature, but I...