Just added the tracer for today there does seems to be a lag and a lot of undistributed subscriptions waiting.

More to investigate now.

Thanks i will set that up on a test system and see what the ramifications are when transactional replication is updating the reporting database.

Thanks for you time.

Yes you must update statistics and do re-indexing as you would on the primary.

(Thanks i thought i should too thanks for clarifying)

No need for the async update stats but you...

Roles ...yes sometimes i set this up in test then manually do in production - this surely would be a good script.

Sure is hard agrees..but i see create indexes ...is this a index rebuild script?

In a view you can't have variables only in SP.

What you could look at is CTE which is kind of like building a view inside a sp.

Example

WITH ProductAndCategoryNamesOverTenDollars (ProductName, CategoryName,...

sp_help_revlogin gets all the logins.

Roles come across when you move databases over.

You have to shutdown the server after u change tempdb so that you know it is picking up the right location...best to do when no one on there.

You have to right click on db2.tbl and give the user rights to read this table.

Perhaps use a ROLE and just give select rights to the user.

Put user in...

I couldnt see why you want move tempdb to Disk D unless you are out of space on C.

Moving tempdb to difference LAN Partitions is whole another subject but since...

Code i used was CTE

WITH CTE AS (

SELECT EMPL_ID, effective_dt, ORG,

ROW_NUMBER() OVER(PARTITION BY EMPL_ID ORDER BY effective_dt DESC) AS rn

FROM TABLE)

INSERT INTO...

Sure is easy when you know how......thanks guys i appreciate your quick turn around too.

Have a good night.

impressive ........it worked, can you explain the logic it is doing not used this before. OVER PARTITION

I have not tried the link method.

The only message i get is invalid pwd.

I have to delete the logins ...

Is there a way to delete all the logins where login...

Grasshopper...i have done this

http://support.microsoft.com/kb/918992/

SP_HELP_REVLOGIN and also ran the fix orphans too.