Chris Howarth's Q&A profile

• SQL Server Shared File System across engines

  Is it possible to setup to SQL Server engines to point to a shared set of DB files on a shared file system We want to use this as a type of fail-over keeping our files separate from the machines the engines run on. There are differences in Share File scenarios. The worst thing is using a network drive / path. Although this is not supported it can be enabled in SQL Server. But I guess this is not supported in a case of a failure nor recommendable. Another option would be to use a SAN which is as of its infrastructure built for availbility The third thing would be to use a cluster with a Quorum which uses a shred storage. (Thats all I can think of of of the moment :-) ) Be sure that only on ...Show All

• SQL Server Analysis of a 400GB database after SQL server restarts takes forever (or maybe hang)

  Hello there, We have a database used by a thrid party application that is 400GB in size. After the server gave some warnings, we restarted the machine and SQL server is doing an analysis on the database so it can be recovered. The recovery analysis of the 400GB database has been run for 3 days and only 7% complete. I doubt it'll ever finish. Because this recovery analysis is a background process which I can not kill, I can not drop the database either because it places an exclusive lock on the database when SQL server is doing analysis. We're using SQL server 2000 enterprise edition, sp3. Now I think that we probably should not have such a big database in the first place. Right now, I just want to stop the analysis if I can so I can eit ...Show All

• SQL Server Last GASP on "Insert row in table with Identity field, and get new Identity back " ?

  While I have learned a lot from this thread I am still basically confused about the issues involved. .I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple. To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package. 1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful. 2. ...Show All

• Visual Studio Tools for Office Cancel long running updates in Word

  Hi! I have a VSTO solution that loads a control in Words Task Pane. A function in the control searches the document and inserts new paragraphs at appropriate places. The control contains a cancel button to enable the user to cancel the operation. The problem is that the cancel button's click event is'nt always handled. Usually it is possible to cancel the operation by clicking the cancel button several times. Maybe the (managed) events gets lost while (unmanaged) Word is executing Micke911, would you give me some specifics, such as versions of Office, VSTO, and possibly a code sample to look at Thanks Roger ...Show All

