Can I ask what makes you think this will work?

You said nothing about distribution, so here's a link. Check everything:

http://technet.microsoft.com/en-us/library/ms152757.aspx

In addition to what everyone else has already added,...

What error is it giving you?

I'm betting the distributor is still set up. Or the subscribers.

I don't know how you can add an entire job history, but you can check the success / failure of a job and its individual steps by querying against sysjobs,...

You may have to make the query dynamic SQL (stored in a variable) and execute the variable in order to get the Body = @tableHTML part of it working correctly.

Making it a clickable link. @=)

What is your fiscal year? And do you keep track of it in other ways in...

I've never run into an instance where using CAST over CONVERT (or vice versa) has made a difference in code performance. The problem is usually related to the rest of...

OCTom (7/6/2012)

---

Brandie Tarvin (7/6/2012)

---

Someone please explain to me why donut shops insist on placing single donuts in the bag icing side down. I don't want my icing sticking to the...

Another recommendation:

Learn the data, learn the business.

If you know the data well enough to recognize bad data the instant you see it on a report or in an administrative request,...

One thing I strongly advise: Do not take this career path just for the possibility of high pay. If you do not like what you are doing, then the pay...

Before removing any indexes from a production system, it is a wise idea to try removing them from a QA environment and running full-load tests to see if it in...

You cannot use the keyword IN on the "result" side of a CASE statement, only on the conditional side of the statement.

CASE means "please check"

WHEN means "these conditions"

THEN means "this...

So you see more clearly what I'm working with, I've attached a snapshot of my SSIS package with a few sensitive things blurred out.

The job runs and sends one to...