Viewing 15 posts - 16 through 30 (of 143 total)
Because of the time it takes to review the rows another process may come in and start grabbing those same rows while you are in the middle of your update
Each...
January 10, 2014 at 5:14 am
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...
October 28, 2013 at 4:43 am
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...
October 16, 2013 at 1:04 am
Glad you got it working.
Jody Claggett-376930 (5/1/2009)
In an Execute SQL task I have the following configuration:Result Set = Single Row
SQLStatement = SELECT COUNT(ID) AS CheckData FROM Table_A
Compare these in the...
October 4, 2013 at 4:44 am
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...
September 11, 2013 at 4:50 am
:unsure:
Hmm good point Chris.
Not sure why I posted that.
Good to keep indexes defragmented and statistics up to date though....
September 11, 2013 at 4:25 am
This article by Kimberly Tripp[/url] maybe useful to you.
I'm reading it and the related articles now.
September 11, 2013 at 3:26 am
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...
September 11, 2013 at 3:10 am
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...
September 11, 2013 at 3:00 am
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...
September 11, 2013 at 2:54 am
Hi,
Depending on your criteria you could do something like:
DECLARE @SQL Varchar(MAX)
SELECT @SQL = ''
--SELECT P.Name PubName, S.SrvName SubScriber, S.Dest_DB
SELECT @SQL = @SQL +
'sp_reinitsubscription @publication = '''+P.Name+
''', @subscriber = '''+S.SrvName+
''', @destination_db = '''+S.Dest_DB+
''',...
September 11, 2013 at 2:45 am
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!!
September 10, 2013 at 8:57 am
Check out : http://ola.hallengren.com/
Learn the and understand the code.
When you do, you'll have no worries with these questions again.
September 10, 2013 at 7:42 am
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...
September 10, 2013 at 7:30 am
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')...
September 10, 2013 at 6:42 am
Viewing 15 posts - 16 through 30 (of 143 total)