Viewing 15 posts - 526 through 540 (of 1,158 total)
Lots of options here but it depends on your business logic so you've got ask a few questions.
How likely is it that both records will be updated at the same...
March 2, 2012 at 2:59 am
bhaveshp.dba (2/24/2012)
Create table #temp
(year varchar(1000)
Year
2012
2010
@UptoMonth = 1 or 2 Or 3
How can I Update This table with
2011-@uptomonth-01
2009 -@uptoMonth-01
If @uptomonth...
February 24, 2012 at 12:03 pm
SQLRNNR (2/24/2012)
MysteryJimbo (2/24/2012)
SQLRNNR (2/24/2012)
Merging the two queries (since SSIS subtypes do not use dtexec)
SELECT DISTINCT j.name
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps js
ON j.job_id = js.job_id
WHERE js.subsystem = 'SSIS'
OR js.command LIKE '%DTEXEC.exe%'
You...
February 24, 2012 at 10:24 am
SQLRNNR (2/24/2012)
Merging the two queries (since SSIS subtypes do not use dtexec)
SELECT DISTINCT j.name
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps js
ON j.job_id = js.job_id
WHERE js.subsystem = 'SSIS'
OR js.command LIKE '%DTEXEC.exe%'
You beat me...
February 24, 2012 at 9:59 am
I would use something like this.
select j.name, js.step_name, js.command
from dbo.sysjobsteps js
inner join dbo.sysjobs j on js.job_id = j.job_id
where command like '%DTEXEC.exe%'
February 24, 2012 at 9:53 am
Kwisatz78 (2/24/2012)
February 24, 2012 at 8:39 am
DesNorton (2/24/2012)
REM -- Declare the variables.
SET Publisher=PPWAPPSRV01
SET Publication=VHS
SET PublicationDB=HBH_VHS
SET PublisherLogin=sa
SET Publisherpass=*****
SET Subscriber=TESTSQL\VHS
SET SubscriptionDB=VHS
REM...
February 24, 2012 at 8:17 am
Thats where I believe it is done. I'm wondering if by overriding the host in sp_addmergesubscription its done something different. Have you tried it without that parameter?
February 24, 2012 at 7:33 am
Is the server register in the publisher?
exec sp_helpsubscriberinfo
Also check for an entry in sys.servers as it should have one on the publisher
February 24, 2012 at 7:12 am
It doesnt matter which method of backup used since this is manual backup/restore when initialising from backup.
http://msdn.microsoft.com/en-us/library/ms147834.aspx
Is the upgrade process out of your hands completely?
February 24, 2012 at 6:43 am
Have you tried this in a push replication setup?
I did find this on technet as well which suggests its security related in someway but the wording to me suggests its...
February 24, 2012 at 6:40 am
Also, have you considered initialising from a back up or using a no-sync initialisation?
February 24, 2012 at 6:25 am
Where is your bottle neck?
If it is the logreader the only way around this bottleneck is to create another database and publication; data could be fed into here using triggers,...
February 24, 2012 at 6:24 am
Have you considered alternative high availabilty solutions such as mirroring? Or is logshipping you method of choice.
Mirroring would provide an easier failover mechanism.
Either way you will need to consider...
February 23, 2012 at 8:05 am
Elliott Whitlow (2/21/2012)
February 22, 2012 at 1:58 pm
Viewing 15 posts - 526 through 540 (of 1,158 total)