Setting up email notifications for failed jobs is very easy. See here[/url].

Adding the failure reason and message is a bit more complicated. Instead of relying on standard notifications, you should...

This great article[/url] by Waye Sheffield will help you.

Regards,

Gianluca

Duplicate post. Original thread here http://www.sqlservercentral.com/Forums/FindPost1183514.aspx

Homework?

This should do:

--2) insert into that new #tmpTbl1 a row of values returned by executing a separate stored procedure

INSERT #tmpTbl1 (val1, val2, val3, val4 )

EXEC SP2 @param1=123

--3)...

The error message says it all: you cannot update views that reference more than one table.

In order to be updatable, a view must comply to some restrictions, that you can...

They look like XA transactions.

Do you have an EMS server around?

Here's an alternative (quite obscure) solution to a similar problem:

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

Peso (Peter Larsson) is incredibly clever and his code is not for everyone...

Ok, we're almost there.

Here is your code formatted as recommended in the article.

CREATE TABLE #E2E_TIMESHEET_VIEW (

PROJ_UID UNIQUEIDENTIFIER,

ASSN_UID UNIQUEIDENTIFIER,

...

GSquared (9/27/2011)

---

Looks like The Thread may have killed the rest of the forums.

The Active Threads link is only showing 5 other discussions.

(Probably my fault for going political in here. ...

So, any comments?

Lynn Pettis wrote a geat article on this subject:

http://www.sqlservercentral.com/articles/T-SQL/67898/

I suspect you didn't read the article, did you?

There's no way we can help without the information I requested.

If you really want us to help you, help us in the...

It seems to me that you can't change the client/server setting of the cursors, can you?

If you're bound to using server side cursors, the only thing that comes to my...

1) Install \x86\Setup\x86\SQLServer2005_BC.msi from the installation (Select DTS 2000 RunTime and SQL-DMO).

2) Download and install

http://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_DTS.msi

3) Copy SEMSFC.DLL, SQLGUI.DLL, SQLSVC.DLL

From C:\Program Files\Microsoft SQL Server\80\Tools\Binn

To C:\Program Files\Microsoft SQL...