Viewing 15 posts - 256 through 270 (of 338 total)
Hi ... I have checked the permission for that account .
In the SUBCRIBER , Security folder -> Login -> that account is there ( as sysadmin )
and in...
November 4, 2014 at 7:24 pm
FYI : Btw I have just tried to login into SQL using SQL Authentication ( [domain\REPLSNAPAGENT] into SUBCRIBER but it failed
November 3, 2014 at 7:58 pm
thank you for the response. Appreciate it !
so when I created the publication , I use Process account ( [domain]\REPLSNAPAGENT) and when I created the subcription I also use the...
November 3, 2014 at 7:33 pm
thank you for your kind response
I was just checking the sql agent in subcriber and it is STOP ( status : DISABLE ) , but in publisher it has...
October 21, 2014 at 6:29 pm
opc.three (10/8/2014)
That's the intent. From http://support.microsoft.com/kb/2958696This update contains hotfixes for issues that were fixed after the release of SQL Server 2008 SP3.
Oww thanks a lot for your response...
October 8, 2014 at 8:08 pm
Steve Jones - SSC Editor (10/6/2014)
October 6, 2014 at 10:16 pm
WhiteLotus (9/30/2014)
I have an issue with the Replication … It shows up error saying :” Replication – Replication Merge Subsystem: agent failed. The merge process was unable to create...
October 1, 2014 at 7:29 pm
SQLRNNR (9/29/2014)
September 30, 2014 at 12:38 am
Shawn Melton (9/25/2014)
With a SQL Agent job step you are out of...
September 25, 2014 at 10:58 pm
Grant Fritchey (9/25/2014)
Wison (9/25/2014)
you can use profiler on third server to Monitor the sql statements which cause the CPU high.or
get the sql statements from the DMV.
Use trace or extended...
September 25, 2014 at 8:05 pm
DBA From The Cold (9/23/2014)
Read through the document and see if...
September 23, 2014 at 7:39 pm
SQLisAwE5OmE (9/16/2014)
Maybe its only shrinking 1 GB because that's all the free space available.
If you still want to shrink, take log backups and...
September 17, 2014 at 1:49 am
Eirikur Eiriksson (9/15/2014)
WhiteLotus (9/14/2014)
Hi All ,How to disable and enable the store procedure?
cheers
Quick question, by disabling it do you mean make it do nothing, make it disappear from the user's...
September 15, 2014 at 12:49 am
karthik babu (9/15/2014)
Better use the sample code below..REVOKE EXECUTE ON OBJECT::dbo.StoredProcedure
FROM LoginName;
GO
Dont u think it is the same like : uncheck the GRANT and Check the...
September 15, 2014 at 12:25 am
Viewing 15 posts - 256 through 270 (of 338 total)