The with INIT should overwrite the previous backup. Not sure why it doesn't work here. I take a different approach. I make a new filename everyday, so I have the...

They are the same. Setup SQL Mail and mark the job to notify you when it fails. You set your email up as an operator.

The trigger knows which table because it can only be fired from that table. IF you're trying to write a generic trigger you can copy to every table, you can...

Nigel, this is definitely some network problem. It does appear you are listening on the port, perhaps a router is blocking on one end?

You need to spell this out.

col1+col2+col3=subtotal1, col5+col6=subtotal2, (col1+col2+col3+col5+col6) * taxrate=grandtotal

You can use a CASE statement to help roll things up. At least horizontally.

select

     case when fieldA < 10 then 1 else 0 end 'less than 10'

     case when fieldA >=...

I think you probably want to control this better and use a table of some sort in your db to store the backup locations and file names. Then let the...

Interesting survey. It would be great if the diagrams were expanded to include more modeling features. Hard to get $$ for ERStudio (my choice) or ErWin.

Take the survey!

When a job starts, SQLAgent connects to SQL Server, just like you would with QA. If there's any hiccup, which sometimes can occur, the job fails. You can set a...

Your image isn't appearing, but can you show a few rows of the table, like 4 or 5 and then what you want it to look like? Not sure where...

No. Your best bet would be some third party utility to do this or a control that you can pass a field to. You can loop through the table and...

No, because of the security implications, only sysadmins can run profiler.

What does this do that a view doesn't do?

I'm guessing the .cmd isn't getting the substitutions into the parameter of the odbcconf file. Since they are quoted, not sure if the parser correctly substitues these.

Haven't found any other ways. It's a bug.