Stephen Lawson's Q&A profile

• SQL Server Database diagrams

  Hello all, I upsized an access backend to sql 2005. In the process, the relationships were lost. When I go to the database in Sql, right click on database diagrams, all I get is refresh and a link to go to learn about database diagrams. How can I recreate the diagrams Thanks ...Show All

• Visual Studio Express Editions Cannot use some keys when open external programs ...

     I got a problem with Visual Studio 2005 - VB Express Beta 2, when I open my VB project, then I open an external program (like wordpad), when I come back to the project those keys does'nt seems to respond : "space", "Delete", "Enter", "Tab" and "Backspace".    If I Close the project and start it back afterward, it work well again ... until I open up another external program.    Tanks  for your feedback, J-F I finnaly found out how to fix the problem. To fix this problem you must "Activate" one of your windows in the menu "Windows" click on "Windows ..." and ...Show All

• SQL Server the most stupid sum question

  here is my problem. i have a table that looks like this barcode |movetype | qty as3 | T | 4 as3 | R | 2 as3 | T | 1 here is my problem and i am probably just stupid. i need the total amount Transfered minus the Received per barcode. so here i would need to see a total of 3. i don't know how to do this. barcode movetype quantity There are several solutions for that, one could be: SELECT SUM(CASE WHEN movetype = 'T' THEN quantity * (- 1) ELSE quantity END) FROM SomeTable HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Seperate SQL 2K Publisher, SQL2K Distributor, SQL2K Subscriber

  Hi, We are about to alter our replication architecture from  SQL 2K publisher/SQL 2K5 distributor/subscriber  to  SQL 2K publisher, seperate SQL 2K distributor and SQL 2K5 subscriber.  The subscriptions will be pulled from the distributor and pushed to the subscriber. Basically, all the work will be done by the distributor (in the hope of improving performance). Has anyone had any experience of a similar architecture All SQL servers are running with the latest service packs. While the configuration you proposed (2KPub\2KDist\2K5Sub) is supported, you will not benefit fr ...Show All

• .NET Development How to detach properly using SQL Server Express?

  Does anyone know of a good pattern on how an application should detach (preferably using a managed SqlConnection) Is there maybe a connection string property that auto-detaches when the connection is closed Here is how far I got: It’s easy to attach a database file in the connection string using AttachDbFilename . And that file gets closed when all connections to that database are closed (one might have to clear the connection pool, or set the connection to use master ). The database file can now be moved or deleted. Sounds good... ...but that database still shows up in the attached databases! (select * from sys ...Show All

• Visual Studio Team System S Rule to check String.Empty is used instead of ""

  hi, i want to create a custom rule for FxCop that should check is String.Empty is used instead of "". Please give some idea for this and any code snippet will be more helpful. Thanks Michael, Kindly check is that logic that i wrote is write or not for checking is string.empty used instead of "". Thanks ...Show All

• Visual Studio 2008 (Pre-release) TreeView bound to DataSet: how to expand items?

  I've been trying to expand items in TreeView for hours... Yes I know how to deal with TreeViewItems. Problem is I use databinding to a (typed) DataSet using HierarchicalDataTemplate, getting a nice Master-Detail-View in a single TreeView. This gives much better overview for my purpose instead of using like 2 separate Listboxes the user has to browse through. Everything looks and works very cool except I don't know how to expand/collapse the items in code because here the items are of type DataRowView ! Could not find any (wrapping) TreeViewItem via debugger. Thanx! First, you should get the Tr ...Show All

• Visual Basic keyboard navigation key

  Anyone knows how to enable the keyboard navigation key (the underline character for a menu or button) with code, I know how to do that from control panel. thanks, http://dotnet.mvps.org/dotnet/faqs/ id=showaccelerators&lang=en Best regards, Johan Stenberg ...Show All

• Visual Studio 2008 (Pre-release) Network error detection, handling and best practices

  Hey, Hope I didn't miss it on the net. My architecture contains several services (physically located on different systems) communicating via WCF. What is the best way to detect network errors I've thought about two possibilities - 1. register for the Faulted event on the channel - This does not seem to work as I excepted. Channel doesn't necessary go to faulted state when a network error occurs. why is that 2. I can use events from System.Net and Microsoft.VisualBasic.Devices - but I prefer to think that WCF has that mechanism inside (that is - detect network errors, detect network availability, etc.). Thanks, Dan. ...Show All

• Visual Studio Team System constant ASP.NET session IDs in load tests

  I am testing an ASP.NET application that uses the session ID as a key for various operations. I noticed that during load tests the session ID is not always constant between requests for a given simulated user. Is there a setting that should be changed either in VS or on the server to ensure that the session ID is consistently maintained between request The test has a step load profile and the test mix consists 100% of a coded web tests that maintains a constant session ID every single time when run standalone. Thanks. It seems very odd that it works when you ...Show All

• .NET Development Difference between loading an assembly by refering it and late binding

  Hi all, What is the difference between loading an assembly by referring it and late binding in the context of object serialization/ de serialization in a client/server environment . Manually loading an assembly and automatically loading of an assembly (a reference to it is added at link time...) has no bearing on serialization/deserialization of an object in any environment. The assembly has to be loaded in order for the object to exist. The object or it's reference must exist before serialization/deserialization can occur... Was there something more specific you wanted to know ...Show All

• Visual Basic VB 2003 Deployment

  I go through all the required procedures to create the setup and deployment files for a Windows application, and they are created fine. Now I am testing if I can install on the same box.  I go to debug and run setup.exe. It installs setup1 successfully on c:\program files\private. What am I supposed to do next I am asking because when I check for the installation folder c:\program files\private , there is no such folder existing. Whatever existing location I specify, I find it empty. ...Show All

• Visual Studio Team System Access to the VSTS Hosted demos

  I cant get access to the Hosted demos at http://www.msdn.microsoft.com/vstudio/tryit/hosted/teamsystem/ I get no connection when I try to access any of the virtual Labs. Can anyone help I have not had an answer to this as yet which is a shame. If you try to access the hosted demos now you do at least get a little more information from the help menu if you get 'No connection'. I have passed the information onto our security/firewall team and I hope to get a resolution, but at present they are saying that the connection method cannot be allowed for security reasons and are checking out other potential sol ...Show All

• Visual Studio Team System CA1030 UseEventsWhereAppropriate warns about methods named Raise<EventName>.

  Using 1.35 rc1, it warns about methods that have the prefix 'Raise'. Would like to understand the rationale behind this, as we use Raise<EventName>() as the name of the protected virtual method that raises the <EventName> event. Why should it be flagged Example: protected virtual void RaisePersistenceCompleted(PCEventArgs e) { EventHandler handler = PersistenceCompleted; if (handler != null) { handler(this, e); } } Thanks. Michael Not entirely. This rule was designed to warn new .NET users (typically C++ devs) when they attempted to reproduce the same functionality already ...Show All

• Visual Studio XML Docs out of MSBuild

  Okay, newbie questions here: Say you have a build.proj file as such: <Project DefaultTargets="BuildAll" xmlns=" http://schemas.microsoft.com/developer/msbuild/2003 "> <PropertyGroup> <Configuration Condition="'$(Configuration)'==''">RELEASE</Configuration> <Build Condition="'$(Build)'==''">BUILD</Build> <IndividualBuild Condition="'$(IndividualBuild)'==''">TRUE</IndividualBuild> </PropertyGroup> <ItemGroup> <ProjectFile Include="C:\source\Common\Exception.csproj"/> <SolutionFile Include="C ...Show All