I've hated horses ever since I had to ride them every day to get to the school bus. It was only up hill one way, but it was through...

You're in kind of uncharted waters on this one.

I'd try just setting up Replication again, as if it were never there. You'll end up with some orphan artifacts on...

Skip the variable and the Execute SQL Task. All you need for something like this is the Data Flow task.

The query you have in the Execute SQL Task, use...

The error message is because you dropped the distribution database before you were done disabling replication. Any particular reason you did that?

Compression is a 2008 feature. Didn't exist in SQL 2005. You can use third-party solutions for that, or back up to a compressed directory/drive. Or upgrade SQL...

Can you modify the proc?

The temp table doesn't exist in that context. It only exists inside the proc. If you want to select from it, you'll need to put the select statement...

Can't help on that. I've never tried to skip a transaction in replication.

The proc doesn't use the Return command to return a value. Thus, the variable is just being assigned the error code, which is probably 0 unless there's a problem...

Something like this:

create table dbo.IDTest (

ID int identity,

EquipmentID char(13) primary key);

go

insert into dbo.IDTest(EquipmentID)

values('ABC-2010-0001'); -- Seed value, to test year-vs-year code

go

create proc dbo.IDGenerator

(@ID_out char(13) output)

as

set nocount on;

set transaction isolation level repeatable...

In the educational methodology I use, we have...

Your first post said, "In 2005, it was returing 1 while in 2008...

First, @return_value is defined as an integer, but you seem to be putting it into a date column.

Second, I'd have to see the definition of the COB proc to tell...

Duplicate thread. Resolved on other copy.

(Angelindiego, for future reference, you don't need to post in multiple forums on this site. Just once is enough. No big deal,...

I'm not clear on what you want to Max or Group By for. Max what?