Viewing 15 posts - 1 through 15 (of 53 total)
How about fixing the tools broken by introducing SSMS? Remember in Enterprise Manager how easy foreign keys were to setup? For compound keys we need to see these on screen,...
February 3, 2017 at 2:40 am
Little confused by your reply?!
July 15, 2014 at 5:09 am
I hope this is someone posting on your behalf - your sabbatical will be gone in a flash otherwise! 🙂
I have tidied this mornings email so I...
July 15, 2014 at 5:04 am
david.john.gilligan (6/20/2014)Are you logging IP addresses also? Any help/commonalities there?
I assume you are referring to SSC logging IP? I would imagine they are as they as they...
June 20, 2014 at 7:37 am
I can thoroughly recommend the Synology - lovely piece of kit and yes I have a pair of WD Red drives (3TB). I use it as a hot backup, music...
December 13, 2013 at 5:29 am
Right I can manually run Reinitialize All Subscriptions, Mark and Create New Snapshot in SSMS which refreshes the data (snapshot) and resets the identity ranges if required, but running...
July 19, 2012 at 4:16 pm
Right more on this. It appears the target database was corrupt. It had remnants of snapshot replication that had been removed. I have run the exec sp_MSUNmarkreplinfo 'Table_Name' on each...
July 19, 2012 at 2:36 am
Not sure if this will help but found these on SP3 fixes today - not sure on versions of your subscriber.
959023 (http://support.microsoft.com/kb/959023/ ) FIX:...
July 16, 2012 at 2:02 pm
Just re read in BOL that filters are Static in transactional replication (nice and clear on the 2012 version) - am now trying to set the subscription to dirty with...
March 29, 2012 at 9:53 am
Hmm - sorry oversimplified my query - that example should work normally. Actually the "Can_Replicate" flag is stored in a seperate table.
March 29, 2012 at 2:47 am
Of the 80 sites we support, we still support SQL 2000 (of the fun of Enterprise Manager) although the majority of instances are shared between 2005 and 2008/2008R2 (yay -...
October 21, 2011 at 2:22 am
Wow - what a reminder. Thanks Steve. So far today that editorial is awesome! Made me think a little more about whats good in my life. Health, family and a...
October 5, 2011 at 1:50 am
Just to let you know, resorted to parsing the SQL in 4th gen language.
Touch wood - so far its not too bad...
January 4, 2011 at 4:24 pm
Thanks for the reply. I can see that it would list the SP as per EXEC sp_HelpText and parameters.
What I'm trying to achieve is a lookup of all...
December 29, 2010 at 3:43 pm
Solution was staring me in the face all along (CASE). So I now do this:
SELECT CASE @val WHEN 1 THEN X
August 2, 2010 at 7:45 am