You could do something like this:

CREATE TABLE #someTable (...columnlist...)

INSERT #someTable (...columnlist...)

EXEC #someProcedure(...paramlist...)

SELECT *

FROM #someTable

It's not exactly what you asked, but could be a workaround.

I suppose the notification doesn't fire because the instance is not running during the failover.

Really? Typically VBScript files are named with .vbs extension.

in another windows server where SQL is not installed,i need to schedule these job...

Take a look at this article on how to post performace problems[/url].

If you post all the information required, I'll be glad to help.

You could take a look at this article[/url] and see if it helps.

Ninja's_RGR'us (10/7/2011)

---

So you...

http://www.sqlsoft.co.uk/sqljobvis.php should do the trick.

It's free and easy to use.

select *

from master.sys.linked_logins

where server_id = [your server id]

returns the logins you defined for the linked server.

The rows with local_principal_id <> 0 are actual local logins you can find in...

Grant Fritchey (10/6/2011)

---

For additional methods of dealing with parameter sniffing, check out Chapter 38 of the SQL Server MVP Deep Dives II[/url] book. It covers things not included in the...

The question stands: why not a linked server?

Great! Congrats.

You could post the working code here, so that others with the same problem can benefit from your solution.

I understand what you're trying to do, but I still don't know how you want it done.

You posted some sample data, now you could post the expected output based on...

OK, here's another way:

http://spaghettidba.com/2011/10/05/formatting-dates-in-t-sql/

donato1026 (10/5/2011)

---

Gianluca Sartori (10/5/2011)

---

Based on your description of the problem, I don't think that db_mail is the right tool for this.

You'd better generate HTML reports with a reporting application (such...

Based on your description of the problem, I don't think that db_mail is the right tool for this.

You'd better generate HTML reports with a reporting application (such as Crystal Reports...