In all cases (Events) where you have both a starting time and an ending time, it shouldbe true that Duration = EndTime - StartTime.

If not, then something is...

Heh.

And, I suppose that walking will get you where you need to go.

However, not as fast or as easily as you...

heh.

Select victim as [Culprit] From [Witch].[Hunt]

I've worked on clusters almost as long as they've existed (over 20 years) and although I have heard many vendors say that when they wanted make an add-on sale, I...

Glad I could help.

And I wouldn't use .NET to do this (at least not based on the requirements so far).

How I would do it:

1) Implement DDL triggers/events on MainDB to catch the desired changes.

2) Use Service Broker to SEND the event XML to an EndPoint on LocalDB's server.

3) Use...

Well the two previous responses are actually posting the same query, which would have been obvious if not for the unusal formatting of the second one.

Two points:

1) The claims...

Have you tried what GSquared suggested? I beleive that this (putting TRY..CATCH in the inner execution) is on the right track.

What I have ended up doing in my toughest...

It depends on your actual source data constructs and content, but this should be pretty close:

CREATE function dbo.fnGetClassificationRankingByCode(@code varchar(10))

Returns TABLE

AS

RETURN ( Select i.SysID, Code, MAX(Name)

, MAX(Case When...

No problem.

Sorry, but it is right. I've been using this logic for over 30 years. ...

Not sure about the rest, but this is surely wrong:

I believe that this should be:

begin catch

...

Or you could avoid the use of Cursors and Loops altogether:

Declare @sql Varchar(max);

Select @sql = ''

Select @sql = @sql + '

DELETE FROM [' + TABLE_CATALOG + '].[' + TABLE_NAME...

Please post the code that you already have.