Thibaut Barrère's Q&A profile

• SQL Server Attaching a db - missing log (ldf)

  Hello, I'm trying to re-attach sqlserver 2005 db. I have the mdf file but I don't have the log file. When I try to attach, I get the appended error. Is there anyway, around this Thanks Houman TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SERVER'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Mic ...Show All

• Visual C++ template typedef error

  #pragma once using namespace System; namespace test { template < typename _uintX> class CTest { public : CTest(); typedef typename _uintX uint_type; void testfunction( typename uint_type value); }; } t emplate < typename _uintX> void test::CTest::testfunction( typename test::CTest<_uintX>::uint_type value){ } I get the below errors when attempting to combile the above. I'm pretty stumped as to what is wrong I'm using vc8. Error 1 error C2955: 'test::CTest' : use of class template requires template argument list c:\documents and settings\rischa\my documents\visual studio 2005\projects\test\test\test.h 25 Error 2 error C2244: 'test::CTest<_uintX ...Show All

• Smart Device Development Maintaining C# Code

  I am working on a C# project for the Compact Framework. I have noticed that debugging for the compact framework can be a pain (can't change code durring run time, takes a long time for the code to start using the emulator or a handheld device, etc). I have also noticed that most of the code files (class.cs) can be used in a normal C# desktop application. I would like to be able to create a desktop application that utilizes the code that I created for the Mobile Application, and still have my Mobile Application, and have them share the same code files. That way, changes in one project would change the files in the other project, and I can quickly code in the desktop application, and check for any problems in the Mobile application. Has a ...Show All

• Visual Studio Express Editions syntax code

  to those of you who are familiar with the coding, could you write a simple code example so we can understand,give us simple syntax examples please of; deleete command accept changes command that way those  of us who are beginners can read the syntax and get a better view of how it works. I'll try my best here. well you can avoid the first approach altogether, since you are using a DataAdapter. 2) depends. In order to correctly insert, update or delete records in the database when we are doing an update from the dataAdapter, it needs to have the correct commands created, otherwise you will get an exception thrown that the correct command was not found/generated. So for the delete comman ...Show All

