JimNolandCBI's Q&A profile

• SQL Server Howto suppress FETCH output

  Hello, I'm opening a cursor with the sole purpose to select rows for deletion DECLARE test_cursor CURSOR FOR SELECT ... OPEN test_cursor ; FETCH NEXT FROM test_cursor WHILE @@FETCH_STATUS = 0 BEGIN IF -- check some condition DELETE FROM .. WHERE CURRENT OF test_cursor ; FETCH NEXT FROM test_cursor END For each row that is deleted sqlserver prints several lines of text with the contents of that row. How can I suppress this Thank you Eckard   I think the problem is with trying to use WHERE CURRENT OF in combination with Delete. ...Show All

• SQL Server Align image

  I have an image in a table cell in my report. Naturally not all images fit 100% in the cell which is why I'd like to align the images in the middle of the cell, horisontally and vertically. I've been unable to figure out how to do this in Reporting Services for SQL Server 2000. Am I missing something or is this simply not possible Does anyone know whether it can be done in 2005 http://blogs.msdn.com/ChrisHays/ this link tells you what i been saying all along. paddings are the only way to go. and the working sample is here ...Show All

• Visual Studio Team System How to properly scope

  All was working fine till I tried to suppress a large number of similar messages in an enum. I've been having a really bad time trying to get this to work, I was wondering if somesone could help me out and tell me what I'm doing wrong. using System; using System.ComponentModel; using System.Diagnostics.CodeAnalysis; namespace Foo { [module: SuppressMessage("Microsoft.Design", "CA1008:EnumsShouldHaveZeroValue", Scope = "type", Target = "Foo.Bar", Justification = "yadyadayada")] [module: SuppressMessage("Microsoft.Naming", "CA1705:Long ...Show All

• .NET Development Parse Error in Page directive

  While trying to programmaticly navigate to a page the following error occurs. Any ideas The page was developed and tested on a local machine then moved to a server.   Server Error in '/' Application. First of all....code behind attribute is only accepted on .NET designer. Which means the actual remote server does not recognize the codebehind attribute. You might use 'Src' instead of codebehind. Secondly the inherits part, you have to do something about it. I hope it helps ...Show All

• SQL Server SQL Server Agent Issues

  Hey everyone, I don't know if I am posting to the correct forum so please move this if there is a better forum for this. I am having issues through SQL Server that I believe may be related to the SQL Server 2000 User Mode Scheduler. First of all, I am running a single instance of SQL Server 2000 on a Quad Processor system. I was not around when the system was installed so I do not know how it was originally configured. I am getting a reoccurring error whenever I try to do anything with replication or scheduled jobs. Error 14258: cannot perform this operation while SQL server agent is starting. Try again later. I found the f ...Show All

• Visual C# Answer enable intellisense in web.config files

  Hi, We all know we can create web form and coding using designer and IntelliSense. I would like to know if we can do the similar things on web.config file Right now, I am typing everythng in this file. I believe there should be a way I don't know yet. Any advice is welcome. Karl In vs.net 2005 intellisense is available for web.config file.Another better way to edit  is using Asp.net configuration tool.you can navigate to this tool from website menu in the IDE. ...Show All

• Visual Studio Team System Error TF50604 during Installation

  I've got a problem during the installation of the TFS 2005 RC. First I've set up a brand new PC with Windows 2003 Standard, Active Domain Controller (= ADC; and new DNS; the new domain is addc.mydomain, mydomain is an existing NT-domain, but I used "New Tree", so this shouldn't be the problem...) After that I created three new accounts on the ADC-computer (TFSSetup, TFSService, TFSReports), TFSSetup is a Domain Admin, the two others are Domain Users. On the other computer ready for the TFS (SingleServer) I did everything according to the chm-file (TFSInstall.chm), which includes installing hotfixes, sql server 2005 standard, and so ...Show All

• SQL Server flow functions ?

  Hi Does anyone know where can I find a list of flow functions valid in MDX The list in ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/mdxref9/html/e363722a-3e5b-40a9-a0b5-399dd2d93f6d.htm ist not complete. For example: the case when else end function is not there. I really need a switch. Thanks! Have you looked at this article. http://msdn2.microsoft.com/en-us/library/ms144841.aspx It's a bit short, but should give you some general idea. Hope that helps. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Windows Forms PrintSetupDialog

  Does anyone have experience of using PrintSetupDialog control to adjust the margin of a PrintDocument I find this control has very strange behaviour.  The first time I read the left margin is 10.  I set it to 20 and press OK and leave the dialog.  I then re-enter the dialog box.  The dialog shows another value (something like 7.9). Does anyo ...Show All

• Visual Basic Processing Serial Data

  I need the reduce the processing time in a uMicrocontroller to allow faster sampling times. This has creates a problem in the data collection routine in VB. The old system collected the analog data a converted it to a decimal format before sending it to the serial port. This data is collected and saved using Hyperterminal. The VB program would, when run, would open this file and process the decimal data by graphing it. What I need is to capture the data directly and process a binary word. All attempts to run the graph program have failed! I'm sure it's in the way I'm reading the data. I've not been able to find much informatio ...Show All

• .NET Development How do I enable useUnsafeHeaderParsing from code? (.NET 2.0)

  Hi, We have several webservers that do not follow the correct RFC specification when performing some specific HTTP web requests, in order to communicate with them we need to enable unsafe header parsing. Changeing the webservers to respond correctly is NOT an option in our case. According to documentation, adding the following lines to the app.config enables the unsafe header parsing. <system.net> <settings> <httpWebRequest useUnsafeHeaderParsing = "true"/> </settings> </system.net> This works nicely for regular applications, however, the problem is that our .NET code is exposed and run as ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need UV Atlas help

  I'm very interested in learning how to use the new UVAtlas class on the most basic level. The DX documentation talks about all the steps of usage on an abstract level, but I need an explicit step-by-step example (I am very dense). Can anyone help out Any examples would be appreciated. But specifically I'm looking to do something as simple as taking the "tiny.x" sample and generating a new UVAtlas for it. Thanks much!  Thanks, Ross.  I'll see what kind of trouble I can get into with that... ...Show All

• SQL Server CREATE Credential Secret Storage

  I am hoping to use SQL Server Agent 2k5 to run jobs in the security context of another account.  I have successfully done this, so I know it works. My question is:  what mechanism does SQL 2k5 use to encrypt the secret that I enter when setting up the credentials for the job account using the CREATE CREDENTIAL statement   Is the secret protected using DPAPI   If so, what precautions must I take if I when managing the SQL Server Agent service account Many thanks, Kevin The credential secret is protected by service master key (see CREATE CREDENTIAL in BOL for details) which is in turm prote ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. C# 2.0, GDI+ images & opacity

  And don't know if this post belongs to this forum, but i'll ask anyway... I'm making a small game as a test with GDI+ (C# 2.0). I had this question: is there an easy way to draw an Image object to Graphics with different opacity I don't mean the transparency key thing, but the whole image should be half visible, and trasparency color of course not visible at all. I managed to alter the opacity of the image with getpixel and setpixel, but I'd like to know if there was a way to avoid pixel manipulation (since it takes time). Some of DrawImage methods take an ImageAttributes parameter. The ImageAttributes cla ...Show All

• Windows Forms MSI: "Error writing to file: ******.dll. Verify that you have access to that directory. GAC problem?

  Hi, I have a "Setup Project" in Visual Studio 2005 that generates an .msi installation file. My setup project references several merge modules. When I try to run the generated installation I get the following error message: "Error writing to file: general.dll. Verify that you have access to that directory." I think that the problem is related to the fact that I have two separate copies of my general.dll in my setup project. My application uses one version of general.dll, but my application also uses an assembly called mi.dll, that uses another version of general.dll. So for my application to work both versions of general.dll is incl ...Show All