Lowell, that fixed it.

I do not understand why it does not work on the other machine.

Perry Whittle (4/7/2012)

---

Why didn't you just put it single user mode and add the appropriate account...

ok, I have another Server that was just handed over to me late Thursday.

I just installed SQL Server & I ran the script on a prior post in this thread...

I reboted and removed the other components, rebooted agoin & started a fresh install.

I found an example of a Merge with the Output Clause.

I want to do something different, capture the @@RowCount of the Number of records affected, The table that the DML...

Could someone please provide me with an example MERGE OUTPUT, INSER, UPDATE & DELETE?

$action

Is available only for the MERGE statement. Specifies a column of type nvarchar(10) in the OUTPUT clause...

System locked up on me and I have a double post. Sorry!

Please reply to:

http://www.sqlservercentral.com/Forums/Topic1279826-392-1.aspx

I reposted and made the question very basic.

Please do not reply to this thread but to the following:

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=lkwvksiaegjxrk55d0ryiq45

bteraberry (4/6/2012)

---

I may be misunderstanding what you're asking, but in the 2nd article you link he gives a nice example of what will be returned by $action in different situations...

The following examples are close but as far as I determine they do not cover update in the OUTPUT CLAUSE:

http://msdn.microsoft.com/en-us/library/ms177564.aspx

http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

They believed me and all agreed on my side recognized that they are not doing things right.

I made several points; about a page of bullet items and it is in...

I have a Stored Procedure that contains a Merge with an OPENQUERY Statement.

I plan on executing this Stored PRocedure in an EXEC SQL Task in an SSIS Package.

I need...

I don't know that it matters as far as syntax but I'm using an OPENQUERY?

I see that you use the OUTPUT CLAUSE.

I'm still looking for a good example?

This is going to be encapsulated in an SSIS Package.

Also, I was just notified that they want...

I watched the video. I was a little distracted.

I'm think I know the basic steps but I'm a little confused on what I have to do.

Thanks.