• SQL Server Advice???

  hellooo I have an Accounting system(vb.net 2003, SQL server 2000), every new year data is cleared, but i may use some data from previous years (such as liabilities) whats the best way to that -Shall I create programmatically a new clone DB every year (new DB with same structure as previous year) OR -Shall I add a "year field" for tables in DB knowing that data will keep growing every year whats the best solution, knowing that i dont want the end user of my application to do anything manually, such as creating DB ...... Thank you Have a look at SQL-DMO. You find the SQLServer object which has a DetachDB and AttachDB method which you can use to detach a db, copy the f ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mouse and Keyboard: How can you tell...

  2 Questions.. How can you tell if the keyboard or mouse is plugged in Is this a relevant question Will XNA crash if the mouse or keyboard is unplugged, and it is trying to read device states from a dead device If you use the GetState methods of the Gamepad and Keyboard objects you should be fine with not having the devices plugged in (from the Help): When calling GetState , check the returned structure's IsConnected property value. If the controller has been disconnected, this value will be false . When a controller is disconnected, values for its state will not be valid. The controller will also not be able to receive new vibration settings. I'm assuming this is for 1.0 and not the beta (s ...Show All

• SQL Server datetime datatype conversion

  Hello I have 1 column in table with char datatype that stores datetime values (e.g.: 20061207091510 which translates to 2006-12-07 09:15:10). Is there a way to convert this string into datetime datatype to preserve the time part (hours:minutes:seconds Thanks, Lena SELECT CONVERT ( DATETIME , LEFT( '20061207091510' , 8 ), 112 )+ CONVERT ( DATETIME , SUBSTRING ( '20061207091510' , 9 , 2 ) + ':' + SUBSTRING ( '20061207091510' , 11 , 2 ) + ':' + SUBSTRING ( '20061207091510' , 13 , 2 ), 114 ) ...Show All

• Visual Studio Express Editions Weird behaviour of the 'is' operator. Is this a bug?

  I've noticed some strange behaviour when using the C#'s 'is' operator. As stated in http://msdn.microsoft.com/library/default.asp url=/library/en-us/csref/html/vclrfispg.asp : An is expression evaluates to true if both of the following conditions are met: expression is not null . expression can be cast to type . That is, a cast expression of the form (type)(expression) will complete without throwing an exception. For more information, see 7.6.6 Cast expressions . The following expression, however, returns 'false': 0 is byte Since 0 is not null, and (byte)0 casts successfully without any kind of exception, shouldn't it return true Just for your consideration. By the way, the expression '(byte)0 is byte' returns ...Show All

• SharePoint Products and Technologies Crawl performance on BDC application

  We have been working on a POC that involves a reasonably complex BDC mapping on the AdventureWorks2005 database. We are including about 10 entities with numerous associations. The BDC generation was reasonable straight forward (one problem we had I will post about seperately) however I am finding the indexing of the content to be painfully slow. This is running on a single machine (so results will not be indicative of live) but we have found that it has taken over 4 hours to index 150,000 entities (works orders, products etc). Also the SharedServices_Search database has grow to over 2GB which is a significant multiplier on the base data of about 170MB, do we have any numbers of this or is it totally dependent on the mappings, assoc ...Show All

• SQL Server Whitespace in a table

  Hello All, I am having a problem with whitespace showing up within a table. I have a grouping by date that toggles the fields correctly but when the fields are not expanded, the space where the data would be is showing as whitespace instead of collapsing up. Can anyone shed some light on how to make the whitespace go away Thanks Clint It sounds like you're setting the ToggleItem on the textboxes rather than the row or group, so the textboxes are dutifully hiding themselves, leaving behind the row with nothing inside it. Just set the ToggleItem on the row (if you're hiding details) or group (if you're hiding groups) instead. Cheers, Chris ...Show All

• Visual Studio Express Editions Open Word.doc

  Here's the code I use to open a word document, why does it lose all its formating ie Bold in word is just plain text in my program objWord = CreateObject("Word.Application") objDoc = objWord.Documents.Open(OFD1.FileName, , True, , , , , , , , , False) objDoc.Select() rtbText.Text = objWord.Selection.Text objDoc.Close() objWord.Quit() "it" is a word document, 'Dim a as string = objWord.Selection.Text and let us take a look at the contents of a.' The contents of a will be the word document I already have 'rtbText.Text = objWord.Selection.Text' which loads a word document into the rtb 'rtbText.Text will alway give you plain text' This is not so, if I load an rtf docume ...Show All

• .NET Development String.Compare with Unicode characters

  I am trying to sort a list of Greek Unicode strings, but I can't get the .NET framework to correctly sort or compare the accented vowels. For example String.Compare(" "," ") // or String.Compare("\u1f00","\u1f30"); always returns 0 and String.Compare(" ","α") always returns -1 regardless of the Culture information (current, invariant, Greek) I use in the other arguments of the Compare function. Is there a way to make the first comparison return a negative number Did someone say my name :-) The answer to this question can be found in the following blog post: The city elders won't give this string weight, either (aka On being consistently dea ...Show All

• Windows Forms adding date columns and time rows to a datagridview

  Is it possible to set up a datagridview thats connected to an access database, to have columns and rows like this monday tuesday wednesday 7:00 (data) (data) (data) 8:00 (data) (data) (data) 9:00 (data) (data) (data) what I'm trying to do is write this little app that schedules classrooms and I need to display chronologically the dates and times on the grid. All I have in the DB is the start date, end date, and what days of the week the classes are.and i have interval time also Please tell me the logic Hi; form access we can drag an OleDBDataAdapter  control to the form, then set connection by the wizard using Microsoft.Jet.OLEDB. .0,(according version) I am srue it ...Show All

• Windows Forms View images in a Image List - List View

  Hi, I've a folder in my disc with images, and I'd like to see all the images in my application. I'm using a List View with an Image List, it seems to work, but it takes a lot of time to charge all images in the view. What can I do I think it can works more faster My code: public void CargarImagenesEnVista() { ImageList IL_Imagenes = new ImageList(); IL_Imagenes.ColorDepth = System.Windows.Forms.ColorDepth.Depth32Bit; IL_Imagenes.ImageSize = new System.Drawing.Size(16, 16); IL_Imagenes.TransparentColor = System.Drawing.Color.Transparent; LV_Directorio = new ListView(); LV_Directorio.Visible = false; LV_Directorio.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.Anch ...Show All

• .NET Development fast ping

     Hi,    I need to write a fast ping program to ping class C & D IP addresses. I have written a piece of code to open a socket, connect to it and receive data from it with a timeout. This is fast enough for a few IP addresses but  I would need to ping 255x255 IP's. I have put this code on a separate thread which calls an asynchronous method to loop over the IPs. This is taking a minute for each set of class D IP's. How do I make it run faster Thanks  PS: I am using the 1.1 framework Of course it must run faster because it doesnot need to connect to DNS server to resolve the IP Address because you already know the IP Address in string form ...Show All