Cim Ryan's Q&A profile

• SQL Server Announcing a GUI tool for configuring dialog security and routing

  www.codeplex.com/slm Setting up Service Broker routes, endpoints and security is just too hard. One has to run pages and pages of Transact-SQL code just to get the ‘Hello, world’ example work between two separate SQL Instances and the chances of making a mistake are overwhelming. Well, not anymore! I’ve just uploaded into the Service Broker team code gallery a new GUI tool for doing just that: easily configure two services to be able to have conversations. The tool uses the ‘Service Listing’ concept. A Service Listing is like an identity card for a service. It is an XML document that contains all the necessary information needed ...Show All

• Visual Studio Team System CMMI - Requirement closed state but not in production

  Am I correct in stating that in the CMMI process a requirement can be in a closed state and yet not be implemented in production Does an iteration have a state associated with it   Jason D. Camp wrote: I was just about to install the July CTP version of VSTS. Are you stating that the July CTP doesn't have a working version of the CMMI process The July CTP of Team System hasn't shipped yet, but when it does it'll only have MSF for Agile Software Development. ...Show All

• SQL Server Encryption and database restore

  Hi Can anyone help I have a database using encryption with symmetric keys created using asymmetric keys. I backed up this database and restored it on another machine along with the service master key. I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls. If I regenerate all the encrypted stored procs from script they work fine again. Is there a way to restore the database without having to regenerate all the encrypted procs You are probably missing this sequence after ...Show All

• Software Development for Windows Vista Clusapi.lib not in new Visual Studio 2005 or SDK

  I do not want to link to Visual Studio 6 libraries. I cannot find clusapi.lib and the other required cluster apis . // Link against the Microsoft Windows NT Cluster API library. //#pragma comment(lib, "clusapi.lib") // Link against the Cluster Administrator Extensions library. //#pragma comment(lib, "cluadmex.lib") // Link against Resource Utilities library. //#pragma comment(lib, "resutils.lib") Any help appreciated this was due to paths not being found because cluadmex.lib was changed to uuid.lib ...Show All

• SQL Server Writting multiple rows from one input Row

  Hi: I'm trying to write a transformation script to write multiple rows from 1 input row. In SQL Server 2000 DTS I could do this by using DTSTransformStat_SkipFetch and DTSTransformStat_SkipRow. In SQL server 2005 it looks like I need to use EndOfRowset but I do not know how to use it for sure. If this correct can someone show me a code example and if I am incorrect can someone tell me how to do this Thanks Phil, It must be because your output isn't called "Output0". The name of the buffer is whatever you have called your output with the word "Buffer" concatenated onto it. -Jamie ...Show All

• Visual Studio Error: Report Parameter 'Value1' is read-only and cannot be modified

  I am using VB 2005 RC and SQL 2005 Dev Edition I am trying to drill-through from one report to another passing the Value1 id field as the parameter. Report1 is a basic list of a table.  Report2 is a view generated data from four linked tables.  Both reports work like a charm on their own. In Report1, I select the column properites and link via jumping to Report2 using Parameter Value1 and defining the Report Parameter in Report2 as Value1.  I set the "Internal" checkbox and Allow Null (since setting a default gives me an error). I run the form with Report Viewer and it loads Report1 with no problem, I click on the ...Show All

• Visual Studio Team System "Assigned To" must be a valid account?

  In the MSDN Documentation - Walkthrough: Make Advanced Customizations to a Work Item Type , in the Customize the Assigned To Field section, the following example is shown: <FIELD name="Assigned To" refname="System.AssignedTo" type="String" reportable="dimension"> <HELPTEXT>The person assigned to do the work</HELPTEXT> <ALLOWEDVALUES expanditems="true"> <LISTITEM value="[Project]\Contributors" /> <LISTITEM value="Triage" /> </ALLOWEDVALUES> </FIELD> So my question is, does "Triage" need to be the name of a real A ...Show All

