I think Notification Services can do that.

You have to go to BIDS to build SSIS packages, except maintenance plans. That's why you're seeing the maintenance plan options, but not anything else.

JohnG (8/28/2008)

---

Re:

I'm afraid I don't understand the complaint here. There are solutions to get the end result you want, with the error-protection you want. They are easy...

I'm afraid I don't understand the complaint here. There are solutions to get the end result you want, with the error-protection you want. They are easy to implement,...

In a job, you can use "bare naked SQL", without procs, if you want. An SQL task in a job will do any SQL you want. It's generally...

I have 2005 and 2008 both running on my desktop machine right now. Just as different instances.

You can't actually make them mandatory, but you can add something like:

create proc MyProc

(@MyParam1_in datatype)

as

if @MyParam1_in is null

raiserror('Null values not allowed for MyParam1_in', 16, 1)

...the rest of the...

I agree with Barry. Separate by function and by need. Makes it much easier to modify/debug later.

I suggest SSIS. It can do that kind of thing quite easily.

The idea of the "Set First" and "Set Last" columns is that they are the first and last records in each set.

Once you have those, what you need to do...

Jeff Moden (8/27/2008)

---

Simon,

Now that Gus has replied, it's very good forum etiquette/good practice to let him know if it worked or not. If it didn't work, explain why with...

I got asked this same question as an interview question. I was able to describe a covering index, but I've never heard of a "covering query" before. I'm...

I don't know of a major standard. A few guidelines, like don't use reserved words in the table name, sure, but no real standards.

I use CamelCase for table names,...

You have to place the CTE first. Like this:

declare @XML XML

;with CTE as

(select 1 as number union all

select 2)

select @xml =

(select max(number) as maxnumber

from cte

for xml raw)

select @xml

Does...

The execution plan will sometimes give it away, but the best way I know of to tell is to look at the code and see what it's telling SQL to...