Each...

Solved it.

The Queue Reader agent is only used in snapshot or updatable transactional replications.

I just deleted the job and emptied tables MSqreader_agents & MSqreader_history from the distribution database. Finally I...

I also encounter this now and then, but with not any specific regularity.

EXEC sp_RefreshView '<View that reverences a linkedserver table>' will also allow the view to be used.

Has anyone encountered...

Glad you got it working.

Compare these in the...

Thanks for the link Jeff.

:blush:

Bit beyond me at the moment though.

I failed the "Who This Article Is For" section.

Never heard of Adjacency List or Nested Sets.

If / when I...

:unsure:

Hmm good point Chris.

Not sure why I posted that.

Good to keep indexes defragmented and statistics up to date though....

This article by Kimberly Tripp[/url] maybe useful to you.

I'm reading it and the related articles now.

Are you able to increase the size of TempDB or add extra data files to it?

Correct me if I'm wrong people but, the Proccache is stored in memory and not...

I would think just creating a new subscriber to the existing publication is better.

That is, if the articles being published are what you want on the 3rd subscriber.

If it is...

Hi,

Instead of just deleting the records on the publisher, insert them in an archive table on the subscriber then do your publisher cleanup.

Create a view on the subscriber with both...

Hi,

Depending on your criteria you could do something like:

DECLARE@sql Varchar(MAX)

SELECT@sql = ''

--SELECTP.Name PubName, S.SrvName SubScriber, S.Dest_DB

SELECT@sql = @sql +

'sp_reinitsubscription @publication = '''+P.Name+

''', @subscriber = '''+S.SrvName+

''', @destination_db = '''+S.Dest_DB+

''', @invalidate_snapshot =...

Thanks Jonathan!!

This really made things a lot clearer for me.

Don't know if there are better techniques now days, but this one's a keeper!!

Check out : http://ola.hallengren.com/

Learn the and understand the code.

When you do, you'll have no worries with these questions again.

Looks like a job for a recursive query.

Make up some sample data so we can help you out. (Create table + inserts + clean up)

Or you could check out the...

Here's a script to reproduce the error and correct it.

CREATE SCHEMA Test1 AUTHORIZATION Guest

GO

CREATE SCHEMA Test2 AUTHORIZATION dbo

GO

IF OBJECT_ID('Test1.Tmp1') IS NOT NULL

DROP TABLE Test1.Tmp1

CREATE TABLE Test1.Tmp1

(

ID INT IDENTITY,

CharVal Char(1),

)

IF OBJECT_ID('Test1.Tmp2')...