• SQL Server how to create a new database from an existing database saved to an external hard disk?

  Hi, My server went dead(problems with the hard disk), but I have a copy of the whole sql server directory including the database in a external hard disk. I have a new server now and I would like to copy this database (with the reports from reporting services too) from the external hard disk to my new server. can anybody help me please Thanks. Note : I have a plain copy of all the sql server directory with all the files including the database not a SQLServer backup done with the wizards. 1. Install SQL Server onto the new server (if you haven't already). 2. Find where the old database files are on the disk. Search the external disk for *.mdf, *.ndf, and *.ldf to find them quickly. Once you find both ...Show All

• Visual Basic Which form will get focus?

  I am trying to find which Access form will regain the focus when I close the currently active form. Is there anyway to determine this These forums are for VB.NET questions.   The VB within Access is Visual Basic for Application.    VBA is a very different product from VB.NET and there are some other locations where youy will probably get a quicker and better response to your VBA questions. Y ou may find more assistance in following which specifically deals with VBA development. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1 Or if you are using VBA from within on of the office applications Office Automation: office.develope ...Show All

• SQL Server Opening package stored in MSDB

  I created a package using the Import\Export wizard and saved it to the local Sql server. Under Management Studio I can see the package, can run in, import it, export it BUT how am I supposed to edit (modify the thing) it TIA, barkingdog You can make simple edits like changing the property, enabling / disabling task etc by exporting the SSIS package as dtsx files in file system and opening it in SQL Server Management Studio. To perform more advanced functionalities -like adding new tasks / flows - you need to open and edit the dtsx package in Visual Studio / SQL Server Business Intelligence Development Studio. Thanks, Loonysan ...Show All

• Windows Forms Convert.To double and then math.round( ,2) not working well.

  Dear All, I have this problem where first I have text box in it I will key in a number. Upon that I will first convert it to double using the Convert.ToDouble() function. Then I will use Math.Round(convertedToDoubleValue,2). But unfortunately my output doesnt appear in 2 decimal format. What I want for example is that if I enter 4 I want the output to be 4.00. Can some one help me pls Thanks. You'd want the Enter key to behave like the Tab key. Add this code to your form: protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (keyData == Keys.Enter) { this.SelectNextControl(this.ActiveControl, true, true, true, true); return true; } return base.ProcessCmdKey ...Show All

• Microsoft ISV Community Center Forums Highlight Row depending on cell - Excel VBA -

  Hi All I need some help with this code ...... I have a sheet full of data, Col A , B & C full of data and col D is 1 or 0 ... I need to highlight all rows in red whenever there is a 0 in Col. D when i press a button (that i know how to create !) I don't want to use conditional format as the sheet slows down drastically using this method !! Thanks Try this Sub Hilite() Dim lngRow As Long Application.ScreenUpdating = False lngRow = Range("D1").End(xlDown).Row Do While lngRow > 0 If Cells(lngRow, 4).Value = 0 Then Rows(lngRow).Interior.ColorIndex = 3 ' red End If lngRow = lngRow - 1 Loop Application.ScreenUpdating = True End S ...Show All

• SQL Server Error while executing reports from report manager

  Hi.. I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as I click on any report on the report manager. I am not able to find the cause of the error. Does anybody have any suggestions Thanks , Viva Viva1 In the directory C:\Program Files\Microsoft SQL Server\MSSQL.1 is a logfile directory for Reporting Service. In this directory, is a reporting service application log file and normally contains a more descriptive error message. It would be helpful to know what its contains. Ham ...Show All

• Visual Studio Team System QA testing documents

  This is not a question related to Visual Studio Team System but more about QA testing and documents. Does anyone know how and where I could find documents that Microsoft uses when they test a shelveset Do they follow strict guidelines using software or simple excel sheets How are they doing it I suppose these documents are not publicly available nor through a Google search but was wondering if anyone knew or better yet, send me a link to "QA Standards and documents". Thanks in advance! Sincerely Vince Vince, spreadsheets work fine at individual feature levels however once we get to products with multiple feature integrations on varying machine architecture and OS co ...Show All

• Visual C# Opening a jpg, copying to a new Bitmap object, then saving with the same compression data

  I'm opening jpg files, then copying the pixel data to a new Bitmap object, manipulating that bitmap, then resaving. But I can't figure out how to retain the same compression information from the original image. For instance, I'm opening 1600x1200 jpgs images that have a file size of 800k. Then I crop them to about 600x700 or so, but the file size becomes anywhere from 1.6mb to 3mb! Any help is appreciated. Guys, I am saving it back as jpg. But the resulting jpg loses all the compression information. So my question is how to access the original compression information and use it to resave. ...Show All

• SQL Server Performance in SSIS

  Hi: I've written new SSIS packages to do what DTS packages did and the performance I'd say is about 20 times slower. In this package, I have a loop that loops through different servers based on server entries in a SQL database. Each loop pumps 10 tables. The source query is set by a variable and the destination table is set also by a variable, since all this data goes to the same tables on the SQL server and the definitions are all the same on the source server (Sybase). It's still going and has taken about 12 hours to pull roughly 5 million records. The source query ends up being: SELECT *, 'ServerName' FROM SourceTable1 WHERE Date >= Date The 'ServerName' , the "sourcetable1" and the "Date" are all set ...Show All

• Microsoft ISV Community Center Forums Information required : WOW64

  What is WOW64 How it helps to run 32-bit applications on 64-bit processor Where could I get it From http://msdn2.microsoft.com/en-us/library/ms952405.aspx : WOW64 WOW64 is short for Windows-32-on-Windows-64. It provides 32-bit emulation for existing 32-bit applications, enabling most 32-bit applications to run on the 64-bit version of Windows without modification. It is similar to the old WOW32 sub-system, which was responsible for running 16-bit code under the 32-bit version of Windows. The hardware itself has a 32-bit compatibility mode, which handles actual execution of IA-32 instructions, but the WOW layer handles things like switching the processor between 32-bit and 64-bit modes and emulating a 32-bit system. For examp ...Show All

• Visual Basic Add Flash9 Control to VS2005

  I added Flash9.ocx(c:\program files\system32\macromed\flash\) to vb2005 toolbox, when I draw the "Shockwave Flash Control" to form, there comes errors: * Could not resolve dependent COM reference "stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a". * Failed to create the wrapper assembly for type library "AxShockwaveFlashObjects". Exception of type 'Microsoft.Build.Tasks.ComReferenceResolutionException' was thrown. * The referenced component 'AxShockwaveFlashObjects' could not be found. Failed to create the wrapper assembly for type library "AxShockwaveFlashObjects". Exception of type 'Microsoft.Build.Tasks.ComReferenceResolutionException' was thro ...Show All