AndyL's Q&A profile

• SQL Server DB Mirroring Monitor Job - Purge Old Data?

  Hi, Not sure if this question makes sense, but is it necessary to purge old data in msdb tables used by the db mirroring monitor job I'm just wondering if an insert into the data table every minute of the day would still be needed a month from now. I'm thinking this data would be useful for the purpose of "alerts" and to have access to its recent history, but other than that, is it recommended (or necessary) Would these records keep accumulating until manually purged TIA. SQL Agent History is not used for the Database Mirror Monitor status history. The stored proc that updates the msdb . dbo . dbm_monitor_data table with new data is supposed to remove records that are older than 7 day ...Show All

• SQL Server Unlock account from Management Studio does not work!

  Hi, I recognized that I cannot unlock an locked account with Managament Studio for SQL Server 2005 SP1 (Login properties). I need to use 'ALTER LOGIN'-command from a query window. I found old forum entries mentioned the same problem. Is there a time frame to fix this problem Maybe in SP2 or SP3 Wolfgang Kunk Wolfgang, Could you please mark the question as answered if you don't need any further assistance. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Basic How to report service status to SCM

  I have developed a windows service application in VB.NET. My application has a main thread that is created from the OnStart function overriden from ServiceBase class. How can i report the status of my service to SCM. Even if the maint thread exits the service is still shown as running when seen from SCM. Reporting the status was easily done in using the API SetServiceStatus() in WIN32 Programming. Is there any similar function in .NET. Any help is highly appreciated. ...Show All

• Visual Studio Team System Error 0x80501001

  Hi All, Continuing to develop my rules and fighting with fxcop in all new rule, I have other new questions: 1) I am trying to get a specific object inside a method like: Public Sub Ins( ByVal oBoletimImplantacao As BoletimImplantacao)   Dim db As Database   Dim command As DBCommandWrapper   Dim dr As IDataReader   Dim sqlCommand As String .... End Sub I have 'Ins' methods inside my assemblies and I need to verify if there is a variable as 'DBCommandWrapper' that is a company own class. How to know if there is this specific variable 2) How can I see inside the assemblies its imports I have methods with the imports below: Imports Microsoft.Practices.Enterprise ...Show All

• Windows Forms Fix for DGV DataError

  Is there a fix for the the DGV DataError for invalid value in a DGV Combobox.column I had everything working around this and some minor changes - that should have no effect - suddenly started generating the DataError. The last time, I deleted the DGV and created a new one and the error stopped. I've read all the posts that I can get my hands on. I am already trapping the event and reading the error info...column, message etc. I understanding the many things that may cuase the Formatting, Display and Preferred Size context flags. I made changes to try and avoid these, AutoSizeMode, Resizable,etc, but without success. I just don't understand why it went away in the past when I deleted and recreated the DGV ...Show All

• .NET Development Returning a FileStream over a remoting connection

  Here's the scenario: I have many PC's on my network, and I need to programmatically pull files off of each one. I have a windows service that is hosting a remoting object (using TCP Channels). From my main PC I am able to successfully get files if I return them from the remoting object as a byte array. However, when I return a FileStream I get a connection error. Here is a snippet: FileStream tmps = remoteObject.getFileStream(@"C:\test.txt"); MessageBox.Show(tmps.Length.ToString()); <--- this is the line that fails with the error: "System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it." Now the odd part is, if I run that same remote object in ...Show All

• .NET Development date time

  Is any way to make an application that gets the correct date time even if the user has changed it from the taskbar No doubt. Unfortunately, the DateTime.Now method returns the system time as set by the user "from the taskbar". ...Show All

• Software Development for Windows Vista Vista Certification Test Cases Test Case 18

  Hello: I would like to know if and why it is a requirement that we author a row in the upgrade table to satisfy test case 18. For "major upgrades" of our installer (as they would be categorized), we allow side-by-side installation. This way someone can have version 1.0, 2.0, 3.0, etc all installed at the same time. A major upgrade is defined as "A comprehensive update of the product warranting a change in the product code. Essentially, it is a new installation; optionally, it is an application removal." The keyword in that definition is "optionally". We do not want to remove version 1.0 if the user installs version 2.0, and we also don't want to prevent installation of version 1.0 if the user already has versi ...Show All