• Visual Studio Team System Customization : add button to create workitems

  Hi, I've read the SDK documents to extent and customize workitems. However, I asked myself if it's possible to add new control on work items forms. For example : On a test workitem, I would like to create a button "raise defect". It would create a "defect" workitem and get the existing properties of his associated test. (ex : phase, test description ...) Any idea Thanks, arno   Arno, in V1 it is not possible to add custom controls to work item form and handle those events. One possibility is to create an addin that can be invoked from menu item when the work item form is dis ...Show All

• Visual Studio Tools for Office storing a variable(caching)

  i need to store one value in a counter variable in vsto excel appln which cannot be stored in database.when i close the appln and open it again it should hold the value(persist) how can i implement this in excel application If you declare the counter as a public member on your customization class and mark it with the Cached attribute then VSTO will save this value along with the document and reload it next time the document is opened: [Cached] public int _myCounter = 0; ... _myCounter++; More details can be found here: http://msdn2.microsoft.com/en-us/library/75akte27(vs.80).aspx Tha ...Show All

• .NET Development Understanding the role of form="unqualified"

  I roundly dislike the prefixing of attributes in XML files that won't go outside my application. (They are so thoroughly encrypted they won't do other much good:-)) And I much prefer to store info as attributes rathr than elements when I can get away with it. So I have discovered the value of setting form="unqualified" in the schema. The question is "where should I be doing this." If I get things exactly right I can have things like <tag attribute="value"/> that read into a datatable aok. If i don't get things exactly correct then to get the data loaded in to a datatable i have to code <t ...Show All

• Smart Device Development Creating a unified installer for both SmartPhone and PocketPC

  Hi, Is it possible to create a unified installer that automatically installs the correct version of software depending on whether a SmartPhone versus PocketPC is connected Basically, one installer self extracting Windows .exe file that installs the correct .cab file of two .cab files (SmartPhone versus PocketPC). Can it be done with the .inf/.ini files Thanks for letting me know. We will change this approach after our beta testing is completed, since we do want to follow proper Microsoft procedure since we want to get the software Microsoft certified soon.   At the moment, we are targetting only 2 ...Show All

• SQL Server SQL CMD and Scripting

  Hi Gurus/MVPS: Can you please share or show me the code for scripting out stored procedures in SQL Server 2005 using SQL Cmd . I need to perform the following: 1). Script out the text of the stored procedure 2). Output to a sql file (text file) under some directory like C:\sql 3). Import the file into the destination db and run it. The above three need to be automated in a DTS Package. I tried to use the DMO but my source server is a SQL2k5 and so DTS desginer does not let me use the ActiveX with DMO against SQL 2k5. I need to run the first step against a SQL2k5 machine and the second and third on a SQL2k machine. Pleas ...Show All

• Windows Forms ContextMenu problem...

  How can I obtain the Parent of a ContextMenu I succesfully patched the problem in an "unelegant" manner (Added a Parent Property to my class and I've assigned it after the InitializeComponent...) that works... but sucks!!! Thank you! What do you mean by Parent   A ContextMenu control does not belong to any particular control. ...Show All

• Visual Studio Express Editions Cannot register Express Web developer

  I downloaded the C# and Web cdroms from the web site today. I installed the C# edition and registered via the HELP-> register  menu. I then installed the web edition and try to register the application via the HELP-> register  menu and I'm redirected to a page that says: I uninstalled/re-installed the product and cannot register it.. please help MicrosoftR Visual Web Developer 2005 Express Edition This is the correct behaviour if you install via the CDROM images. Your install of Visual Web Developer is registered. You will not be provided with a key to activate the product. ...Show All

• Visual C++ Download a file from http server

  Hello I need to write a small download manager, which must support download resuming and downloading from multiple URL, but have no idea what api-s to use. anyone can help Thanks in advance You have two choices: winsock or MFC winsock Check out MSDN. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnanchor/html/ntwrkprot.asp http://www.tangentsoft.net/wskfaq/ Kuphryn ...Show All