Cr7pt0r's Q&A profile

• SQL Server Database startup time

  Is it possible to find somewhere in the system table time of sql server startup Thanks Hi, as the tempdb is created at very startup of the SQL Server service you can check the information on sp_helpdb tempdb HTH, Jens Suessmeyer, --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Arithmetic Operation with Dates

  Hi I'm trying to get the difference between two dates. I need to create a Calculated member to show it. I'm using this formula PeriodDays = LastDate - FirstDate For example, I have a Time Dimension, I choose two dates: FirstDate = 07/04/2006 it's identity is 300 LastDate = 15/04/2006 it's identity is 308 PeriodDays = 308 - 300 = 8 this value I need to show in a Calculated Member The Time dimension has three levels Year, month and date What happens when I choose only a month Thanks Hi, ohh, I will try to explain again I need to get how many days are between two dates, For example, I choose two dates from my Time dimension Date1 = 07/04/2006 Date2 = 15/04/2006 Days = ...Show All

• SharePoint Products and Technologies Full backup hanging on last step

  Hey guys, hopefully someone can help me. I have a full backup that runs every night. A couple nights ago, it started to hang on on backing up the Windows Sharepoint Services Search Database. It says "Preparing backup" while all the other steps says "In Process". The SQL server database, on the same server (single server deployment) taps out in the morning and the portal is unable to connect to the config database. Then I'd have to restart the server. These backups are also not restorable as they had never finished. Does anyone know what's going on here or know how to clear the unfinished backup history I've already tried deleting timer failed and stuck timer jobs. Thank you much. I have two sharepoint ...Show All

• Visual Basic Unexpected exception occurred during upgrade engine operation

  Hi, During a every conversion of a 'VB6 project' to 'VB 2005 Express', I'm always getting folowing error: --------------------------- Visual Basic Upgrade Wizard error --------------------------- Unexpected exception occurred during upgrade engine operation: Kan niet aan de bron binden (Exception from HRESULT: 0x8004000A (OLE_E_CANT_BINDTOSOURCE)) --------------------------- OK --------------------------- My System : Windows 2000 SP4 (Clean Install) - Visual Basic 2005 Express ed. Any ideas howto resolve this Thx. This is a bug with the Upgrade Tool where it gets confused on where its registry settings are if there is an HLKM\Software\Wow3264Node key in the registry on a 32-bit machine ...Show All