• Windows Forms bindingcontext.addnew then set combo.selectedindex will not work

  I have a form that is used to enter data. One of the controls is a combobox using complex binding. I have a button that calls a bindingcontext.addnew. After this call I can not set the combobox no matter what I've tried. I've tried selecteditem, selectedindex, text, selectedtext, ect... I've tried getting a datarowview from the bindingcontext.current. This will allow me to set the value in the table, but that value is not displayed in the combobox unless I end the edit. I don't want to end the edit because I want them to be able to change their mind and cancel the new record. This is the binding for the combobox: Me .cboCompletedBy.DataBindings.Add( New System.Windows.Forms.Binding("SelectedValue", Me .DSnonconforming1, & ...Show All

• Internet Explorer Development BUG in IE7 HTML table implementation

  I can't seem to get rid of the extra few pixels of white space at the bottom of each table cell that contains an image. The page displays how I want it in Firefox: http://i20.photobucket.com/albums/b243/parsophie/firefox_page.jpg but the problem only occurs in IE: http://i20.photobucket.com/albums/b243/parsophie/ie_page.jpg I have tried adjusting heights, padding, margins etc. values, but I haven't found a solution. Has anyone had a similar problem and/or could help me Thanks Have you tried to add in the style parameter of your table "border-style:none; border-spacing:0px;" , and if the client is using IE: "border-collapse: collapse;" -- Mathieu Perceau ...Show All

• SQL Server Creating a Package of dtsx packages

  Hi I am trying to build a package that is comprised of 100+ dtsx packages but cannot seem to get it to work. I have created a new connection where the connectionmanagertype = file and the file path is equal to the folder in which my dtsx files are located. I (location = fileSystem). No matter what I do I get an access denied error that shows the folder location but no package. I manually typed the name of the package in the PackageName property and have pasted in the PackageID in the appropriate property as well but I don't see anything in the PackageNameReadOnly. I have read the MSDN information but I don't see a step by step way to build a package of packages against which I can compare. Can anyone set me straight Thanks. ...Show All

• Visual Studio Express Editions datagridview problem...

  hi all..... i have a datagridview....which contain item's information...... but for the edit function.....i would like to enable user to modify the information in the datagridview......., they also allowed to remove the unused item from the list..... but i having problem with this delete function i have an idea regarding this but don't know how to do it....for example...when user right click on the row.......it will come our a delete link which will delete that particular row when it is clicked... or anyone out there have a better idea in solving this problem thanks "Delete unused item from the list" - What list are we talking about or are we talking about deleting a row from th ...Show All

• Visual Basic Unprotecting Worksheet in script

  I need to run a macro in excel, which allows me to do a find & replace on a protected worksheet. How can I write the script to allow me to unprotect the worksheet, run the find & replace and then protect the sheet again without user input Thank you for any help on this. I know this should be simple, but I can't get the unprotect to work. ...Show All

• Visual Basic Using FORTRAN in Visual Basic 2k5

  I'm kind of new to programming, so if anyone can help me out I'd appreciate it. I'm writing a program that has the majority of its computational work written in FORTRAN. The FORTRAN program takes a file input which I have create successfully, but I don't know how to declare and call the FORTRAN library from VB. Can anyone help me out JE First, is your Fortran DLL managed or not   I'll bet my whole paycheck 95% of the time it's unmanaged.  And if it is managed, it's going to be slower than molasses in my grandma's deep freezer. Make sure you compiled your Fortran DLL as a DLL: Your fortran compiler produces a DLL file and this goes in the same directory like your VB executable.  ...Show All

• Visual C++ How to Launch a DirectDraw game with ShellExecuteEx?

  Hi I am trying to launch Age of Empires 2 from within a quick launcher app (VC++ 2005 Express with SDK) using the following code: SHELLEXECUTEINFO ShExecInfo = {0}; ShExecInfo.cbSize = sizeof(SHELLEXECUTEINFO); ShExecInfo.fMask = SEE_MASK_NOCLOSEPROCESS; ShExecInfo.hwnd = NULL; ShExecInfo.lpVerb = "open" ShExecInfo.lpFile = "path to empires2.exe"; ShExecInfo.lpParameters = NULL; ShExecInfo.lpDirectory = NULL; ShExecInfo.nShow = SW_SHOWNORMAL; ShExecInfo.hInstApp = NULL; ShellExecuteEx(&ShExecInfo); The code runs, and the empires2.exe starts, but then it says "cannot initialize graphics system. Make sure your video card and driver are compatible with DirectDraw." Please help m ...Show All