I have a simple database solution in VS team suite '08 (with SP1 and the GDR R2). In the solution I have a server project and a database project. For the purposes of testing, I have only a login in the server project, and only a user in the database project.
In the server project, I have defined a command variable $(NTDomain) that is set to the name of my windows domain (this is so I can have multiple command variable files - one per config: dev, qa, prod). So, my login is defined as follows:
CREATE LOGIN [$(NTDomain)\Some_Such_Id] FROM WINDOWS;
In the database, my user is defined as:
CREATE USER [Some_Such_Id] FOR LOGIN [$(NTDomain)\Some_Such_Id];
The solution builds without error (though no deployment sql script is created), but upon deployment fails because the user has an unresolved reference to LOGIN [$(NTDomain)\Some_Such_Id]. I have tried defining the variable in the database project, and in the database project I added a reference to the server project as I am supposed to.
Is this me, or a bug in VS?