AlexHaan's Q&A profile

• SQL Server Memory allocation to SQL Server - AWE under 32 GB

  I am setting up a server under Windows Server 2003 Enterprise Edition (SP1) and SQL Server 2000 Enterprise Edition (SP4). The new server is a AMD opteron with 32 GB of memory. I noticed that PAE is enabled automatically by Windows 2003. Should I enable AWE for SQL Server 2000 and specify Max and Min amount of memory for SQL Server Is there a limit on how much I could specify in MAX memory for SQL This is the first time I have a server with so much memory so I want to make sure that I do the right thing. In the past I only have servers with 8 GB of memory and we just enable AWE and specify Max memory to 6 GB or so. Any advise is very much appreciated. Thanks, If the operton is a 64 bit machine wh ...Show All

• Visual Studio Express Editions View all properties of Object in debugmode

  How cane i see all the properties of a Object in Debugmode in the watch window. I have the following code and insert a breakpoint, and have oTbl as watch. But i don't see the properties of oTbl (like Name, Type, Properties and .....) in the watch window. Is this due to a setting or how cane i see the properties or is this a limitation of the Express versions Best Regards Vic Dim cn As New ADODB.Connection Dim cat As New ADOX.Catalog Dim oTbl As ADOX.Table Dim oCol As ADOX.Column Dim sTblName As String Dim sColName As String cn.Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\CSysTmp\TestMDB.mdb" ) cat.ActiveConnection = cn For Each oTbl In cat.Tables sTblName = oTbl.Type ...Show All

• Visual FoxPro How to calculate the data connection time?

  I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity Well since you didn't give the version number I gave a code that works in VFP9. Just replace text...endtext with a set textmerge block and you'd get what you want. ...Show All

• SQL Server Report being generated never shows second report

    I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on.  The really strange thing is that I had this application working for about 3 months.  I even had up to 30 reports in 30 tabs at one point.  BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report.  Even worse, another user is able to run this application and DOES get all the reports displayed.  So what could have been updated on my PC that is causing this problem   Thanks in advance. ...Show All

• Visual Studio Team System CMMI Requirement Types

  Does anybody have an explanation of what the different CMMI requirement types are used for I guess it is like this: Customer ------------- scenario quality of service Product ------------ safety security functional operational and interface But I would like a more detailed explanation of each. Thanks Henrik. Hi Randy Thank you very much for your reply. Ok, I get the point with scenarioes and QoA's and functional requirements are the scenarioes seen from the products point of view Operational requirements are like: Product xx should run on Windows XP It should be possible to deploy product xx with group policy Interface requirements (I am a little bit in doubt concern ...Show All

• Visual FoxPro Access Database

  hello, i'm a new user of visual foxpro, how am i going to open a ms access database can anybody help me thank you jason http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=565932&SiteID=1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Transparent Backgrounds on Sprites?

  How do I display a sprite with transparency for the background GIF files do not work. I can't seem to create a PNG image with a transparent background in Photoshop 5. Well, first in your code you need to make sure that in the Draw() procedure when the sprite batch begins to draw that you are passing in the AlphaBlend parameter. so this... mSpriteBatch.Begin(); needs to be changed to this mSpriteBatch.Begin(SpriteBlendMode.AlphaBlend); Now as for how to create transparencies in Photoshop5, I have no idea. I personally use Gimp (with it being free and all) and it creates transparencies for PNG files just fine. I think though, your real issue is that you weren't setting the AlphaBlend. Hope ...Show All

• SQL Server How SQL 2005 Execute a sp in master db when called from other db?

  In previous SQL server version, if I create stored procedure sp_XXXXX in master database, then call it from other database (session context is other than master) with master..sp_XXXXX. SQL server will execute the sp with the environment from where it was called. However, in SQL 2005, if I call it with "master..sp_XXXXX", SQL 2005 will switch the context to master database and execute the sp in master database environment. I wonder if I did something wrong or that is the way SQL 2005 execute the sp. If this is the way SQL 2005 does business, then, how to exec a sp in master database with local environment Thank you for any help.   The capability to create system objects in master ...Show All

