Lynn -- thanks for that tip! fyi, I actually scraped that proc (a "smart reindex" proc) and have been using it for about 3 years now.

Do you guys have...

Gail -- awesome find! yes, the vendor mandated we set COLLATION to: Latin1_General_BIN

using this command: I validated the COLLATION as Latin1_General_BIN

So I modified the 1st...

Actual ERRORs:

Msg 137, Level 15, State 2, Procedure sp_MyProc, Line 195

Must declare the scalar variable "@Online".

Msg 137, Level 15, State 2, Procedure sp_MyProc, Line 197

Must declare the scalar variable "@retry".

Msg...

--Here's the proc.. compiles in 2008 R2 (ent edition), does not compile in 2012 w/ sp1 (Ent edition)

USE [Admin_DB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[sp_MyProc]

@databasename nvarchar(256)...

thx for helping me out here.. Our code is proprietary therefore I created a short example in my original post. The comma is actually in my "live" EXEC portion.....

Also -- Check the SQL Server ERROR LOG to verify your DB's are NOT "IN RECOVERY" state -- specifically the distribution DB, as this will delay the job scheduler...

This seems to work:

use msdb;

GO

select

d.jobname

,d.servername

, avgDurationMinutes=avg(d.durationMinutes)

, daydate=convert(char(10),startdatetime,101)

from (

select

jobname=j.name

,servername=server

,startdatetime=

CONVERT (DATETIME, RTRIM(run_date))

+ (

run_time * 9

+ run_time % 10000 * 6

+ run_time % 100 * 10

) / 216e4

, durationMinutes=

(CAST(SUBSTRING((right('0000000' + convert(varchar(7), run_duration), 7)),1,3)...

Anyone have a "working query" to render AVG run_duration for a specific Jobname in SQL 2008 R2? I cannot seem to get this query working:

select ...

John - thanks. Right on w/ your reply. The restore created the FG. Appreciate your feedback.

Andrew - thank you. Using your link, I successfully tested this.

Using transactional replication (SQL 2008 R2 sp2 to SQL 2008 R2 sp2, I set up a publication...

AJB, thank you very much. This is great. (apologize for the bad date formats as I hand entered these from a PDF doc) Thx Again!!!

I also have a publication transactionally replicating 100 articles (some very large) and the need to DROP 1 small article.

Using SQL Server 2008 R2, do I need...

Dan - thanks for the expediant reply. I've put up a few 2-node clusters over the years ( a dozen or so ) but never installed just the one...

-- This 4 step resolution worked:

--************************************************

-- SQL 2008 R2 -- Change an Article's Horizontal Row Filter

--************************************************

/**************

4 steps required to alter this Articles Horizontal row filter:

1....

thanks for this feedback.. yes, were a few years into this DB's maturity.. heavily used so I'll most like alter the column's collation attribute based on this link:

http://msdn.microsoft.com/en-us/library/ms190920(v=sql.105).aspx

which entails...