LonelyPixel's Q&A profile

• SQL Server Store procedure/scripts for monitoring replication status and performance

  Hi guys , may I know is there any examples of store procedure/scripts for monitoring replication status and performance I just know about sp_replmonitorhelppublisher. Thx for the assistance. From, Hans Did you try searching Books Online I searched for "monitor replication" and came up with these topics: How to: Programmatically Monitor Replication (Replication Transact-SQL ... http://msdn2.microsoft.com/de-de/library/ms147874.aspx How to: Programmatically Monitor Replication (RMO Programming) http://msdn2.microsoft.com/fr-fr/library/ms147926.aspx ...Show All

• SQL Server SQL Server 2000 - Service Pack 4 SetUp problem

  Hi, I am trying to install Service Pack 4 to set up the SQL Server 2000 but I am having problem. When I clicked the setup.bat, the screen just "froze" with the message " validating user. Please wait..." What seem to be the problem Please help!!! Thanks and regards, If your account is not priviledged to do an update on the SQL Server (The account must have sysadmin access to SQL Server) then you won’t be able to make the update of the server. Try to login with your Windows accoutn credentials on SQL Server to see if you have access to the system databases which are changed during the update process. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Can't seem to change opacity of window

    In this code: http://nomorepasting.com/paste.php pasteID=74503 I'm trying to simply change the opacity of any window. But that doesn't seem to be working. Anyone know what I'm doing wrong and/or how to get this to work I'm not talking about changing the opacity on the forms my app spawns, thats easy, but any other window, like mIRC, or internet explorer. ...Show All

• SQL Server Max with Datepart

  I am wanting to set any given @Date parameter to the most current recorded Monday in a table (tblMarketPricing). Would this work: @Date = Max(Datepart(dw,MktDate) IN 2 I am unsure if you can use Max with the Datepart function. ***If this is not allowed, can anyone suggest anything different that I might try To get what you are asking for you need: Select @date = Max(MktDate) from tblMarketPricing where DatePart(dw, MktDate) = 2 assuming that 2 corresponds to Monday on your system. You could consider using the DateName() function in place of DatePart(). Since it will otherwise be forthcoming, I will suggest that a Calendar table could also be used to provide these sorts of answers. ...Show All

• Windows Forms BorderColor for a Standard Button

  Hi, It is rather straight forward to change the border color for a flat style button control. The color properly is not listed for a standard style, and I dod not see a public property or method to alter the color by the program either. Not prefer to draw border lines for each control, is there a quicker way to just change the standard button bordercolor property Regards, Reza Bemanian Standard/system style buttons are painted according to the current Windows XP theme or system colors. Buttons do not implement custom drawing so you can't change their appearance. Unless you create your own button by deriving from ButtonBase... ...Show All

• Visual Studio development VS2005 for windows XPe application software

  It's not so easy to find information about windows XPe development. So I have to code an application software which must runs on a Windows XPe platform. It's not clear enough for me, what should I use in VS2005 to develop an application XPe compatible Must I use a specific framework Thanks in advance, Thanks Timo! It's understood : .Net framework 2.0 and more for XP application software ! And Xp embedded too (I suppose...) Julien. ...Show All

• Visual Studio Express Editions are methods called asynchronously in the same thread better than those called in another thread?

  i was just wondering since calling methods asynchronously in the same thread acts just like calling the method on another thread. so which is better or preferred by you programmers out there are methods called asynchronously in the same thread better than those called in another thread Carsten Kanstrup wrote: Unlike the previous versions of VB, VB.NET will not allow a direct cross thread call. If you try, you will get an error message. You didn't state that you are refering to windows controls only . This is only by default. You can access windows controls directly from another thread, without using invoke, by setting checkforillegalcrossthreadcalls to false (you probably wouldn't want to, though). Cars ...Show All

• Visual Studio Express Editions Application to generate MS Word document?

  Is it possible for a C++ application to generate the MS Word *.doc files For example, if I had a form with two text boxes and a button on it. When the button is clicked, would it be possible for the program to make a new MS Word document that has a 2 cell table with the text box values in each cell, and save this Word file to the current directory If so, any pointers to the libraries to use or whatever tools I would need would be greatly appreciated. Thanks in advance instead of //#import "C:\\Program Files\\Microsoft Office\\Office\\MSO9.dll" rename("RGB", "MSRGB") you have to do: #import "C:\\Program Files\\Common Files\\Microsoft Shared\\OF ...Show All

• SQL Server Can not get notification after modifying ADF.xml?

  I reregister and restart my instances after modifying ADF.xml,but still have no any of notifications any idea about that Thanks After modifying your source xml documents, the ICF and ADF, you should update the instance (right click, Tasks, update in SSMS or NSControl update from the command line) to modify the instance. Check the output in either case to make sure the changes were successfully applied. If you've modified the SubscriptionClass, rather than altering the underlying subscription table, the update process renames the existing table and creates a new one. The new one is empty, without rows. You'll need to manually migrate the subscription data to the new table, taking into account the alt ...Show All

• SQL Server How to create a report using multiple databases

  I have two database: FoxPro database - contains client info (name, address) SQL Server database - contains appointmetns, orders, jobs etc. How can I create reports using both databases Thank you Is there a way to have data from both databases in one dataset I need to provide reports like: weekly sales by consultant - it has to be a list of customers (names) and total $ amounts sold grouped by product category. I ...Show All

• Visual Studio C#, VS 2005, Crystal Reports XI, Business Objects Enterprise/Crystal Reports Server XI.

  Hi, I must be missing something with my versions, etc, but for the life of me I can't work this out. I have my report which happened to be written in Crystal Reports (or the Visual Studio version, it doesn't seem to matter) that I have loaded in to Crystal Enterprise. I create a web page with a crystalreportviewer in it (version 11.0.3300.0 ) all my references in the project are the same. and then in my codefile I do this as per the documentation: enterpriseSession = sessionMgr.Logon( "Administrator" , "" , "WEBSERVER-01" , "secEnterprise" ); enterpriseService = enterpriseSession.GetService( "InfoStore" ); infoStore = ( InfoStore )enterpriseService; Session[ "InfoStore" ] = infoStore; Session[ "EnterpriseSession" ] = enterpriseSes ...Show All