• Visual Studio 2008 (Pre-release) XLinq

  Has anyone done much with XLinq [btw - in writing this i discoved a 36 page doc on XLinq which i'll read tomorrow] I have now listened to Anders Hejlsberg, the C# 3.0 videos and read some on this. Now, LINQ is an excellent technology, but i hear two things from XLinq. 1. It improves XPath queries. In numerous projects people have ran into issues with this, but moreso when namespaces are involved, or when you start doing some advanced XPath queries that work on descedents/ancestors. I'd like to know how easy people are finding doing this kind of advanced thing in XLinq. 2. Initializing the document. Now, i have read this for only a couple of days now, but although i can see the value in selecting via LINQ to create a new Xml ...Show All

• Visual C++ Expanding struct/union (VARIANT exemple)

  Hi guys, I'm trying to understand how the struct/union of the VARIANT type is done. See file <oaidl.h> for VARIANT definition. I want to implement a more simple VARIANT type for my application, but I want the same behavior, i.e. if my variable name is var (VARIANT var), I want to be able to achieve both var.vt = VT_I4 and vt.iVal = 0. My problem is that if I do a struct like this, struct MYVARIANT { int vt; union { int iVal; long lVal; double dVal; } __MYVARIANT1; }; var.vt will be visible but not iVal nor lVal nor dVal ... how can I acheive the same implementation as the VARIANT type Thanks, P.A. You can use an unnamed union, such a ...Show All

• Visual Basic riddle me this -- memo fields from Access

  I've encountered a problem with Memos from Access...  basically I'm running into Nulls when I shouldn't be. I've isolated the problem with as few number of variables as I can: I have 1 Access 2003 database in the location: c:\vb\sampledb.mdb This database has 1 table, "test" The table "test" has 3 fields,  testAutoNum - Autonumber  testText - text  testMemo - memo The table "test" has two rows, [1] [test] [test] [2] [test] [test] I have 1 VB Application with a reference to "Microsoft ActiveX Data Object 2.9 Library". There is one form, Form1, with one textbox, txtTest, and one command button, Command1.  The following code is used: Dim objRS As ADODB.Recor ...Show All

• Visual Studio Express Editions ListView Subitem Bold

  Can I set an individual Subitem field to bold to highlight it .font.bold seems to be read only. Of course, that implies it is possible to set the field to bold 'some way'. I just can't figure out "HOW" Roger I posted this to the wrong forum -- so I'm reporting it here Thanks to ReneeC also. Her post saved me a lot of time working up an answer to your question. Others are the 'great wizards', I'm just a persistant 'ol code hacker ...Show All

• SQL Server Licensing Reporting Services

  Hello, I am going to replace our aging 7.0 server and install 2005 Standard. I want to use the new Reporting Services, and I have a question about the licensing. I will have Reporting Services installed on the SQL Server. It's just the one machine with one processor. Reporting Services will be pulling data from the same machine it is installed to The reports are entirely for internal use (i.e. not a public web) I have 5 CALs for the 2005 at this time. I confess I'm slightly confused about the costs for Reporting Services. RS is on the 2005 disks, it is not a separate program you purchase I install it, do I need to purchase some other license besides the 2005 Standard one I bought Do the CALs I have count towards CALs for RS, or do I ne ...Show All

• .NET Development the fusion technology and make the aciveX control as Windows control and display it

  Dear Sir, I have a web application using DSO Framer control, but when my client wants to view the page. He has to make his security settings low. I know that when I use the fusion technology and make the aciveX control as Windows control and display it by using <OBJECT> tag, then it will act as a normal .net control, can any one help me to do this. Youn can even mail me to : aleem_abdul@akebonosoft.com . Please help me if possible. Thank you. Regards, Aleem. The community at http://forums.asp.net will be better able to answer this question. Thanks. ...Show All

• Windows Forms strange program error...

  Hey, in this code: public int Print( int charFrom, int charTo, System.Drawing.Printing. PrintPageEventArgs e) { do { CHARRANGE cRange; cRange.cpMin = StartPosInRichTextBox1; cRange.cpMax = StopPosInRichTextBox1; RECT rectToPrint; rectToPrint.Top = Convert .ToInt32(e.MarginBounds.Top * AnInch); rectToPrint.Bottom = Convert .ToInt32(e.MarginBounds.Bottom * AnInch); rectToPrint.Left = Convert .ToInt32(e.MarginBounds.Left * AnInch); rectToPrint.Right = Convert .ToInt32(e.MarginBounds.Right * AnInch); IntPtr hdc = e.Graphics.GetHdc(); FORMATRANGE fmtRange; fmtRange.chrg = cRange; fmtRange.hdc = hdc; fmtRange.hdcTarget = hdc; fmtRange.rc = rectToPrint; fmtRange.rcPage = ...Show All

• .NET Development uploading file to Apache

  I try try { client.UploadData( http://www.myapacheserver.com/myuploadfolder , UploadImage); } catch ( WebException Ex) { MessageBox .Show(Ex.Message); } The UploadImage pass in data correctly. But somehow, it doesn't create any image on the apache server. Any idea Regards, Leo Sadly there's no exception thrown. =( It just not appear on my server. When I check server error log it said "An unknown filter was not added:PHP" though. ...Show All

• Visual Studio Express Editions How to put table inside an RTFBox

  Dear VB Experts, Please help me on my code for putting a table (let's say 4 columns, and rows are dynamically added) inside a richtextbox and also please show how to add data onto it. thanks so much :-)     OK Chris here's some code to play with: Imports System.data Imports System.Text Public Class Form1     Private Structure StringAndLength         Public Strng As String         Public Length As Byte     End Structure     Private Enum Types         Space = 0         SemiColon = 1 ...Show All

• Windows Forms Draw points

  Hello everyone, if I have to draw several points without joining them, how can i do it Thanks for your help See SetPixel method in MSDN, simply provide a color, x and y coordinates and it'll give that particular pixel the color you specified and then draw the image. Here is an example from MSDN itself public void SetPixel_Example(PaintEventArgs e) { // Create a Bitmap object from a file. Bitmap myBitmap = new Bitmap("Grapes.jpg"); // Draw myBitmap to the screen. e.Graphics.DrawImage(myBitmap, 0, 0, myBitmap.Width, myBitmap.Height); // Set each pixel in myBitmap to black. for (int Xcount = 0; Xcount < myBitmap.Width; Xcount++) { for (int Ycount = 0; Ycount < myBitmap.Height ...Show All

• SQL Server Total only visible detail band amounts in group band

  I have a query which results in rows like this... Column1 Column2 Column3 A 100 A1 A 100 A2 B 200 A3 B 200 A4 Basically column1 and 2 are from a parent table and column3 is from a child table, joining them together will duplicate the parent information when there are multiple child rows for one parent. I want the report to render like this... A 100 A1 A2 B 200 A3 A4 In other words I am hiding the duplicate values for Column1 and Column2. This all works great. The problem is that I have a group band that I want to sum the column2 values but only sum the dup ...Show All