We are using SQL 2012  Our Secondary server in a log shipping configuration went offline never to come back (the VM was permanently deleted before log shipping configuration was updated).   On the Primary server, I am trying to clean up the LS configuration but everything I've tried times out and/or gives me errors about having configuration still existing.  I have done the following:   Deleted the LS jobs from the primary server (Backup and Alert) Run the Stored Procedure "sp_delete_log_shipping_primary_secondary" with success Attempted to run the Stored Procedure "sp_delete_log_shipping_primary_database", this fails.   The error with sp_delete_log_shipping_primary_database is as follows:     Msg 32011, Level 16, State 1, Procedure sp_delete_log_shipping_primary_database, Line 51   Primary Database &lt;"DB name"> has active log shipping secondary database(s). Drop the secondary database(s) first.   If I try to use the SQL management studio GUI, it tries to get me to log into the Secondary server (no longer exists) and times out/errors when it cannot communicate with it.   How do I get log shipping configuration cleaned up on the Primary server, knowing that the Secondary one doesn't exist anymore?    I have flexibility to do a backup/restore of the database during troubleshooting, if needed.
My primary server with SQL Server 2005 broke down, so I've started up the log-shipped database on the secondary server. The database is live on the secondary server, and I just need to remove the log shipping settings for it, while the primary server is no longer accessible.  It seems that the sp_delete_log_shipping_secondary_database stored procedure should be executed on the secondary server to do this, which "removes a secondary database and removes the local history and remote history", as it is stated on .  Would this also remove the database itself? Or only the log shipping settings for it? And what will it do when the primary server is not accessible?  I must not loose the database on the secondary server, as it is already in use.
It is possible to find an efficient algorithm for constructing a provably hard to factor number $N$, together with a witness that shows that it is indeed hard to factor. EDIT, since it was not clear: I also want to be sure that even the person that constructed the number cannot factor it.  Of course, a random large enough integer is going to be hard to factor with high probability, but we might be unlucky.  There are also multi-party protocols for shared generation of RSA moduli (such as ), but I would like a non interactive technique.  Motivation: This was suggested by Poncho's answer to I'm from the State of Kuwait and hold an Eritrean passport. I'm planning to visit UK in October but my visa will expire in November.    Is it OK to make a journey in the last month of my visa, provided that I make sure that I book my plane back before expiring date? Which close reason should I use for questions that do not demonstrate research effort? I regularily encounter questions on StackOverflow which are asked only because of the sole fact that the poster haven't made the effort to google for and the docs of a particular function/class/framework/whatever. My question is, to which category of the five proposed one should I vote when I vote to close the question? Is it: off-topic, not constructive, not a real question, exact dupe or too localized? I tend to be all for 'not a real question' - am I quite right? Social Login adoption vs Traditional Login I have implemented  on my website. I am wondering how important it is to include a traditional login (email/password) system.  I believe there may be a significant percentage of potential users that are either uncomfortable or unfamiliar with social login. These users may not sign up for my site if social login is the only option.  Does anyone know of any data comparing social login vs traditional login and the corresponding adoption rate?  Is there a current best practice? Do I need to give the user an option to sign up using username/password? Or is facebook/google/openID/twitter/MS/Yahoo enough? Are there any rules in baseball which prohibit teams from "borrowing" players via trade? Every season near the trade deadline, we see teams that are out of it trading expensive players and/or free agents-to-be, typically for younger players or prospects.  For example, Matt Garza, set to become a free agent after the season, was traded to the Rangers for a few prospects.  It made sense for the Cubs to trade Garza, because he wasn't under contract any further than this season, and thus doesn't have much value to them.  Compare Garza to someone like Mike Trout, who is likely the most valuable property in baseball, given his skill and inexpensive cost over the next several years.  There's no way the Angels would trade him, because he'll be the cost-controlled centerpiece of the team for years to come.  However, with the Angels out of it this year, what if they wanted to trade Trout to a contender (say the Pirates), but only for the remainder of this season?  That is, they'd get several top prospects now, and would have an agreement with the Pirates that they'd trade him back in the offseason (for something pretty worthless, say for a journeyman minor leaguer).  The Pirates get Trout for the stretch run and are happy to give up a few prospects.  Trout doesn't have much value to the Angels this year, but he has a ton of value for next year.  So they get a few prospects for him, in exchange for the part of his career which has very little value to them.  So in effect, the Pirates are renting or borrowing him for the remainder of 2013.  Why don't trades like this happen?  Are there any rules prohibiting trades like this? What steps does a manuscript typically go through from submission to publication (or rejection) in a typical journal? How are these steps referred to, in particular by editorial systems, and how long do they each typically take?  Note that this question is about the typical situation and hence not about:   Journals with an atypical workflow, e.g. those that allow for an instantaneous reviewer–author interaction. Exceptional steps or rare occurrences such as withdrawal or .   This is a canonical question on this topic as per . Due to its nature, it is rather broad and not exemplary for a regular question on this site. Please feel free to improve this question. Can a professor influence the graduate admissions committee if he or she is interested in a particular student? Which offences result in indirect free kicks? If a player commits a direct free kick offence in their own penalty area, this results in a penalty kick instead of a direct free kick. However, if the offence is an indirect free kick offence, it remains as an indirect free kick .  What offences result in an indirect free kick? Why $\sqrt{-1 \times -1} \neq \sqrt{-1}^2$? We know $$i^2=-1 $$then why does this happen? $$ i^2 = \sqrt{-1}\times\sqrt{-1} $$ $$ =\sqrt{-1\times-1} $$ $$ =\sqrt{1} $$ $$ = 1 $$  EDIT: I see this has been dealt with before but at least with  I'm not making the fundamental mistake of assuming an incorrect definition of $i^2$. Combining two covariance matrices How to add multiple relative hyperlinks to single point in ArcGIS for Desktop with Basic level license? What is the reason behind "non-static method cannot be referenced from a static context"? Proving $\gcd \left(\frac{a}{\gcd (a,b)},\frac{b}{\gcd (a,b)}\right)=1$ How would you go about proving that $$\gcd \left(\frac{a}{\gcd (a,b)},\frac{b}{\gcd (a,b)}\right)=1$$  for any two integers $a$ and $b$?  Intuitively it is true because when you divide $a$ and $b$ by $\gcd(a,b)$ you cancel out any common factors between them resulting in them becoming coprime. However, how would you prove this rigorously and mathematically? Graviational Lensing Data Can anyone provide me with (or point me to) real life gravitational lensing data that I can plug in to the first equation on this page (the standard lensing equation):   together with the luminous mass and distance to the galaxy(s).  I've looked for papers online and have not found any simple data that can be readily plugged in to the equation (I am not familiar with the details of how exactly the lensing is measured and have gotten lost in the mountains of data in the papers).  Thanks What is an ultra-wide lens? What is the point at which a lens is considered "ultra-wide angle" vs just wide angle? I'm using TikZ to plotting some functions for a document. For example, I want to plot 1/(x+1). So I did something like this:  \begin{tikzpicture}[&gt;=stealth,x=3mm,y=3mm] \draw (0,5) node[above]{\fimg $y=f(x+1)=\dfrac{1}{x+1}$}; \clip (-5,-5) rectangle (5,5); \ejes[1]{-4}{4}{-4}{4} \draw[samples=100] plot(\x,{1/(\x+1)}); \end{tikzpicture}   where \ejes[style]{xmin}{xmax}{ymin}{ymax} is command, that I have defined before to draw the axes (join with \fimg). My expected output for the code below was just the function, but I get this:    So, TikZ automagically put the vertical asymptote at x=-1. That isn't a bad thing, but now I want to have some control over it. For example I want dotted lines for vertical asymptotes. How can I do that? Sometimes when I am debugging code in Eclipse it happens that although I can see and inspect class member variables without any difficulty I am unable to inspect the values of variables declared locally within functions. As an aside, any parameters to the current function lose their 'real' names and instead one sees their values listed in the Variables window as arg0, arg1, arg2, etc but at least the values are visible.  This is occurring at present in relation to classes defined within the core JDK. I have verified that the installed and current JRE is a JDK.  Is anybody able to shed some light on this behaviour? When two accounts are merged, all the posts/votes are moved over to the "master" account, and the other account ("slave"?) is deleted. The merge is propagated network-wide, so a similar thing happens on each site.  But, this does not happen to the chat user. The "slave" chat user is kept, with a 404 parent profile link. I feel that the chat user should be merged as well, re attributing all the chat messages.  Thoughts? My background and gameobjects are 2d sprites not UI images ,I want to know how to make my background scale with screen size and positions of 2d sprits on it don't change after building game (webGl) like scale canvas with screen size and anchor points in UI elements .  Before building the game   After building Is it fair to buy a return ticket I know I will never use just because it's cheaper? I am planning a trip to Asia and then back to Rio. The thing is that I am traveling on flexible dates, so I am thinking of buying a one way ticket to Hong Kong, and I was planning to do the same when I want to come back.  But what I noticed is that, for example, a one way ticket from Melbourne to Rio costs no less than $2700 dollars for the month of May.  When I do a search for a round-trip from Melbourne to Rio and back, I can find flights for $2200.  I know I will not be using that return to Melbourne, but I'd still prefer to save those $500.   Can there be any issue with buying a round-trip with a return that I will never use?