Thank you Sean....

I'd've changed the * before it went to production....too many years of Access to not to. 😀

Thanks for the output shortcut too!

gdr

Hi Sean,

Thanks for the "where-to-look" directions. I added a temp table, populated it using INSERTED.ComputerPKID INTO @MergeOutput and then was able to SELECT it out to the Output parameter, @NewCompID....

I came up with the answer.

Turns out the original code in my first post, does work, but only for the dbo schema. It does not "automatically" see any properties of...

Sorry, this should have been posted under SQL Server 2005.

Wow, I forgot all about this.

Turns out it was a very easy fix. I changed the Output parameter from AddWithValue to Add (not certain that that really did anything) but...

Thanks, but nevermind. I figured it out last night. I had to cast $property.NumberOfProcessors and $property.TotalPhysicalMemory into [Int32]$property.NumberOfProcessors and [Int64]$property.TotalPhysicalMemory. Silly datatypes anyway.

Thanks.

fyi

Attached is a text file of the dynamic sql I ended with and it works very well.

Thanks again.

That sproc I already did know about from SQL 2000. I'm trying to get all my old scripts updated (me as well), saw the CREATE LOGIN and tried to use...

Thank you.

I didn't know that. I'll go with a dynamic sproc then.