Caffey's Q&A profile

• SQL Server Request for feedback - Aliases have been deprecated for some time and will be removed soon

  As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release. We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages: · Deprecated Database Engine Features in SQL Server 2005 (under “Features Not Supported in the Next Version of SQL Server” ): http://msdn2.mic ...Show All

• Software Development for Windows Vista Fault handling in RC2

  I can't seem to get fault handling to work in RC2. It worked for me in Beta 2.2. I have a state machine workflow that I've published as a web service. I've added a fault handler activity with one code activity as a child. My code activity gets executed, but then, when I retrieve the Fault property of the fault handler activity, it's always null. Any thoughts I'm accessing the property directly as a member of the fault handler activity. In my code activity, I access this.faultHandlerActivity.Fault. This property is always null. It doesn't seem like I can bind to the Fault property using the workflow designer. ...Show All

• Software Development for Windows Vista Dynamic interface to workflow

  Hi, I have a question about making a dynamic interface to workflows. I have searched thru the forums, but can't find any similarities with my problem, so I post it here. If I mistakenly missed another similar posting, please do direct me to that post. The background first. I'm trying to separate the workflow from the application that I'm developing. Let's call the application "AppX". AppX has a lot of modules, and requires multiple number of workflows for approval processes. So, I have to create several workflows in WF. In the end, I will have AppX and several workflows. All workflows are State Machine workflow, which is the most "matched" model to approval process. Since I'm trying to separate AppX from the workflow, I ...Show All

• Visual Studio Sandcastle: Is it possible to get rid of fully qualified type names?

  When I generate html pages using the vs2005 styles, I've noticed that it seems that all links to types are named with a fully qualified name. It's one thing that the text talks about, say System.Random instead of just Random, but some of my types have 4 or even 6-part namespaces, and that's really destroying readability. Is there a switch where I can change this behavior, so that links will only display the type name, and no namespace information Interestingly, when methods are displayed, they are displayed using just the type name and no namespace, but here, the method name would have sufficed (created better readability). I know this doesn't help with the automatically generated texts for class and member headers but... Do ...Show All

• Visual Studio 2008 (Pre-release) Share class

  Hi, One great thing about services with automatic generation of clients is that we do not have to share class, only schema or contract. But is there a way to share class if you want to do it Use the svcutil.exe /reference switch as described here: http://geekswithblogs.net/cicorias/archive/2006/12/31/102393.aspx Note also that .NET 2 has the same capability also for ASMX proxies: http://msdn.microsoft.com/msdnmag/issues/05/03/WSDL/default.aspx KjellSJ ...Show All

• SQL Server Widget Factory Query

  Consider the following. Widgets are made of possibly several parts. A table T exists with columns widgetID and widgetPartName. If widget with ID 7 has parts rotor and rooter, T contains tuples: (7, rotor) and (7,rooter) Boss needs table R with two fields: widgetID and widgetPartList. The widgetParts field should be a string concatenation of all widgetPartNames separated by "/": Example: R contains tuple (7, "rotor/rooter"). Big tables, widgets can have many parts. Any ideas I missed that class. I think that is what he wants. Look at what he says: A table T exists with columns widgetID and widgetPartName. If widget with ID 7 has parts rotor and rooter, T contain ...Show All

• Visual Basic former issues, revisited: FileSystemWatcher

  My understanding of the FileSystemWatcher is that it can only watch a single directory, and either one file type or all file types (nothing in between). If that is true, I am looking at a different approach, if it is not true, perhaps someone could expand my limited knowledge. In short, here is what I want to accomplish. I have big files being uploaded to our FTP server (located in our office), by various speed IP’s (including dial-up) to over 30 unique folders, and I want them swept into a central location. Obviously I have to be concerned about whether the files have completed their upload before they are moved. I was thinking about an app that has a timed event to check all of the files in each named directory for the “da ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. my first game problems

  Hi everyone :) I have been having some weird issues with this tutorials code. It is mainly in this area here: myTexture = Texture2D .FromFile(graphics.GraphicsDevice, "mytexture.bmp" ); Which is located in here: void LoadResources() { myTexture = Texture2D .FromFile(graphics.GraphicsDevice, "mytexture.bmp" ); spriteBatch = new SpriteBatch (graphics.GraphicsDevice); } Everytime i run the game it gives me this weird error: An unknown error has occured. The result code was -2005529767. Any ideas what it might be Thanks for any replies. EricTN: You can use the PNG for transparency. I have a png with transparency and I did not need to use a mask. When I call ...Show All

