NuSoul's Q&A profile

• SQL Server Scheduled Job Not Working

  I have created a scheduled job in the enterprise manager, which checks around 20 different date columns and replaces any non-dates with NULL using the following syntax: - update policy set [exp] =null where isdate (substring([exp],4,2)+'-'+left([exp],2)+'-'+'200'+right ([exp],1 ))=0 go update policy set [eff] =null where isdate (substring([eff],4,2)+'-'+left([eff],2)+'-'+'200'+right ([eff],1 ))=0 go update policy set [written] =null where isdate (substring([written],4,2)+'-'+left([written],2)+'-'+'200'+right ([written],1 ))=0 go etc...... When I start the job, if fails within 2 seconds. If I copy the syntax in to the query a ...Show All

• Visual Studio Tools for Office Serious Error with Action Pane/User Control

  Hi, I have created one user control named "usercontrol1" and added two combobox onto this user control. Then on click event of one button I have added following code to add this usercontrol to action pane: private void button1_Click( object sender, EventArgs e) { Globals .ThisWorkbook.ActionsPane.Controls.Add( new usercontrol1 ()); } When I run the application and click on button1, I get the content of usercontrol on action pane. Everything is Ok. But when I again click on button1, I get duplicate controls of user control on action pane i.e now I have 4 combobox on usercontrol. How should I solve this ...Show All

• SQL Server AS actions available through RS in SQL 2005.

  Hi, I'm looking for any documentation explaining how RS can use AS actions. Can someone please help me Is it feasible Thanks in advance. Reporting Services does not expose AS actions. This is on the list of features we may add in a future version. -Albert ...Show All

• Software Development for Windows Vista Fixed Needed in ComDef.h in PSDK

  The #pragma for linking comsupp.lib in comdef.h of the PSDK (April 2005) needs to be changed from: #pragma comment ( lib , "comsupp.lib") to: #ifdef _NATIVE_WCHAR_T_DEFINED # ifdef _DEBUG # pragma comment ( lib , "comsuppwd.lib") # else # pragma comment ( lib , "comsuppw.lib") # endif #else # ifdef _DEBUG # pragma comment ( lib , "comsuppd.lib") # else # pragma comment ( lib , "comsupp.lib") # endif #endif as it exists in the compiler version of the file.  Without this change, you cannot link a /Zc:wchar_t compiled application. To the best of my knowledge the SDK I just downl ...Show All

• Visual Studio Team System ADAM Error on Installation

  Hi, I could not ever install the ctp version of foundation server. Finally on beta 2, i thought my woes would be over... Far from it Now it stops at the ADAM install itself. I did exactly as the installation guide said.. fresh machine..  it completes the step 1 starts the step 2 and then it says there has been an error.. now no info on what the error is all abt.  I chkd the known issues and it mentioned abt the TMP variable spaces... I even changed it to c:\myTemp. Still no change to my luck. any idea what i might be missing here... TIA Paritosh jb_tiburon, Are you trying to get a single-server ins ...Show All

• Visual Studio 2008 (Pre-release) LINQ support on deployment

  Hi to all. I am a new in the LINQ. So I have a basic question: I downloaded the LINQ and installed it on my developer machine running VS2005. Used some LINQ code in my application. Now I need to deploy it on the production machine. Do I need to install some LINQ support besides the .Net 2.0 framework Thanks FWIW, the LINQ CTP is not for production use per the EULA. If you want to try it out for prototyping, you will need to have the DLLs in the /bin directory of the CTP on the machine you are trying it out on. For code-behind, you will need the compiler(s) as well. By default ...Show All

• Software Development for Windows Vista Problem Using ifElseactivity in an Embedded workflow designer

  I'm trying to use a ifElse activity in an embedded workflow designer ( Workflow Designer Control Example   downloaded from here: http://www.windowsworkflow.net/Downloads/Examples/Workflow%20Designer%20Control%20-%202005-09-24.exe ) I added a IfElse activity and then select one of the branches. In the property window I select a System.Workflow.Activities.Rules.RuleConditionReference Condition and then when I try to edit the Name   property of that condition (pressing the "..." button) I receive this error: Value cannot be null. Parameter name: activity If I do exactly the same in Visual Studio, I get a Select Rule Condition Form I ...Show All

