Bassam's Q&A profile

• SQL Server Identity columns

  Hello there, I am using sql 2000 dts package to migrate a databse to SQL Server 2005, everything works except for identity columns, SQL Server reorder the columns, and this breaks the referential integrity. Is there a way to stop that Your help is appreciated. Hi, hard to tell why this happens, becasue you didn’t provide any information about the settings of your dts package. One thing would to not migrate the identity columns and -treat them like integer columns / turn on the identity property later (With creating a new column, because there is no "identity" property) OR -Allow identity in ...Show All

• .NET Development Trying to create a generic shell context menu extension

  Hi, I'm developing a small file encryption program, and I was able to add a shell extension to decrypt files, as the installation package (within VS2005) offered the option to create a filetype, with associated icon and command ( launches the application, with the /d (decrypt) parameter, and the filename). Nice. But, what I would like to do, is create a shell extension, that displays for any file (except .s5 ones, if possible) - I guess using the * extension, a context menu which offers encryption of the file (simply launches the application with /e parameter and the filename). I've found documents on the MSDN built-in documentatio ...Show All

• SQL Server Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

  Hello all, I'm new with SP v3 and the Reporting Services of SQL Server 2005. I did a prototyp report and show it with "SQL Reporting Services Report"-WebPart, but I can't find the WebParts Report Viewer and Explorer in the WebPart Gallery. Please, could somebody give me a clue where the problem could be, or how I could isolate the problem area. Cheers Marc Hi , Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this. regards Sahu ...Show All

• Visual Studio Team System error starting VS 2005 beta2

  After installing VS 2005 beta2  I receive the next error when I try to start a new project (even when I start up VS and then close it without doing anything)   The Microsoft.VisualStudio.QualityTools.TestCaseManagement.QualityToolsPackage, Microsoft.VisualStudio.QualityTools.TestCaseManagement, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a ({A9405AE6-9AC6-4F0E-A03F-7AFE45F6FCB7}) did not load because of previous errors. For assistance, contact the package vendor. To attempt to load this package again, type 'devenv /resetskippkgs' at the command prompt. I removed every release of VS an SQL and inst ...Show All

• SQL Server I can't uninstall SQLEXPRESS

  Hi all, I have a strange problem here. How to uninstall SQLEXPRESS when it does not appear in the "Add/remove program" Another problem is that I can't connect to the local server using SQL Server Enterprise manager. This is the error that i got: "a connection could not be established to (My Computer name)\SQLEXPRESS. Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server. Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MC\SQLEXPRESS node) and try again. " I do not want to use SQL 2005 because of some issues. A ...Show All

• SQL Server Understanding SSIS data pump commit

  I am having trouble understanding how the SSIS data pump determines when to decide "The final commit for the data insertion has started/ended". On some tasks the rows are inserted one at a time every few milliseconds (shown by a default getdate() in a datetime column). In others the final commit occurs as I would expect at the end of the data pump task. There are times i want the data pump task to commit all records that are succesful, row by row and there are times I want an all or none situation. Can somebody explain why this behaviour occurs and how i can control which commit option I want the data pump tasks to use ...Show All

• .NET Development Communication Application server

  Hi all, I need to develope a communication layer between a windows application and industry field device. The windows application will read and write values from the device. I want to ask how to develope an application server of the layer that servise the windows application. The windows application will be the client and the server read and write the values. Please help. Best regards... Can you explain in little more detail 1. Where is the field device Is it on the internet or local network 2. What sort of communications exist between the windows box and the device 3. Are there three thi ...Show All

• SQL Server Client Agent Error: integrity violation

  Hello: I tried to do the merge replication between SQL 2000 database and the SQL mobile server on PDA with SQL server management studio from SQL 2005 and I have already successfully synchronized my PDA with one small SQL server database file. However when I tried to synchronized my PDA with another larger SQL server database file, I got the error on PDA as following: “ The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AuditCriterion, operation = Insert, RowGuid = {1ee9321d-f00d-410c-8d5b-08d4220d2627}]”. I have keep checking the size of sdf file during synchronization, I fou ...Show All

