Jannet's Q&A profile

• SQL Server How to tell which edition of SQL Server 2005 is installed?

  Since there are several different editions of SQL Server 2005, how can I find out which edition is installed Is there a command or a menu item that can display this information Help->About only gives the version number, not the edition name. I needed to find out whether the SQL Server 2005 on a machine is the Enterprise edtion or not. Thanks, Dandan ...Show All

• Visual Studio Team System Create a Test List in VSTE For Dev

  I am trying to set up a build type in Team Foundation Server that runs a set of unit tests as part of the build process. However all the docs I see reference features I can't find. I suspect they are part of TE for Testers, which I don't have. How can someone who does not have Team Suite, or Team Edition for Testers create a build type that can run unit tests Unfortunately that is correct, test list creation is only fully supported in Team Suite or the Tester edition.   I'm not saying it can't be done - the "test list" and build config files are in XML so in a real pinch it's possible to manu ...Show All

• Windows Forms Neeed help!!

  Hello All, I am Fatir Siddiqui, My problem is that I made simple MDI form ... So, problem ... Form1 is mdi form form5 is main form form3 is also a simple form Now, on form5 i create a commandbutton when i click the command button to call the form3 that form is not create in the MDI form its display outside the container or window .... I mean that when i click on the form5 button so the form3 also show in the MDI of Form1, I hope you people got my point ... Dim f3 As New Form3 Dim f1 As New Form1 f1.IsMdiContainer = True f1.Contains(f3) f3.show() f3.focus()   Hello, thanks Mr. Kean, I really ...Show All

• SQL Server Profiler ....duration

  In SQL Server 2000, "Duration" in profiler (which is in milliseconds) taken by the event; does it include time for the network transfer of the results to the client as well ; or its just the duration taken by SQL Server to complete the SQL Statement. All the measurements are serverside only, so no network time. If you want to see the network time then run the query in query analyser but before you start right click and select client side statistics. ...Show All

• SQL Server updating XML data column through datasets and sqlxmladapter?

  In our project we are storing XML documents on the database using SQL2k5 XML data type. Our data is heirarchical in nature and a decision was made earlier to store the data only as XML and not into relational data tables. This method has worked well so far for reading and transforming these XML documents using XSLT. We are now trying to determine the best method for updating these xml documents. Earlier we had thought to use XQuery.modify(replace with) to change the values, but it seems as if this will be a fairly tedious process and will require our application developers to create SQL statements for every attribute change. Rather than t ...Show All

• Visual Studio Team System Getting users to MS Project "Resource Name" combo

  Hi, We made sure that , the "Resource Name" column is mapped to "System.AssignedTo" field. Please help us in what way we can get all the valid users to "Resource Name" combo box in MS Project. Thanks in advance One workaround is to manually populate the resourcename column in resource sheet of MS Project with the list of valid users in the system. ...Show All

• SQL Server Connection closes often

  Hi Team, I get the below error very often. java.sql.SQLException: I/O Error: Connection reset Caused by: java.net.SocketException: Connection reset Followed by a number of "java.sql.SQLException: Invalid state, the Connection object is closed.". Some time Invalid state, the Statement object is closed." I have checked out the network problem and time out of queries. And both does not seems to be an issue for me. Because my application send queries continuously (Checked it with mssql profiler all queries executed in minimum interval) and MSSQL runs in the local machine. Meantime i do not see any wrong packet exception. Is there any ...Show All

• Windows Forms Data Navigation with OleDb

  Hi, I've successfully set up my dataset/adapters/commands etc. but I have one annoying problem.  My form is bound to a table and works fine when I scroll through all records using that form but when I pass a primary key value from another form (in this case an item in a listview control) I can't seem to get the bound form to navigate directly ...Show All

• Visual Studio Team System Problems with build type configurations and 'Publish'

  If I want to build 2 solutions in one build type, each with a different configuration, I just make sure that both of the configurations are defined in tfsbuild.proj. Then the build will attempt all four permutations (sln1, config1;sln1, config2;sln2, config1;sln2, config2) but skip the ones that are not valid for each solution, is that correct   Also when I try to publish, I would expect it to do a build first, or do I have to be explicit and define a 'SolutionToBuild' and a 'SolutionToPublish' item for each solution I want to publish in tfsbuild.proj I have attempted to do a publish, however the build log says:   ...W ...Show All

• Windows Forms Encounter exception when load form

  Hi friend  when I load a form with a lot of controls, sometime it will throw exception like following: The system cannot find the path specified    at System.Drawing.Icon.Initialize(Int32 width, Int32 height) and The operation completed successfully    at System.Drawing.Icon.Initialize(Int32 width, Int32 height) does anyone has idear on it Best Regards He Lin my code: private Icon _icon = new Icon(typeof(ErrorProvider), "Error.ico"); ...Show All

• SQL Server publishing downloading report model

  Hi friends is it possible download a report model (.smdl) from a report server and also how to publish a report model i know how to do this from report manager page but i need to do this programmatically (from C#). any ideas please. Thanks. publish model using SOAP method CreateModel , then bind it to a data source using SetItemDataSources ...Show All

• Visual Studio Express Editions Error Message 80042729 when saving the project

  I get error message 80042729 when I attempt to save a project. It also occurs when the system looks like it is attempting to save the state of the IDE when I get past the Debug error message that comes up unless I use the Control-F5 option. I have searched all of MSDN, Microsoft, and Visual Studio 2005 and had absolutely no hits on either message. I am getting the exact same error. I too have searched for any information on this error unsuccessfully. ...Show All

• Visual Basic Learn Programming

  What is a good book for learn programming with Visual Basic theres a free ebook on learning visual basic 2005 available for download here Cathal ...Show All

• Visual Studio 2008 (Pre-release) I cannot install WinFX runtime components 3.0

  "An error has occured during setup.  Installed files have been removed from your computer.  For known issues and troubleshooting information, see the online Readme ." The online Readme is here:  http://msdn.microsoft.com/windowsvista/default.aspx pull=/library/en-us/dnlong/html/WinFXSeptPDCReadme.asp I have gone through it with a fine tooth comb and *NOTHING* fixes it.  It sucks that the error is hidden and no clues are left anywhere as to why this is failing. I have a clean install of: Win XP SP2 .NET Framework v1.1.4322 .NET Framework v2.0.50727 Are these the right versions   Did I miss so ...Show All

• SQL Server Replication Fails after Service pack 1

  We have two servers using merge replication. I have updated one with SP1 and not the other (yet). Replication fails to work after the upgrade. I get the following error message: Date 5/26/2006 2:09:08 AM Log Job History (BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6) Step ID 2 Server BB-CM1-SRV1 Job Name BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6 Step Name Run agent. Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Ope ...Show All