I have a problem. I have a Windows user [domain\user] on my instance that has access to some database. I want to change the default schema for that login. I can do this when I create some test login and user in the database but not for my Windows user:  ALTER USER [MFG\giorgi.nakeuri] WITH DEFAULT_SCHEMA=[TBBS]   ...results in:     Cannot alter the user 'MFG\giorgi.nakeuri', because it does not exist   or you do not have permission.   But when I am trying to add it:  CREATE USER [MFG\giorgi.nakeuri] FOR LOGIN [MFG\giorgi.nakeuri]   I get:     The login already has an account under a different user name.   When I observe login in properties it has a check on the database and both user and default schema are dbo. But I can not change any of those from that window. I am connected to instance with this windows user and login server role is all: public, securityadmin, serveradmin, setupadmin, sysadmin.
I have a login called user1. user1 can execute stored procedure [Test].[SP1]  EXEC [Test].[TestSortation] EXEC [TestSortation]   Both of the above commands work.  Now if I give the user1 the server role of sysadmin in addition to public. the later of the 2 statements above fails, and throws this error:     Could not find stored procedure 'TestSortation'.   I don't want to have to change every stored procedure in the database to have the schema name included with EXECute commands manually. Can someone explain to my why this is happening. Also, is there a way to get around this, automatically fix my stored procedures, have the schema default to [Test]?
How can one rig a Stirling engine? (Piston) I've only done a very little animation and rigging before, and I keep getting stuck trying to rig the pistons and rotor of the Stirling engine I built.     What should happen is that one piston moves in as the other moves out, and through the attached arms, the rotor should spin. Animating the rotor and the piston heads was easy enough, but getting the arms that go from the piston heads to the end of the shaft arm to move right endlessly confuses me.   Each end of each arm moves differently over the course of a cycle. With animating, I can't figure out how to interpolate so the arms stay where they should.  With armatures, I have tried for a while, but keep getting stuck when it comes to how to have one end of a bone moving in a circle while the other end is moving in a straight line.  Edit: The answer below elegantly resolved my problem, so i've updated this with the finished .blend file in case it's useful someone else.   Here is the .blend file: Using Xpath With Default Namespace in C# I've got an XML document with a default namespace. I'm using a XPathNavigator to select a set of nodes using Xpath as follows:     XmlElement myXML = ...;   XPathNavigator navigator = myXML.CreateNavigator(); XPathNodeIterator result = navigator.Select("/outerelement/innerelement");   I am not getting any results back: I'm assuming this is because I am not specifying the namespace. How can I include the namespace in my select? What is with words that have forms that end both in -zation and -sation, such as localization and localisation?  Many spell checkers recommend -zation. I have installed a package using snap and I need to modify one of the files but when I try to change its ownership or permissions, I always get the following message:  sudo chmod +x ./my_file.js chmod: changing permissions of '/snap/my_app/my_file.js': Read-only file system   How can I modify files that are installed via snap? Calculation of $\lim_{n\to \infty}\prod_{r=1}^{n} \left(1+\frac{r}{n}\right)^{\frac{1}{n}}$ Rsync filter: copying one pattern only How to get my own IP address and save it to a variable in a shell script? How can I get my own IP address and save it to a variable in a shell script? Why are some galaxies flat? What is the explanation for the flatness of some galaxies?   (If it's due to their rotation then why they are rotating, why some other galaxies are not flat etc., I would like to hear a nice and complete answer :) ) How can I wrap text around a bottom-right div? Every time I try to do something seemingly-simple in CSS, it doesn't work.  I have a content div that contains a 460x160 image. All I want to do is position the image at the bottom-right corner and wrap my text around it.  &lt;div id="contents"&gt;     &lt;img src="..." /&gt;     text text text text text text ... &lt;/div&gt;   So I want it to look like:  ------------------ | text text text | | text text text | | text text -----| | text text |    | ------------------   Doing it with a top-left or top-right image is cake:  #contents img { float:right; }  ------------------ | text text |    | | text text -----| | text text text | | text text text | ------------------   Now how do I push that to the bottom? The best I've come up with so far are:  #contents img { float:right; margin-top: 90%} // really needs to be 100%-160px  ------------------ | text text      | | text text      | | text text -----| | text text |    | ------------------   In this case the text does not print in the margin, so there is white space above the image.  #contents { position:relative; } #contents img { position:absolute; right:0; bottom:0; }  -or-  // move the img tag under the text in the html and: #contents img { float:right; margin-top:-160; }  ------------------ | text text text | | text text text | | text text -----| | text text | te | ------------------   In this case the text prints over or under the image.  So... how can I accomplish this? I have a large table that is already partitioned by an identifier (CustomerId). I have created new customers, and want to add new partitions to the table, and want to confirm the correct way to do this. My predecessor set this up and is no longer available so I cannot confirm.  There are currently partitions for 60 distinct CustomerIds (let's say 1-60), and a filegroup and file for each. I have created new filegroups and files for the new customers (61-68) and need to partition the existing data already in this table. So, the data that's already in the table, with customerId 61-68 needs to be moved into separate partitions.   I tried to use the partition wizard, but couldn't find an option for what I wanted. As far as I can tell, I need to run something like:  ALTER PARTITION SCHEME PS_Details  NEXT USED Filegroup61 ALTER PARTITION FUNCTION PF_Details ()  SPLIT RANGE (61)   I'm looking for someone to point me in the right direction as to best practice for this sort of thing. Do I take the data out of the table, into a new table stored in the Filegroup61 then switch the partition in? Not really sure how to approach this. C# getting its own class name Preventing applications from stealing focus I was considering playing a Summoner in my next Pathfinder campaign, and I decided that I wanted my Eidolon to be a a four-armed giant (the character being a Gnome with a height complex).  Well, I thought to myself: If it has four arms, then shouldn't it be able to wield two two-handed weapons?  As far as I can tell, it should work. That said, how would that work, exactly? I would assume that it would work like usual two-weapon wielding as far as feats and the like, and it would gain all the bonuses from two-weapon wielding as well. However, as this isn't exactly something that happens often, and thus there are no rules for it (that I can find) I can't be sure of any of this. Does anyone know of anything that could help me with this? I have already dual systems : Windows 7 and Ubuntu installed on my laptop. The Windows 7 had been installed when I bought this laptop, and I don't have a CD.  I just installed VitrualBox under Ubuntu, hoping that I could install another Windows in this virtual machine, so that I could run some applications of Windows even under Ubuntu.  But it seems that I need a CD or ISO of Windows to boot inside this virtual machine. Otherwise, there is an error: FATAL: No bootable medium found! System halted. My question is where I could find a CD or ISO?  At the moment, I am downloading ISO from this , but do not know if it will work. By the way, I am not sure if I should pick the 32-bit or 64-bit? As my CPU is 64-bit but my Ubuntu is i386.  Could anyone help? Thank you very much. How can I test the fairness of a d20? Is there any way to specify a suggested filename when using data: URI? I'm looking for a library/method to parse an html file with more html specific features than generic xml parsing libraries. Is there any difference between being ill and sick? Let $A \subset B$ be a finite ring extension. Fix a ring homomorphism $\nu : A \to \Omega$, where $\Omega$ is an algebraically closed field.   I want to show there exists a non-zero homomorphism $v : B \to \Omega$ of $A$-modules.  I want show that the space $V$ of all the homomorphisms $v$ in (i) is a non-zero finite dimensional vector space over $\Omega$. Show that the algebra $B$ acts on this space. Show that eigenvectors of this action correspond to homomorphisms of algebras $\lambda : B \to \Omega$ that extend the homomorphism $\nu$. Deduce that the set of such homomorphisms $\lambda : B \to \Omega$ is finite and non-empty.    We can assume that $B = Ab_1 + ... + Ab_n$ where $b_1,...,b_n \in B$. The chose $v(b_i)=\omega_i \in \Omega-\{0\}$ and then define $$ v( a_1 b_1 + ... + a_n b_n ) = \nu(a_1) v(b_1) + ... + \nu(a_n) v_n = \nu(a_1) \omega_1 + ... + \nu(a_n) \omega_n \ .$$ This is an $A$-module homomorphism. Am I correct? For the second part, that $V$ is not-zero follows from the first part. That it is finite dimensional follows from the fact that $v_i(b_j)=\delta_{i,j}$ (Kronecker's delta) with $i=1,...,n$ spans $V$ and hence $\dim V \le n &lt; \infty$. I define the action of $B$ over $V$ to be $$b \bullet v = \left( x \mapsto v(b)v(x) \right) \mbox{  for all } b,x \in B \ .$$ This seems to be the natural action to define. Am I correct? However, I haven't managed to solved the rest (the eigenvector stuff and the relation to $\nu$). So, the question pretty much says it all. I'm on Snow Leopard, and I do a lot of web development, particularly in Rails 3 which makes heavy use of the console.  I've seen some notable bloggers etc. mention Zsh as their preference over Bash, but I don't know what difference it would make.  Could anyone give me a good comparison of what difference there is and what might make one prefer one option or the other?