• SQL Server are you sql god???

  Hi all, I need the time that a stored procedure was created/altered. In sysobjects table, creation date of the stored procedure is logged. But if the stored procedure is altered this column is not updated. 1. Is last alter date of a stored procedure loged somewhere 2. If not, can I restrict users to "alter procedure" but not "drop/create procedure" so that they will have to drop and re-create procedures so sysobjects.crdate will always be updated.   I hope I will get a positive answer. Ata   Besides the create_date, there is also a modify_date in the objects catalog. T ...Show All

• Smart Device Development Unable to connect to the remote server

  i have a simple webservice which i am using in my pocketpc app. and i am calling webservice from pocketpc app. but being error : Error is: An unhandled exception of type 'System.Net.WebException' occurred in System.Web.Services.dll Additional Information: Unable to connect to the remote server i am not calling webservice on pocketpc app..... can i do i have a simple webservice which i am using in my pocketpc app. and i am calling webservice from pocketpc app. but being error : Error is: An unhandled exception of type 'System.Net.WebException' occurred in System.Web.Services.dll Additional Information: Unable ...Show All

• Windows Live Developer Forums For Future Contests

  If there are going to be future contests like this (and there should, as they rock!), please consider the following remarks/suggestions :) - Teams: Some people like to work in teams, and this usually gets quite nice results too. However, with the current prize set-up, it's rather difficult to work in teams because who gets the prize I suggest you either give out money (:P) or split it up in multiple prizes per app (have like something slightly bigger for the team leader, and 5 smaller items for the other members, take a look at counterstrike clan contests, I believe they have a system like that) - Examples: Have some example code or links fo ...Show All

• Visual Basic e.Graphics.FillElipse

  Good evening folks: As you probably know, I'm sort of a tinkerer-student developer, and I was working on creating a project where, if you select a radio button, the corresponding text box's background color will change to either red, yellow or green. Therefore, I was wondering if it was possible to change the shape of a textbox from rectangular to circular. Is it possible Thank you. IGFET909 Hello again, CGraus, and thank you for responding: I did some research within a book I had purchased in 2004 when I had begun study of Visual Basic .NET 2003 and came across Chapter 14, "Programming Custom Graphics", which to ...Show All

• Visual Studio 2008 (Pre-release) I keep getting this error, what is it saying...

  Error at element '' in markup file 'Window1.xaml' : Exception has been thrown by the target of an invocation.. < Window x:Class = " proctester.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " qa " Height = " 300 " Width = " 300 " > < Window.Resources > < DataTemplate x:Key = " dtProc " > < TextBlock Text = " {Binding ProcedureName} " ></ TextBlock > </ DataTemplate > < Hierar ...Show All

• Windows Forms How to improve Listbox performance in ADO.NET 2.0?

  I have a bunch of listboxes on my windows forms with a couple of thousand records in each one of them. It takes almost about a minute to load a form in .NET 1.1 We are migrating the application to .NET 2.0 and was wondering if there is any way to improve the performance in ADO.NET 2.0 so that the listboxes are loaded faster in .NET 2.0 I tried running speed test as per: http://msdn.microsoft.com/msdnmag/issues/05/11/DataPoints/default.aspx fig=true#fig6 and was really satisfied with the promising results. Please let me know if you have general tips / suggestions to improve performance of ADO.NET Windows Forms Application in g ...Show All

• Windows Forms TaskVision as Document WorkFlow

  I'm new to Windows Forms, but have been working with IBS VB for a while. Will TaskVision allow you to upload documents to the server  This link would allow me to create some kind of WorkFlow environment, so that Users are assigned stages in the cycle of a document. Anyone done/doing this cheers, Steve Mike - Thanks. I've just submitted a reque ...Show All