Peter Brinkhaus (11/3/2009)

---

There is an XML file SqlCommonObjects.xml with a description of all the built-in functions. Its default location is C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlToolsData\1033. Maybe you can try to read...

I was trying to solve this today.

Changing setting @query_result_separator to a tab enables Excel 2003 to read that on my computer.

If your target is another app, then you might need...

Yep.

I'll stick to something like that then 🙂

Thanks for the advice.

David (12/8/2008)

---

I think personally I would convert the sql in the jobs into stored procedures.

Another option is to hold an override date in the registry and then use...

No, sorry, I'm not allowed to do so.

The queries I've looked at are mostly selects with a few joins and time columns that are compared...

David (12/5/2008)

---

If your jobs just call a stored procedure to do it's work then you could add a parameter to the procedure which is the "rundate". If the parameter...

Thanks for the replies guys.

Yeah, I know about the retry parameter, but I'd rather avoid using it, because there are many jobs on the server we have and some of...