Joketery's Q&A profile

• SQL Server Restore DB without Transaction Log

  Hi, How can I restore a DB without TRN log. As database transaction logs grows too much and I only want to restore the database. Thanks Shafiq If you only restore the transaction log then the database will be transactionally inconsistent - the transaction log is an integral part of the backup. What's the scenario context here BTW, what size DB and transaction log are we talking about here Thanks ...Show All

• Visual Studio Team System Several issues with TeamBuild, July CTP

  I'm using the July CTP and have setup the application tier to be the build server. During the configuration of TeamBuild, I ran across the following: Since Visual Studio also guards the Bin folder in Web projects, any assemblies in that directory are added to Source Control. When these assemblies are actually project references, TeamBuild fails (MSB4126) to copy the output of these projects to the Bin directory (Access denied, files are read-only). I had to override the BeforeCompile target to remove the write-protection from these files to work around this. CodeAnalysis fails (CA00058) because Microsoft.VisualStudio.QualityTools.Resource ...Show All

• Windows Forms Returning value to mother form

  I open new form simply by Form2 frm = new Form2(); frm.ShowDialog(); in this new form are just two textboxes and buttom. I need to get values of those textboxes back to form which is opening new form after buttom click. I tryed some stuff about public variables, but it didn't work. someone help me <b>Edited by KraGiE: Use code tags pleas ...Show All

• SQL Server Selecting Connection in Custom Destination Component UI

  Hi there, I am writing a Custom Destination component with a custom UI. The UI contains a combo box which contains the connection names of type “FLATFILE”. I also have provided a button which would create a new connection of type “FLATFILE” by making a call to CreateConnection method of IDtsConnectionService. The combo box gets properly updated showing the connections of type “FLATFILE” but on clicking on the new Connection button the application hangs up. Am I missing something or is there some other way to do it The function are the events handlers which are called by the UI. void form_GetC ...Show All

• SQL Server Copying dimensions using XML

  Hi, I have created a number of dimensions for a project, each with multiple hierarchies etc. Now, due to a late-breaking spec change, I have had to quite seriously alter the underlying DSV, and without thinking about it I renamed it as well. As far as I can tell, using the VS UI, I will have to re-create these dimensions from scratch, using the new DSV. Is there any way I can re-use the existing dimensions and edit the XML to point to the new DSV The particular tables for these dimensions are not changed (though the relationship to the fact is). I tried a simple change on the <Data Source View> attribute, but as expected th ...Show All

• Visual Studio Can ItemGroup be refreshed?

  I have a MSBuild project which creates some files, and then ZIPs them up in to an archive. This is a simplification, but let's say I have this ItemGroup to specify all of the files that I want in the archive: <ItemGroup>   <ArtifactFiles Include="**/*.dll"/> </ItemGroup> And I have this target to build the DLL's. <Target Name="compile">   <MSBuild Projects="src/App.sln" /> </Target> I then have this target to ZIP up these DLL's <Target Name="artifacts" DependsOnTargets="compile">   <Zip Files="@(ArtifactFiles)" ZipFileName="Artifacts.zip" /> </Target> I build t ...Show All

• Windows Forms How to drag an text item from a listview to my custom host designer?

  I have a listview which has text items, not toolboxitems, should be dragged over controls in my custom host designer. I'd like to enable the link dragdropeffect when drag a listviewitem over controls. When user start draggin from the listview, the following codes are used: //selectedMappedControl is the text of the selected listview item if (! string .IsNullOrEmpty(selectedMappedControl)){ DataObject d = new DataObject (selectedMappedControl); lvMapped.DoDragDrop(d, DragDropEffects .Link); } I used a global behavior to capture the dragenter event when the listviewitem is dragged into the host designer. public ...Show All

• .NET Development How to get the result of Sql Views in ADO.NET?

  Hi,  Which is the Sql class to be used to get the result of an SQL VIEW into a dataset Thanks in advance. Just like you would load from a table or a dynamic SQL query. See the documentation on SqlDataAdapter for an example (the "query" argument can be a table name, view name or select statement). ...Show All

• SQL Server RDA pull problem

  Hi, I am new to SQL Mobile programming. I am using SQL Server 2005 Mobile and SQL Express. I have a mobile windows application + .sdf file in the PDA. When i try to pull the table the first time, the table is successfully retrieved to PDA. When i try to pull the table again, i get the following error: "An unexpected error has occured in TestDb.exe. Select quit and then restart this program, or sleect details for more information. A duplicate value cannot be inserted into aunique index. [table Name=_sysRDASubscriptions, constraint name=c_LocalTableName] " The above message indicates, that the table is existing in "_sysRD ...Show All

• Visual C# Try Catch Finally

  Hi Does Try,Catch,Finally block slow down application's performance Why Where I can find the documentations or EBook about C# 2.0 Thanks. Yes, it absolutely slows it down. You should not use it to control program flow, only to catch exceptional circumstances, such as errors. amazon.com has plenty of books on C# 2.0, some of the Microsoft published ones are terrific. ...Show All

• Windows Forms Any 3rd Party 'Compile As win32"

  Does anyone know if any products exist that let you compile as "windows forms" application as a "Win 32" application. I've heard this is somewhat possible by compiling the .NET libraries (or atleast the ones used in the application) into your application, and creating a Win 32 app from all of it.   I still don't like the fact that s ...Show All

• Visual C++ msvcr80.dll Problem

  Hi there, can someone possibly tell me why Noton WinDoctor is telling me that 10 executables in the .NET Framework 2.0 cannot access the necessary dll file msvcr80.dll I see that the dll exists in the WinSxS directory and I'm running XP pro. I didn't have this problem until I downloaded the 2.0 framework at windows update. Any advice appreciated. Thanks. Naolin I am having the same problem... I even uninstalled it.. and it didnt show a problem then I reinstalled the update and it showed up as a problem in the Windoctor again... any ideas as to what is wrong with this update Im sure its a simpl ...Show All

• SQL Server How to insert a byte() to a blob column?

  Hi everybody,     I don't where to asked this question in this forum. How do you insert to a column of a table with a blob or binary datatype if there is one, from a byte() datatype  What is wrong How can I fixed this I need help. Thanks. Code: string sqlText = "Insert table1(id, dataByte) values('" + id + "'," + byteData + ")"; OdbcCommand cmd = new OdbcCommand(sqlText, odConn); //opening connection here int iRes = cmd.ExecuteNonQuery(); Result:   iRes = -1  den2005 parameterize,  parameterize, parameterize   read up on parameters on a side note - never build s ...Show All

• Windows Forms Displaying images on a form using code

  I was looking if someone can give me some help with my code. I need to know what the best way would be to have a dialog box that returns an array of image filenames and use that array to create a new picture box for each image that was selected and display it on the form Should i use a for loop or a foreach loop I think I just need help figuring out the best way to create a new picture box for each image. What I plan to do after the images are displayed on the form is let the user select which images he would like removed. Once all the he wants are selected and displayed on the form I will then copy the images to a new directory. Here i ...Show All

• SQL Server from Express to 2005? - How to?

  I have a database on SQL 2005 Express and i want to restore in SQL Server 2005 Beta 2 but it's not accepting it so how can i do it please any tool I assume you want to go from the RTM build of Express 9.00.1399 to the Beta build of SQL2K5. If that's the case you cannot do that. Some where between Beta 2 and RTM (I think it was around the March 2005 CTP) the format of the database changed. We supported moving forward but not going backward. I'm not aware of any tools that will allow you to go backward. ...Show All