huff

please post the exact query you are using.

If it is saying it can't find the proc, try calling it with three part naming (db.schema.proc).

Well it did say that it...

I second the motion.:-D:-D

This query is fairly quick. If you need to know the success/failure of your jobs and you have that much history to comb, you will need to run a...

Hopefully you will have the backups scheduled through an agent job. If you do, you can report on job history to find if a backup job completed successfully or...

Can you provide the DDL for the personphone table?

While running your backup across the network, get a netadmin to run wireshark and capture network activity between the host and network share. This is to try and rule...

If adding the parenthesis as suggested is still not providing the accurate number of records, please post sample data and structures so we can recreate and test.

It would only be applicable if the SQL service had been restarted.

Here is a short tutorial how to get the query results via email.

http://jasonbrimhall.info/2011/08/15/send-dbmail/

Jack Corbett (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

Revenant (12/29/2011)

---

Stefan Krzywicki (12/29/2011)

---

Revenant (12/29/2011)

---

Brandie Tarvin (12/29/2011)

---

Question for those of you commenting on external drives. The few times I have tried it (both on a local...

Thinking of country music, I thought of a different...

Brad Paisley

I was about to suggest sentrigo - they have shown a bug in SQL that shows the SA password in clear text. But they are now a part of...