You could decompose it another level and populate the @updated table yourself...

But I agree, better to step back and identify the best way to do what you need to do...

Wonder the UPDATE does not fail too?

At any rate, nothing to do with Upsert or MERGE but yet another partitioned view issue.

Perhaps all you need to do is take that...

Maybe something like this?

DECLARE @rowcount INT;

BEGIN TRANSACTION

UPDATE TARGET

SET TARGET.Value = SOURCE.Value

, TARGET.Attribute = SOURCE.Attribute

FROM @IncomingLogData SOURCE

JOIN dbo.LogData TARGET

ON SOURCE.LogID = TARGET.LogID

AND SOURCE.Timestamp b= TARGET.Timestamp;

SET @Rowcount = @@ROWCOUNT;

INSERT...

I use CLR to create a node type that models the SMO object model hierarchy. My application has been in use since before the vendor supplied assembly with the hierarchyid,...

I believe the guidance is to store the key export and the password in different locations and to store both on site and off site.

How about storing the...

To be honest, it does not really require SQL Server 2008, only the SQL Server 2008 SMO assemblies. However, if you try to target a SQL Server 2008 from a...

Sorry, Not paid and not my intention to SPAM anyone. I was worried about it being over the line but figured I'd at least make a few people chuckle. My...

Well, since the topic has completely shifted from documentation of a server to documenting SQL Server you may want to consider SQLClue. (Please pardon the long winded plug, but seems...

Sounds like a good use for the Health and History Tool to me

http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89

Has a set of canned reports that will show you, hardware, OS patchs, SQL Instance...

see BOL keyword "delegation of security account"

btw: if you extend permissions to [NT AUTHORITY\ANONYMOUS LOGON] then ANY domain user will have the permissions granted provided they connect using a linked...

To upgrade the MSDE that installed with Office XP install on my XP Pro machine I used the command line:

Setup.exe /upgradesp SQLRUN BLANKSAPWD=1

and it installed just fine.

Looking at the...

Pardon for the late post, but this is an interesting thread and I'd like to see it stay alive a little longer.

I've worked with a couple of SANs.

EMC Clarion...

Great article Andy! You make it seem so easy.

One thing I notice with DMO is if there is a

oLinkedServerLogin.LocalLogin = "" user (The Null user you write about) it...

On my Transactional Replication pair I use a DTS ActiveX (DMO) package that wipes out the existing stored procedures in the target database, then copies all procedures (with permissions) from...