My company has a product called BI Documenter that will document your SSIS projects.

Check it out and let me know what you think

Is there any more information available about the error?

The only problem with that plan is it's not a 2 hours drive. It's more like a 4-5 hour drive. Construction...

I do get what you're saying though.

Thanks for the...

That was actually something we were looking at. If replication wouldn't have succeeded, we were driving it down there. 🙂

Fortunately, in the end, everything worked out.

Exactly! I'm hoping that others learn from my mistakes.

An update on the article. When I wrote this I didn't know why the subscription became inactive. With a little search on google I think I located the problem.

In the...

That's a design decision that should be thought of very carefully. Rolling your own may be the way to go if you do not have time to get to understand...

We get a lot of blocking from one of our departments that manipulate data through access 2000. I believe that it's an application issue.

Something like this..

CREATE TABLE SSNTemp (

 SSN char (10) NOT NULL

)

CREATE UNIQUE

  INDEX [IX_SSNTemp] ON SSNTemp ([SSN])

WITH

    IGNORE_DUP_KEY

insert into SSNTemp

select ssn from yourssntable

delete from yourssntable

insert into yourssntable

select ssn...

No problem.

SELECT @sqlstmt='SELECT * FROM ggg_emp  WHERE date_join  BETWEEN '  +CONVERT(varchar(10),@start_date-1,101)  + ' AND '    +CONVERT(varchar(10),@end_Date+1,101)

should be

SELECT @sqlstmt='SELECT * FROM ggg_emp  WHERE date_join  BETWEEN '''  +CONVERT(varchar(10),@start_date-1,101)  + ''' AND '''    +CONVERT(varchar(10),@end_Date+1,101)...

Show me your query.

select userid, max(lastlogin) from yoursimpletable

group by userid

This is assuming that one row at a time is being inserted. If multiple rows are going in, you'll have to use a cursor

create trigger i_tblErrorLog on tblErrorLog

for insert

as

set nocount...

Have you looked at WITH ROLLUP? That may help..