I don't know if this will help much, but maybe to narrow the problem (and hopefully someone else will jump in):

--Try querying a table you know doesn't exist - see...

You need to create an operator.

In SSMS, open the SQl Server Agent and you'll see an operators folder there. You can only select one operator for the email in...

I've used

DECLARE @DUMMY int

and that works.

You could also use IF NOT EXISTS and skip the else completely...

I think you picked the wrong model - I don't see the Mr. Fusion attachment. Certainly you wouldn't want one without that!

Chad

Thanks guys! I had this same issue again today and couldn't figure out what I had done last time to fix it. Your posts put me on the...

jens.fache (5/6/2009)

---

This Error appears if there are somehow not serializable characters in the sql statement. f.e {CR}{LF}. You may run into that by pasting the query from an external editor.

Although...

Actually... this is how it works by default. The person...

HA HA!

I now have a new tag line for my IM account (hope you don't mind).

Chad

I thought that SQL Server maintained a "logical file", but the OS maintained the "physical file". If you start with a small mdf file that grows in small chunks...

Crud, I missed it. This is good to know if you have automated maintenance or admin scripts though. I guess if your scripts set up jobs on new...

Maybe Chief People Officer? http://dilbert.com/fast/2009-11-21/%5B/url%5D

😛

Chad

LMSSCTFY: http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

😛

Chad

BitBucket and Lynn,

I'll throw my hat in the ring in your favor. I can't argue as eloquently as Lynn, but I'll say this - you are absolutely correct. ...

I've come a long way since this old post. I think I was a 15 point grasshopper at the time.. 🙂

That could present a problem. In my case, the trees are more deep than bushy (typically), but a change near the top would result in a lot of change...