The purpose of the article is to provide technical means by which a programmer can combine executing a stored procedure from within a SELECT statement providing the stored procedure returns a result set and usually the execution of a stored procedure is done via an exec statement. In the article I'll show method of running a stored procedure implicitly by executing a SELECT statement.

We are working with some developers from India.  We have been forced to share some of our machines with the off shore developers while we figure out our distant relationship and connectivity issues when working on applications that have many end points within our network.  So the remote team will remote into certain desktops.  And yes we have enough licenses for the software.

Recently we have started to work with TFS source control.  We moved away from Source Safe and CVS.  Well TFS has the concept of workspaces.  Workspaces map locations in the TFS source control to local folders.  As a user you may log into multiple machines and create workspaces on those machines.  If you look at the works spaces on a machine via the Workspaces drop down in Visual Studio you will see all the workspaces that you have created across the multiple machines. 

So now say another user logs into your machine on the evening shift.  Why not safe a machine? Maybe not the best idea maybe so, but who cares.  Because this scenario can be just as valid if I decide to run-as another user in my Visual Studio environment to debug a security context specific bug.  Well if I need to get the latest code from TFS I will have to create a workspace and map to the same local file system as the workspace created under my everyday Windows account.  Well TFS will not allow this.  Two workspaces cannot be mapped to the same local path.

You will have to delete the other workspace so you can map a new workspace for the currently logged in user.  I guess you could say that why are you mapping to the same place.  Why not isolate the code from each developer in there own profiles?  Yes we could, but up to this point we have just wanted consistency in directory structure origin.  I tried this it just moved our problem to the IIS Virtual directory mappings.  Yep, we are using IIS rather than the built in web server, reality first I say. 

So assuming we are not going to change our ways, we will have to find the workspace that is using our local mapping and delete it.  To do this we need to use the tf.exe command line tool. 

 

Here is the work around I have come up with while sharing a machine between users: (substituted users and machine names)

The bolded characters are my command line text.

First list the workspaces for a machine, in this case it is JoesComputer for all owners.  Notice the /owner:* wildcard search.

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE>tf workspaces /computer:JoesComputer /owner:* /server:http://TFSServer:8080

Server: TFSServer

Workspace               Owner                Computer     Comment

----------------------- -------------------- ------------ -----------------------------------------------------------------------

HOBO_MyAccount          ShookJ               JoesComputer Temporary CruiseControl.NET Workspace

HOBO_NotificationServer ShookJ               JoesComputer Temporary CruiseControl.NET Workspace

HOBO_OnlineBillPayCsr   ShookJ               JoesComputer Temporary CruiseControl.NET Workspace

HOBO_ProfileManager     ShookJ               JoesComputer Temporary CruiseControl.NET Workspace

JoesComputer            ccnetServiceAccount  JoesComputer

JoesComputer            BullPenUser             JoesComputer

Then delete each of the Workspaces that are on the machine mapped to you machine name. 

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE>tf workspace /delete JoesComputer;ServDevelopmentBuild /server:http://TFSServer:8080

A deleted workspace cannot be recovered.

Workspace 'JoesComputer;ServDevelopmentBuild' on server 'http://TFSServer:8080' has 0 pending change(s).

Are you sure you want to delete the workspace? (Yes/No) y

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE>tf workspace /delete JoesComputer;BullPenUser /server:http://TFSServer:8080

A deleted workspace cannot be recovered.

Workspace 'JoesComputer;BullPenUser' on server 'http://TFSServer:8080' has 3 pending change(s).

Are you sure you want to delete the workspace? (Yes/No) y

This worked for me because we happened to have a workspace name that was the same as the machine name.  Technically that is not the reason for the conflict mentioned in the email below.  No two workspaces mapped to the same computer can point to the same folder.  Great.  But we cannot share workspaces either across user profiles.  Seems pretty crummy. 

There Is a more advanced search that will show you the mappings also so you know which workspaces to delete.