• Windows Forms How to refresh/reload form

  I have two child forms -- Form1 and Form2. Form1 calls Form2. When Form2 closes, it will return to Form1. How can I refresh or reload Form1 Thanks a lot!! :D one way you can do this is in the close event handler foreach ( System.Windows.Forms.Form form in this.MDIParent.MDIChildren) {   if (form.GetType() == typeof(Form1) {     form.Refresh(); &nbs ...Show All

• Visual Studio Team System How to Updating report from stored procedure

  Hi, I have a report server project which gets its information from a storesd prodedure. Occasionally that stored procedure changes, some columns may be added or removed but as I see it now that only way to have my report reflect those changes is to start a whole new report server project. is there a way to have my current project re-bind to the updated (changed) stored procedure or better yet just bind to it so it detects those changes on its own thanks! hi singee, unfortunately i dont have the domain knowledge to help you with this question. try out the ...Show All

• Visual C# Getting the executable directory

  I've had a good look on the Web but can't find the answer to this... How can I find out the path where my service is installed to, rather than the working directory (typically ..\windows\system32\) This is with a view to reading config files, writing log files,etc, within the installation folder. Thanks for any tips, Mike This should do the trick: System.Reflection.Assembly.GetExecutingAssembly().Location The code above returns the full path to the assembly (i.e. including the filename). If you just need the folder, you could do something like this: string AssemblyName = System.Reflection ...Show All

• Visual Studio Error 5 Unable to copy file "obj\Debug\BO.dll" to "bin\Debug\BO.dll". The process cannot access the file 'bin\Debug\BO.dll' ...

  I have been successfully using VS 2005 Beta 2 (VB.NET) for about a month now.  Yesterday, I started getting the error: Error 5 Unable to copy file "obj\Debug\BO.dll" to "bin\Debug\BO.dll". The process cannot access the file 'bin\Debug\BO.dll' because it is being used by another process. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\Microsoft.Common.targets 2274 9 This error does not occur the first time I build the solution after just opening it in VS.  But all subsequent build attempts fail with this same error.  If I exit VS and reopen the project then I can again build one time and al ...Show All

• Visual C# How can you make your software expire after certain Days ??

  Hello All, I have an application which I want to expire after the trial period and only works after you eneter the key. Any suggestions, piece of code which I can use to secure my application. Thanks, Harsimrat Well, you need to store the date the software was installed, that date needs to stay if someone does an uninstall, and then you may want to write some code that detects if users have been playing with the system date. As for entering a key, you have all sorts of options there. Do you want a key tied to a machine Do you want to generate a response key ...Show All

• Windows Search Technologies Exchange performance

  Does WDS index email informartion directly on an Exchange Server and thereby impact performance or can it be forced to index the local ost file only Is this configurable - perhaps by Group Policy Does Outlook have to be in cached mode for WDS to work at all Does WDS make any use of Exchange's own store indexing Is this part of WDS based on Lookout What are the differences Thanks! Hi, Re. your questions: WDS will index email information directly on an Exchange Server and will index a local ost if there is one. It can also be "forced" to only index cached Exchange folders ...Show All

• SQL Server Using Dimension Source table filter throygh DSO

  Hi, I am processing cube from application but I need to provide Dimension filter before processing of cube. But Dso does not allows it saying that its a read only property which is also given on MS website. Please let me know if there is any other way of doing this or is there anything other than DSO which I can use for processing the cube from C# .net Thanks, SP Are you using AS2000 or AS2005 Can you just use the UI to edit dimension to filter the source, then process it from DSO Or are you in need of programmatically changing the filter each time you process for some reason ...Show All

• Visual Studio Team System Protocol violation - can I change how sensible the test shall be to protocol errors?

  I get this error when running a test on a web page that I have no possibility to change: RequestFailed: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF Is it possible to configure how the test shall handle this so the test will not fail Sten, this sounds like a bug so I'm going to need some more info to track it down.  What's the request like that's causing this error   Are you using non-ASCII characters in a custom header value or in the URL Josh ...Show All