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!

Thank you Lowell, that's brilliant.

I *really* must find some time to bone up on XML.

Some improvement, but still got one 3709.

I'd *love* to understand what's causing the error.

No joy, still getting between 0 and 2 3709's / day, out of 30-40 executions.

I've now added a loop to check the state of the connection object, it cycles 10...

9:15 and all's well with the explicit connection object... 🙂

We'll see what happens next week.

Well if I'm understanding this -- and to be honest, I'm on very thin ice -- I can't check the state of the connection in my original code as suggested...