Pressing F5 does invoke the functionality that "executes the query"...however since you have told SSMS to put the results of the query into a file it has to ask you...

Fun post so far 😛

Just a hunch, but your OLE DB provider for DB2 may not support parameter substitution.

From working with some LASP (Linux, Apache, SQL Server, PHP) devs where...

Added attachments.

TheSQLGuru (3/31/2011)

---

3) no index will be helpful here if you plan on checking 80% of the data in the table (50M/62M) UNLESS the number of email sent rows is VERY...

HowardW (3/31/2011)

---

If the application calls a Stored Procedure that you do have access to, then yes, you can wrap it in a TRY...CATCH block and raise a custom error message.

If...

What Yuri55 said plus scheduling your SP to kick off when SQL Server starts should get you where you want...

Gianluca Sartori (3/31/2011)

---

From your private message:

The first entry for the google search I suggested points...

Please do not cross-post, it just fragments responses.

Direct all comments here: http://www.sqlservercentral.com/Forums/Topic1087179-1632-1.aspx

Not that you won't get help in this forum...but you may have better luck in one of the Reporting Services forums:

http://www.sqlservercentral.com/Forums/Group416.aspx

I looked around for a way to do the update all in one statement and I think it's possible using the query() method on the XML data type column and...

Craig Farrell (3/31/2011)

---

opc.three (3/31/2011)

---

You'll notice that a clustered index was not defined as part the CREATE TABLE statement and I was pointing out that in the absence of a, [explicitly]...

WayneS (3/31/2011)

---

Not so. A table either has a clustered index (clustering...

You said you had already created database objects to hold your data. Please re-read my previous post. If you're not sure what I am asking please read this article: http://www.sqlservercentral.com/articles/61537/

Would something along these lines work?

DECLARE @xml XML = N'<package>

<header>

<recipient>123456</recipient>

</header>

<contact>

<first_name>John</first_name>

<middle_name />

...

Have you looked into tools like Red Gate SQL Data Compare or the Data Compare functionality within Visual Studio 2010 to see if it will do what you want?

If those...