tf workspaces /computer:JoesComputer /owner:* /server:http://TFSServer:8080 /format:detailed

Then just manually recreate your workspace.  We will just have to live with this while sharing machines.

Has anyone our their created a script to make this more streamline?  Because I have admin rights on TFS this may not work for all users.  I will have to drill down on this.  But another path would be to isolate by user profile and thus have your own workspace.  Then create a script that will re-map your IIS virtual directories.  I have wanted to work with PowerShell and maybe this would be a good piece of automation to get me started.

BTW  I have also faced issues with the new VSTS DB Pro tool in a shared workstation environment.  The temporary validation database is only owned by the person that created it.  But when another developer logs onto a colleagues machine and opens a solution with a database project in it you may receive errors.  If you try to build the project you will receive errors.  I found that the temporary database from the primary user is trying to be accessed by the visiting user.  The database file is secured to a single owner.  More on this later. 

Find anyone's passport online:

http://www.scrolllock.nl/passport/

I was just going through my bills.  I have a hospital bill here for $778.28.  That is after the insurance payment.  Gotta pay those yearly deductibles.  I am thinking if I am going to pay a bill that big I should be getting some air miles racked up on the Visa.  So I visit the URL on the bill, follow the instructions.  I put in the account number and the total bill.  I get back an option to pay off in full for, $700.45.  That is a 10% discount.  Typically I just pay online through my checking account.  I will have to remember this and so will you.

Every thing is cool here.  Just taking a picture before we let this nice fish go.  The fish just keeps moving.

The the steelhead twists and arches back into my face.  It felt like I was hit with a hammer.  Notice the red spot.  Now hours later it realy hurts.  Thanks to my brother for getting the picture and laughing the whole time.

Hey Mr Schwary, is this one big enough for you.

Here are some nice arials.

Nothing technical here to see this week.  :) not that I have posted much in the recent past.  My brother is a river guide on the Situk river in Yakutat Alaska.  This weekend I am visiting him while he has some time off. 

Here are some pictures of me with some real nice chromies.   This is with 3 hours of sleep and 2 hours after getting off the plane.

Tomorrow I will have a picture from a magazine article my brother wrote for Salmon Trout Stealheader magazine.  The Nick Ammato, the editor says it is one of the best fish jumping ever caught on film.  It also is presented on the wall just as you enter the side door to the Yakutat Lodge.

Oh and here is a bear we saw.  He was pretty far away.

From http://laptoping.com/hitachi-travelstar-7k200.html

Hitachi has announced volume shipment of the Travelstar 7K200, “industry’s highest-capacity, highest-performing notebook hard drive with new optional data encryption technology”. The 2.5-inch Hitachi Travelstar 7K200 spins at 7200rpm. It comes with 80GB, 100GB, 120GB, 160GB, or 200GB storage capacity and 16MB cache buffer memory, and uses SATA 3GB/s interface.

“With double the capacity and a 22 percent performance improvement over its predecessor, the 200-gigabyte (GB), 7200 RPM Travelstar 7K200 reigns supreme as the leader in this elite notebook hard drive segment. Now, with optional hard-drive level “Bulk Data Encryption” technology from Hitachi, the Travelstar 7K200 offers even greater cachet to notebook users by helping to guard against data loss and piracy,” the Company’s press release says.

Despite the higher motor spin speed, the 7200rpm Travelstar 7K200 offers comparable power consumption, heat emission and acoustics to its 5400 RPM counterparts, Hitachi claims.

Hitachi will also offer the Travelstar E7K200, an “enhanced-availability version” of the 7K200. The Travelstar E7K200 is designed for applications that require 24×7 data access.

Hitachi Travelstar 7K200 will be available in retail this summer at a suggested retail price of $249. Dell and Alienware already offer this hard drive on all Dell XPS notebooks and on all Alienware notebooks.

Please go and read this:

http://www.interact-sw.co.uk/iangblog/2007/05/09/uacproblem