Function code below.

Specifically, the error thrown is:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'Clientname', table '@tRS'; column does not allow nulls. INSERT fails.

The...

Lol! Fail as in throws an error. (But for my users, it's the End. Of. The. World.)

The cross apply returns a table, but the table has the columns defined not...

WHILE: Agreed. However, this sproc is called for Inserts and updates an average of 10x/day, so the perf hit is probably not noticeable.

As for the cursor, there are 2 related...

Sean, I'd be happy to hear any suggestions re: perf improvement.

The value is passed in the call to the sproc:

DECLARE @nKeyword_IdVarINTEGER = 120375

DECLARE @nErrorVarINTEGER = 0

BEGIN TRAN New_Tran

EXECUTE @nErrorVar = dbo.wadw_keywords

@cActionArg = 'D',

@nKeyword_IdArg = @nKeyword_IdVar OUTPUT

So it was evaluating to...

OMG!!!!!!

Yikes. That's been in prod for years.... which means that sproc is never called by the application.

Thanks John! Good eye!

OK, Here's the DDL for the 2 tables in question (minus some irrelevant constraints).

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[KeyWords]') AND type in (N'U'))

DROP TABLE [dbo].[KeyWords]

GO

SET...

??? Maybe I didn't get enough sleep last night, but... I don't believe it should be possible to provide sample data to reproduce this scenario.

To paraphrase my post, "I'm getting...

Logon triggers might be a solution, have a look.

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

You could write something in Powershell to cycle through the procs and functions, comparing source and target versions, and updating as needed.

Well it took some looking, but I found out to do it. With a couple of minor mods , it works!!

The gotcha is that a File Folder link is an...

As far as I can tell, they're shortcuts stored in my c:\users\...ethood folder, which I can access in XP, but not in Win 7 even running Windows Explorer as Administrator...

Ha ha! We're just getting to Win 7. By the time we're ready to upgrade, I'd be surprised if it's still...

Hi Tony,

I did come across that one, but no, that's not what I'm after.

The one I want is, in Win 7, right click on Computer, Add a network location.

Thanks.

Close enough for rock and roll 😀

Thanks Bruce!