I am trying to TRUNCATE a table but I am getting this error:  Cannot truncate a table 'ALOT_OF_USELESS_LOGS' because it is being referenced by a FOREIGN KEY constraint.   However, I have already truncated all the table where it is referenced EXEC sp_fkeys 'ALOT_OF_USELESS_LOGS' and they all truncated successfully but over this table I am still getting this error.  How can I let this go, ideally without dropping constraints?
Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the primary key of the FK relationship)?  I know that I can either   Use a DELETE without a where clause and then RESEED the identity (or) Remove the FK, truncate the table, and recreate the FK.   I thought that as long as I truncated the child table before the parent, I'd be okay without doing either of the options above, but I'm getting this error:     Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.
If a stock doesn't pay dividends, then why is the stock worth anything? I read somewhere that companies are not required to pay dividends to shareholders (this is correct, yes?).   If so, then if company A never pays dividends to its shareholders, then what is the point of owning company A's stock? Surely the right to one vote for company A's Board can't be that valuable.   What is it that I'm missing? Prove by mathematical induction that $2n ≤ 2^n$, for all integer $n≥1$? I need to prove  $2n \leq 2^n$, for all integer $n≥1$ by mathematical induction?  This is how I prove this:  Prove:$2n ≤ 2^n$, for all integer $n≥1$  Proof: $2+4+6+...+2n=2^n$  $i.)$ Let $P(n)=1         P(1): 2(1)=2^1\implies 2=2$.        Hence, $P(1)$ is true.  $ii.)$  Assume that $P(n)$ is true for $n=k$, i.e, $2+4+6+...+2k=2^k$, and prove that $P(n)$ is also true for $n=k+1$, i.e, $2+4+6...+2(k+1)=2^{(k+1)}$  from the assumption add $2(k+1)$ on both sides so we have   $2+4+6...2k+2(k+1)=2^k+2(k+1)$  I'm confused with $2^k+2(k+1)$, I don't know how to make $2^k$ be equivalent to $2^{k+1}$.  I feel i'm doing something wrong.   Any help would be appreciated! Is there any way to import a .json model into Blender? If I am introducing someone to my daughter's husband's parents can I say "Hi, I'd like to you meet my ___". In-laws would not work here because they are my child's in-laws not my own. Is there a word for this relationship? How best to determine if an argument is not sent to the JavaScript function I have now seen 2 methods for determining if an argument has been passed to a JavaScript function. I'm wondering if one method is better than the other or if one is just bad to use?   function Test(argument1, argument2) {       if (Test.arguments.length == 1) argument2 = 'blah';        alert(argument2);  }   Test('test');   Or   function Test(argument1, argument2) {       argument2 = argument2 || 'blah';        alert(argument2);  }   Test('test');   As far as I can tell, they both result in the same thing, but I've only used the first one before in production.  Another Option as mentioned by :  function Test(argument1, argument2) {     if(argument2 === null) {         argument2 = 'blah';     }      alert(argument2); }   As per Juan's comment, it would be better to change Tom's suggestion to:  function Test(argument1, argument2) {     if(argument2 === undefined) {         argument2 = 'blah';     }      alert(argument2); } I will like to know some of the android emulators that work really well with Ubuntu 11.10 and above. I want to try 'whatsapp' on Ubuntu through an android emulator. Thanks in advance I have two Xbox 360's, one WiFi and the other wired through the same Linksys E3000 router with DD-WRT (v24-sp2 (04/13/11) std-usb-nas firmware).   Mine (the wired one, though hers has been wired in the past and it didn't appear to help) always seems to be open (green), and hers is either moderate or closed (oj/red)  Even with the original router firmware I've never been able to get both consoles into "open nat" mode, and it makes playing certain games together almost impossible for me and my wife  because we can't seem to get into the same game.   I have uPnP enabled and the DMZ disabled, and some minor port forwarding to allow for a Minecraft server (Ports 25565 and 25566 for a testing copy of the server), but other than that the settings are mainly at their default, on the xbox's and the router.   Are there any settings I can configure to allow this to work properly? How does Ubuntu flavor iso differ from a desktop package? TL;DR: how does an Ubuntu flavor iso installation ( for example Lubuntu ) differ from installing a desktop package via apt-get ? (for instance sudo apt-get install lubuntu-desktop)  Context for the question:   Some time ago I answered a question on AskUbuntu , where I tested in virtual machine removing unity-desktop and installing ubuntu-gnome-desktop. That makes the boot logo ( plymouth ) change, desktop changes, different packages get installed (gnome-network-manager instead of network-manager , if I am not mistaken). It appeared that in effect I've switched to different Ubuntu flavor, even though I started out with the standard Ubuntu system. Hence the question: what differentiates the pre-made Ubuntu flavor iso from installing a package ? Is it all the same base underneath the hood or does installation from iso have specific configurations ? If it's possible to install a flavor via package manager, why then separate flavor iso's exist ? (obvious answer is user convenience, but I think there has to exist other reasons. Canonical is a business , and it makes not a lot of sense for a business to provide additional flavor iso , if a sysadmin or end-user can get the same thing via package manager by themselves). A lot of strange loop devices appear in my Kubuntu OS.      [translation:     Hard disk 107.4GB     Hard disk 487.0GB     Loop Device     Hard Disk 4.0GB     Loop Device     Loop Device     Loop Device     Loop Device     Victor Disk]   Can anybody tell me what it is? . Why do light disappears the moment we switch off the source (inside the wooden box)? Ubuntu won't boot because of lvmetad I've followed this tutorial to install Ubuntu 15.10:    After restarting my computer I got to the grub menu and chose Ubuntu. Shortly after that I got this error:  /run/lvm/lvmetad.socket: connect failed: No such file or directory WARNING: Failed to connect to lvmetad. Falling back to internal scanning.   These messages keep adding up on a black screen every second. After a while,  I get access to the initramfs ash console.  what am I doing wrong? Is normality testing 'essentially useless'? A former colleague once argued to me as follows:      We usually apply normality tests to the results of processes that,   under the null, generate random variables that are only   asymptotically or nearly normal (with the 'asymptotically' part dependent on some quantity which we cannot make large); In the era of   cheap memory, big data, and fast processors, normality tests should   always reject the null of normal distribution for large (though not insanely large) samples. And so, perversely, normality tests should   only be used for small samples, when they presumably have lower power   and less control over type I rate.   Is this a valid argument? Is this a well-known argument? Are there well known tests for a 'fuzzier' null hypothesis than normality? Limiting floats to two decimal points I want a to be rounded to 13.95.  &gt;&gt;&gt; a 13.949999999999999 &gt;&gt;&gt; round(a, 2) 13.949999999999999   The  function does not work the way I expected. Is there any hint of of the first Wizarding War being an international event? Is there any hint that the MoM or anywhere else got support in combating voldemort the first time around? Or is everything completely UK-centric?  I can't remember anyone in the second war being specifically sent from europe to help, even though we see international wizards in book 4. But I don't think all the events of the first war are covered in the books.  So are other bodies like the MoM involved in the first war, or was it isolated in the UK? I am using ArcGIS 10.1 and I have a non-spatial table and some layers in a Data Frame.   When I switch to Layout View I want to be able to show the map in a data frame element and the table in another element (something that one could do with "Add Table To Layout" from Table Options, but I want to do this in one step without having to go to Table Options).   Is there a way to do this using ArcPy?   I couldn't find any function in the ArcPy library that would create a new Layout Element ... and then I also don't know how to add the contents of the table to the Layout Element. Case-insensitive attribute-value selector with Jquery Why does C# disallow readonly local variables? Can file uploads time out in PHP? Hi im quite new to PHP, i have created a form for very large csv files to be uploaded to my server. Some one mentioned to me that the browser can time out due to the uploading file being to big, is this true? and if so, can it be prevented?  Thanks for your help! (1)  If $E$ is a subset of $\mathbb R$ with finite outer measure, i.e. $m^{*}(E) &lt;\infty$; and   (2) $E$ is not Lebesgue measurable, i.e. there exists $F$ such that  $m^{*} (F) &lt; m^{*}(EF) + m^{*}(FE^{c}).$  [Claim] There exists an open set $O\supset E$ with finite outer measure, such  that   $$m^{*}(O E^{c})  &gt; m^{*} (O)  - m^{*} (E).$$  My  questions are the following.  (1) Is the above claim correct? I've seen this in Royden's book, but have a bit concern. Note that a set $E$ is Leb measurable if  it satisfies caratheodory condition: $m^{*} (F) = m^{*}(EF) + m^{*}(FE^{c})$ for  all subset $F$. If the claim is yes, it seems that measurability condition can  be reduced from all subset $F$ to Borel set $F$.  (2) If the claim is correct, a proof is needed. Open the default browser in Ruby In Python, you can do this:  import webbrowser webbrowser.open_new("http://example.com/")   It will open the passed in url in the default browser  Is there a ruby equivalent?