capabel's Q&A profile

• SQL Server XP_CMDSHELL -- Microsoft guidance on using/not using

  Is there any guidance on using Xp_Cmdshell from the SSIS team at Microsoft We're needing to remotely execute SSIS packages on the server where MS SQL Server 2005 is installed. FYI, I've researched this heavily and know about the common ways--re: Using SQL Agent or the Microsoft.Dts.Runtime library in .NET with a web service etc. We are needing a strategy for LOTS of applications to use at this client. This is a large customer with many applications, constraints on security, deployment, and so on. The SQL Agent approach isn't a bad workaround, but it isn't something I'd want to see continue into pe ...Show All

• Visual Studio Charts are not rendered in CR for VS2005 Beta2 Version

  After much newsgroup searching, I was able to make CR work on my web server. However the charts (images) inside the reports do not show up. The src attribute for these images look like this: src="//CrystalImageHandler.aspx dynamicimage=cr_tmp_image_5f03e8ad-37b4-4b16-923e-264e3b3a0314.png" And obviously is not finding anything. Hence 2 questions: 1. How can I specify the domain name for the URLs or tell it to use relative path 2. Where can I find CrystalImageHandler.aspx I searched my entire HD and could not find it. Thank you. Regarding my first question: I already decompiled the CR code using Reflector an ...Show All

• SQL Server SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), which had been a clean RTM install prior to the SP1 upgrade attempt. The following information was located in the C:\Windows\Hotfix\DTS9\Logs\DTS9_Hotfix_KB913090_0.log file (the servers name has bee ...Show All

• Visual Studio Team System Does the TeamBuildTypes folder have to be off the project route.

  Hi I need to be able to move the Team Build Types folder to a sub folder due to the way i am configuring Srouce Control. e.g. $ProjectRoot     Current       *.sln file here       TeamBuildTypes     Releases       Release1          *.sln file here          TeamBuildTypes       Release 2          *.sln file here         & ...Show All

• .NET Development Remotting

  Hi I am converting an application to work as remote. I have many static methods on my bussiness classes. If I call them on client application they will be run in client domain. Is there any way to make them to run in server domain. Thanks Not sure if this is the forum for this. shoot me an email and perhaps joining the CSLA forum on msn groups might help. ...Show All

• Windows Forms Hold references to business objects in controls, or just their IDs

  Do you normally store an instance of a domain object, or just it's ID, in the Tag property of, say, a TreeNode I am having problems because my GUI controls, which hold references to the domain objects they represent, stay in memory for as long as the app is running.  So if I have a TreeNode and a ListViewItem, both representing the same domain object and both keeping an internal reference to that object, I think problems are occuring when I make changes to one and not the other.   But I thought that because I am dealing with reference types (my domain objects), modifying it in one part of the app would modify it in all other ...Show All

• SQL Server Custom Assembly generates error in Aggregation Wizard

  I have a fairly simple custom assembly for adding some functions to a cube. Having a reference to the assembly in the cube project causes the following error when I try and run the aggregation wizard for the cube: Message: Errors in the metadata manager. The system assembly cannot be modified by a user request. To restart the process, resolve the problem and then click start. I get the message after the "Specify Object Counts" step, when it starts the process of determining the aggregations. Is this a bug or is there something I need to do in the custom assembly differently I started with the code framework from the Adven ...Show All

• Visual Basic Build Complete Notification Sounds - another workaround

  I just upgraded to Visual Studio 2005 from VS6.0  and I cannot find any documentation for Visual Studio sounds schemes.  In VS6.0 I could have seperate sounds for "BuildComplete", "BuildError", and "BuildWarning".  In Visual Studio I can only create a sound for VS_BreakpointHit  Are any of the others available The three I mentioned in my post BuildComplete, BuildWarrning, and BuildError.  I found I didn't need notification for every warning or error durning the build, but an all done sound was very usefull.  Some sounds when doing a "Find in Files" would be nice as well. &nb ...Show All

• Windows Forms File association

  Hi, I programmed an Editor and need a file association... I want that when I click a .txt or .rtf my Editor opens up... ...if there's any sample or you know how to...please post :-) MSDN information on creating file associations: http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/shell/programmersguide/shell_basics/shell_basics_extending/fileassociations/fa_sample_scenarios.asp I hope this also&nb ...Show All

• Software Development for Windows Vista printing to ltp1

  hi! i found this code here in the forums: Declare Auto Function CreateFile Lib "kernel32" ( ByVal lpFileName As String , ByVal dwDesiredAccess As Integer , ByVal dwShareMode As Int16, ByVal lpSecurityAttributes As Short , ByVal dwCreationDisposition As Int16, ByVal dwFlagsAndAttributes As Integer , ByVal hTemplateFile As Int16) As IntPtr Const Create_Always As Integer = 2 Const File_Flag_Overlapped As Integer = &H40000000 Const Generic_write As Integer = &H40000000 Const File_attribute_normal As Integer = &H80 Sub ImprimirLPT1( ByVal ...Show All

• SQL Server Saving Auto Recovery Information

  Hi I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information. The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress. How can I change the location of the recovery files or turn off the Auto Recovery functionality completely. In VS2005 this is configurable in the Tools-->Options-->Environment settings. Thanks. There is not configurable today in SQL 2005. We h ...Show All

• Software Development for Windows Vista Using XPS on non-Vista platforms

  Hi I was reading the MSDN article about XPS, and I'm quite intrigued. I'd like to have a go at using XPS for a document creation system on our internal Intranet. I suppose there are 2 main questions.. 1) I've got VS2005 - can I write XPS documents now Or do I need some other SDKs (eg WPF). Would I be able to view/print them ! 2) When does v1.0 come out, or a go-live license ! Cheers   Dan I think you'll need the WinFX Runtimes installed (alteast for the user) if its a non-vista machine - like XP or Win2k3. The WinFX runtimes will allow you to view the XPS documents in the xps ho ...Show All

• SQL Server Can't connect to SQL Server 2005

  Hello, I have a problem with connecting to SQL Server 2005. I have a small network at home with a WLAN router connected to Internet. My notebook computer and desktop computer are connected to router. My SQL Server 2005 is installed on notebook computer and Microsoft Server Management Studio is installed on desktop computer. I wanted to add login so I could connect to it from desktop pc and a problem came up. When I tryed to add account (from desktop pc) to local group on notebook pc I couldn't do that becouse there wasn't offered desktop pc as a location. Also, when I try to make connection string in visual studio, i can se ...Show All

• Visual Studio Team System WebRecorder / Fiddlertool and its limitations - Best way for recording IE's 'non-navigational' events

  What is the current recommended way for recording requests into webtests when IE does not recognize as 'navigation' I am assuming that the WebRecorder relies on IE's NavigateComplete events (or something similar) and records those requests into the webtests (probably the same reason it doesn't record redirects, but not relevant here). However, as people know, there are limitations to this approach. IE has a limited notion of navigation - e.g. AJAX (and if I had to give a example, it would be the *ahem* Google Maps), and one suggested workaround was to use the Fiddlertool(proxy) to record things at the HTTP level so that it captures ...Show All

• .NET Development Remoting Impersonation/Delegation problem

  Hi,     I am working on a n-tier app using remoting. I am using the VS 2005 beta 2. My server needs to access a remote resources on behalf on the connected user.     I have configured my server like :         <channel ref="tcp" secure="true" port="8081" impersonate="true">     and my client:         <channel ref="tcp" port="0" secure="true" tokenImpersonationLevel="Delegation">     I start my server in the context of UserA on one machine and the client app on another using UserB. When I trace I can see ...Show All