• Visual Studio Tools for Office Outlook 2007 RTM FormRegion editing bugs

  I am trying to edit FormRegion in the Outlook 2007 that I was developing in B2TR. When trying to modify it (add more controls) the changes are not saved. Even when trying to "Save As" the dialog is never poping up. By trial an error I've discovered that if I delete the TabControl (MultiPage) from my region it will allow to save it. What's going on Thx... Alex >>I'm not sure it's a good idea to mix legacy controls with the new form region-specific controls. >Umm... Why They're just ActiveX controls that're hosted in the container such as formregions. I agree, Alex. I have a formregion that requires an ActiveX control (the InfoPath control). Outlook treats the control improperly. ...Show All

• Visual Studio Visual Studio .net 2003 Help does not work

  Hi!  I have found yet another problem.  I am trying to read through the tutorials that came with this progam and sadly, it does not work either.  I get a server not found error in what looks like a browser incorporated in the software.  Another thing that was interesting, the registration for this software does not appear to work either.  Is this why I am seein visual studio .net 2005   There is so many bugs in 2003 that they decided to release a new version as a cleanup 2 years later   It doesn't give you a nice warm feeling. I am new to programming with the visual studio tools so if anyone could point me to a service pack or something that could fix these problems, that would be great. kalias :( ...Show All

• Windows Forms ListView (CLR 2.0) in virtual mode and OwnerDraw with mouse over = problems

  Hi, I use the new version of the ListView (.net framework 2.0). I decided to make it virtual (due to the large amount of items) and set the ownerdraw property to true (to have the full control on the items drawing). The items (and sub items) are correctly displayed as long as i do not move the mouse over the items/subitems. Since i start to move the mouse over the items/subitems, the content of the subitems (a string) disapears. It is like the Invalidate was not correctly done internally by the control. I put a break point in the function that draws the subitems and i never break into it (protected override void OnDrawSubItem) when i move the mouse over. Also, the selection of the items is not painted correctly. I joined the class derived ...Show All

• Visual C# Using the IS operator in a FOREACH loop

  I am either not understanding how the IS operator works or how the FOREACH loop works. I found some C# code that creates 1 object of 4 different derived classes (see code below). Those 4 objects are assigned to variables of an array of the "base class" type. A FOREACH is used to iterate the array. The FOREACH variable is the "base class" type also. In the FOREACH loop, the IS operator is used to find the object that is specifically one of the four derived types. Here is my question... Since the FOREACH variable is a "base class" type how can the IS ever evaluate to true since the type it is being compared to is a "derived class" type What am I missing Given: Class Employee - An abstract ...Show All

• SQL Server Lookup transformation problem

  Hello all, I needed to lookup some table values based on a join of two fields... I've configured the lookup transform to get the values via a SQL statement to minimize loading time. However, when creating the relationships between the input columns and the lookup columns I receive following error: input column [BATCH_ID] has a datatype which cannot be joined on I've checked both input and lookup columns, both are of type DT_R8... Both columns in the different tables do have the same datatypes Any idea how to solve this problem Thanks in advance Hello, Thanks for your reply but how can I change datatypes fetched directly from a SQL statement in the lookup query ...Show All

• Windows Live Developer Forums DIV Help!

  How do I get my own <div>, and not a custom control to stay on the map at 3D mode You use a shim, here is one a prepared earlier http://www.viavirtualearth.com/wiki/shim.ashx 3D mode renders on top of the current frame of the browser. This mean that simply having a higher z-index makes no difference, your custom controls disappear underneath. To fix this you need to a “shim”. This is an iframe to house your control. function addshim(el,sid) //add iframe shim { if (map.GetMapMode() == VEMapMode.Mode3D) { var s = document.createElement("iframe"); s.id = sid; s.frameBorder = "0"; s.style.position = "absolute"; s.style.zIndex = & ...Show All

• SQL Server change chart color

  Hello, Is it possible to specify color in more detail in the switch statement not "yellow" or "red" but I want to determine the colors by "RGB-values"... hope everyone understands my problem regards, Rhapsy hello, thank you for your answers. they are both helpful and that exactly what i'm loking for ... thanks, rhapsy ...Show All