• Visual Studio Performance on large assemblies

  Sandcastle (Dec CTP) takes a long long time to build when given a largish assembly to document. Our project isn't that large (XML file is 19 MB, DLL is 6 MB) (134 494 elements says CopyFromIndexComponent - which generates 36 000 topics) but Sandcastle takes some 10 hours to build using the SHFB tool. We used to use DocumentX and HelpStudio from Innovasys and it would generate the documentation in a bit over 2 hours. Is there any chance that the next CTP will be faster Thanks David and Eric. This is great information. We will do additional investigation on ApplyVSDocModel and Cpref_reflection.xml and will make sure to improve the perf. Also the perf. in ReflectionToChmContents.xsl is slow as, xsl:document() gets the topic title a ...Show All

• Visual C++ My PE Loader cannot load EXE file which bulit with VS2005.

  I need to write a Simple Loader which can run simple EXE(PE Format) file. My loader can parse PE header: IMPORT,EXPORT,RELOC...... I bulit AP.exe with VS2005, and AP.exe imported msvcr80d.dll. So when my loader parse AP.exe's import table and call LoadLibrary to load msvcr80d.dll, but it return NULL. I have searched some information on internet, and known the "manifest" file's effect. I have read http://msdn2.microsoft.com/en-us/library/ms235342.aspx Troubleshooting C/C++ Isolated Applications and Side-by-side Assemblies and related information. And I try some method to let my loader load msvcr80d.dll successful. For example: Before call LoadLibrary, I do open AP.ex ...Show All

• SQL Server SQL Server 2007 installation hangs on removing temporary files step

  I have a virtual machine that previously had SQL Server 2005 installed. Since I changed the computer name, I have to reinstall SQL. I removed all the SQL components and am trying to reinstall the database and reporting components. The installation is failing on the "Removing temporary files" step. According to the setup progress screen, the following components have been installed: OWC11 SQL Server Bakcward-Compatibility Files SQL Server Database Services Reporting Services Visual Studio Integrated Development SQL Server Books Online SQLXML4 Workstation Components, Books Online - this step is still in "configuring components" status. The virtual machine is running Windows 2003 Server SP1 with all current ...Show All

• Windows Forms Implements ICloneable. form disappear .

  Public Class FormTemplate Inherits Form Implements ICloneable Private Sub BaseForm_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load End Sub Public Function Clone() As Object Implements System.ICloneable.Clone Return Me .MemberwiseClone End Function End Class Public Class MainMenu Inherits FormTemplate Public m_ChildFormNumber As Integer = 0 Public Forms As New List( Of String ) Public Sub New () InitializeComponent() End Sub Public Sub NewForm( Of t As FormTemplate)( ByRef i As t) Dim f As t f = i.Clone If Not Forms.Contains(f.GetTyp ...Show All

• Visual Basic populating an Access database using visual basic 2005

  I am trying to create a new employee application that gets input from a user in text boxes and then take that information and populate a database in Access that will later be pulled to the Track IT! database on SQLserver2005. How do i do it Thank you. a) the OleDbCommand is a command object in order for you to do some things with the database, such as executing queries (insert/delete/select/delete). Here is some documentation about it: http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbcommand.aspx b) the code is up to you where you are wanting to place it - it depends what you want to do really and what the "code" does. In my first example I am selecting all recor ...Show All

• .NET Development Errors after successful install of .net framework 3.0

  I am a consumer, not a programmer.    On 1/29/2007 I went to Microsoft Update and got two items from the software(optional) pane, they were as listed below.  After I got the updates the computer did not ask me to reboot as it had advised me I might have to before the update.  So after the successful download and install of these items and waiting a good while after the Microsoft Update website said success and I had closed it, I rebooted the computer using the start menu restart.  After the restart the computer would not access the internet whatsoever, even though my ISP said I had a valid IP number and my IP phone from Comcast was working fine.  I called McAfee because their software was not able to run and t ...Show All

• Visual C# need help with code

  I am trying to write a program kinda like a receipt and I am having trouble with this. What I need it to do is look like this: Please enter the price of the item: Please enter the quantity of the item: Please enter the total of the item: It needs to continue until you want to end it with like(-1) or something. Any suggestions It would be greatly appreciated. Thanks it says cannot convert the decimal to an int It also says cannot convert decimal to double. In each of them It asks if I am missing a cast.... ...Show All