I cleaned the solution and then built the solution - re-got all conflicts and clicked refresh - they are all still there... Got the latest version of the solution - re-got all conflicts and clicked refresh - they are all still there...

Yeah I think you can only have an application run entirely as admin or not. You could probably do it by creating a separate project and spawning it from your current project - running it as admin. That might require creating a batch file that starts the new project with elevated privileges and running that batch file from your original project. Or there might be a way to do it when you spawn a new process - System.Diagnostics.Process.Start. There is an msdn article on it: http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/5a66c921-0d9c-483f-af3f-afa7f3e3b9c1[^]

Thanks for the response. I was able to delete the files from the folder and delete the project from TFS. However, the 8 conflicts still appear in pending changes - even after a computer restart. They have not interfered with anything so far - everything compiles, checks out, checks in, and gets just fine - but its kind of annoying that these will probably exist forever unless I figure out how to get rid of them - they are referring to a solution that doesn't even exist anymore - how they are referring to it are beyond my imagination.

ok - I somehow was able to get the delete checked in and I re-created the project in my solution. I was also able to check in the new project that has the same structure/files as before. When I ran get latest version of the solution, the Pending Changes window appears with 8 conflicts: 8 writable. I feel that these are the old versions of the files on the server, which I thought were already replaced by the new versions when I checked in - but I guess not. I would like to change the server files to reflect my local files, but the only option to resolve each conflict is to overwrite my local files. Does anybody know how I can do the exact opposite of my only option? :confused:

Oh, I didn't notice the Visual Studio forum - that was probably the better place to post

Rant: Visual Source Safe and Visual Studio 2010 RC are driving me insane. I want to delete a project in my solution and re-create it. Removing it from the solution doesn't delete the files - I have to do that in Explorer. After that, I can't check-in those changes in to VSS. I go in to Source Control and find the project folder and delete it there. It doesn't actually delete it - but I can see a little red X next to the project - I can't check-in those changes either. If I try to create the project again I keep getting errors that files already exist and that I can't overwrite them - basically, I'm going to throw my computer across the room unless somebody can help me :mad: Help is appreciated :) -Kevin

Thanks for the responses. I wish I could take the time to test these, but we have decided to move on - not making this a dynamic proc.

Hello, I need to write a script that creates a table variable with a column for every instance of a row in a table. The data in the table it pulls from may change from time to time, so I'm looking for a dynamic approach. Example table:

ColumnA: ColumnB:
1 Hello
2 World

Then my table variable declaration should look like:

DECLARE @TableVariable TABLE
(
Hello varchar(20),
World varchar(20)
)

Can anyone think of a performance-friendly solution to this? Thanks, Kevin

C# is definitely a good one to learn on if you are working on a Windows PC. You can download Visual C# 2008 Expression edition from Microsoft's web site.

I doubt this was the right place to post this question - but I would say Visual Basic or C# would be the easiest to learn. Java would also be good to learn as it is multi-platform. If you want to fully understand computing languages though, learn C++ (or C). Its a more difficult language, but much more powerful, and if you can understand that language, other languages like VB and Java will make more sense. I started off learning VB6 and while I learned that quickly, when I started trying to learn C I was really confused!

Hello, (This applies to C# as well) I am building a tool using .Net remoting. If I obtain a proxy by Activator.GetObject and then want to switch that proxy by calling Activator.GetObject again with a different parameter - and I do this on a separate thread than the thread(s) that is/are using that proxy, could I run in to trouble? Right now I am using a SyncLock, but there could be several threads using this object, so each one has to wait its turn - even though the server code can handle several asynchronous calls just fine. Could I remove the SyncLocks with no worries? If you need a little more explanation: There will be several servers in different locations running the server code via a Windows service. These services may go down, start up, stop working, etc., so my client code may need to switch where it gets the proxy from. I have a separate thread that monitors these servers and tries to maintain the best connection. I want to know if there is a problem if a thread starts using the proxy, and then the connection thread switches the proxy. I assumed there was a problem so I used SyncLocks, which is also causing problems, so if possible, I want to remove the SyncLocks. Thanks, Kevin