Hello All,
Would someone be able to tell me if there is another way of doing this ... In VS2008 there is a database project that a developer can deploy to their local SQL Server instance - any idea how I can determine which account this runs under? The reason being that this works fine, however the next stage of development is to do a build/deploy of this database project via a TFS Build Definition. This runs under the build agent account <DomainName><AccountName>. For testing I'm currently running this build definition and using my local SQL Server. So I've had to add this agent account to the Database\Security\Logins group, and then give this account the 'sysadmin' server role. I don't really want to do this naturally! Hence I thought if I can see which account and permissions the deploy runs under then I can use this in the build definition. I don't even think I should have to add any account to the Login group on my local SQL Server instance. Thanks, Neil. ##################################################################################### Confidentiality and Privilege Notice This document is intended solely for the named addressee. The information contained in the pages is confidential and contains legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. #####################################################################################
_______________________________________________ oztfs mailing list oztfs@oztfs.com http://prdlxvm0001.codify.net/mailman/listinfo/oztfs