• .NET Development web farm Webresource.axd error -- machine keys?

  Resources: We have two Web Servers (Windows 2003, IIS6) that are under a load balance platform – web farm. Web Server 1: srv01 Web Server 2: srv02 Load Balancer: F5 ASP.Net 2.0 C# I am receiving an error with CryptographicException on WebResource.axd. I understand that in my Web farm and the machine keys on both servers might not be identical. So, I followed the instructions on http://support.microsoft.com/default.aspx/kb/312906/EN-US/ Here is an example of the machine key: <machineKey validationKey="4F2A8182401316BB68EWD5679DBB003ED65FF62463EA7B4C73D16FE1F3C97ECF235977F76D4FA31E9286C428A07B358D85426034A24D51935BF13224E3B4969C" decryptionKey="CC69BEB17105DFDD8DBAB2C804505634DB09CDCC970B9F52" validati ...Show All

• Visual Studio HTML Help Workshop versions

  I have not been able to successfully build the sandcastle samples. I believe that my problem is with my version of the MS HTML Help Workshop; in the hhw.exe's about dialog, my version is listed as 4.74.8702.0. I've downloaded the vesion 1.3 of the htmlhelp.exe installation file, but am prompted after installation that "This already has a newer version of HTML Help." in a dialog titled "HTML Help 1.31 Update". I've tried uninstalling my MS HTML Help Workshop before installing the v1.3, but I still end up in the same scenario. So, my question is: How do I get rid of this 4.74 version (dated from 2000), and get v1.3 installed Or, am i missing the boat with the versioning and the version I have is what I need t ...Show All

• Windows Forms HelpProvider - Line break & Min/Max

  Hi 1. My mainform is a "FixedDialog". It has the MinimizeBox=True and MaximizeBox=False. Is it possible to have the help button " " left to the MinimizeBox It only turns up if I set both MinimizeBox and MaximizeBox to False. :| 2. Is it possible to have line-breaks in "HelpString on hlpProvider" in the Property Window If I write "This is\nmy text", "\n" is not read as a line-break. (The same for the "Text" property of the Label component) Kind Regards 1: No, I've tried to fool it by changing the style by hand to add WS_EX_CONTROLHELP but Windows XP won't have any of it. 2: In the Solution Explorer, click Show All Files. Open the node next ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I draw a curve? (eg. an XNA Curve object)

  I've created a Curve object (from the XNA framework) and have given it a bunch of points. How do I render this curve to the screen Thanks, John http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1292861&SiteID=1 ...Show All