BOCBoss's Q&A profile

• SQL Server SQL CE Installation Location

  Hi, When the battery dies the SQL Ce installation vanishes. Especially the following dlls which were copied into the \Windows directory during installation are getting vanished when the battery dies. sqlCese30.dll sqlCepqp30.dll sqlcemme30.dll sqlceer30EN.dll I guess this is because of the fact that RAM content vanishes when the power goes off. Is there a way i could install the SQL CE in the Storage Card I can install the Compact Framework in the Storage Card but not the SQL CE. I have installed the CF, My application in the Storage Card. Just because of this SQL CE does not allow me to choose the installation directory, i have to install the SQL CE everytime the battery dies out. I wou ...Show All

• SQL Server Import/Export data with SQL Server 2005 Express

  Hello folks! I have installed SQL Server 2005 Express and SQL Server Management Studio Express. Everything looks ok and works fine, but I can't find the Data Import/Export Wizard.  Can anyone tell me how to Import/Export data Thank you!!! SQL Server 2005 Express Manager does not offer Import/Export functionality as it is dependent on SQL Server Integration Services (SSIS) and SQL Server Agent.  You will need to optain the full version of SQL Server Management Studio. Peter ...Show All

• SQL Server Bypassing locks when doing insert or update

  Hi, I want to bypass locks while doing Insert or Update. I am only updating a log db and I don't care about one or two fields getting junk as I won't use it later (atleast as long as I am working with my current company ;) ) I am using MS SQL 2000 I am getting too many deadlocks and messages like these "Process ID was deadlocked with another process and has been chosen a victim. Please rerun the transaction". Please tell me how to achieve this. Regards, Noorul Thanks All I read about the clustered Index from Microsoft kb 169960. I created the clustered index with 70 fill factor. It has reduced the deadlocks down to zero. Actually I have an application that has 10 threads logging the sent SMS mess ...Show All

• Visual C# Save DataSet to Xml

  Is it possible to save DataSet to Xml file (or to something else) and to save RowState for each modified or added or deleted row I would like to have offline storage for data when server is not available and than to update data on server when becomes available. To achieve this I have to save data from DataSet locally and close the application. Later when server is available I would like to have simple method to update... to save data from Dataset to xml: theDataSet.WriteXml( filename ); to load the xml data saved from the dataset: theDataSet.ReadXml( filename ); ...Show All

• SQL Server Using Stored Procedures

  Hi The BOL says " Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only the first one is used.... " Is there any plan to have some feature which allows us to use the last result set returned by the procedure to use in the trports Regards; Rakesh If you have a stored procedure that returns e.g. 3 datasets and you only want to use the last one, you could write another wrapper stored procedure. This wrapper just calls the original stored procedure, ignores most datasets and returns only the last one. In RS, you would then call the wrapper to get the last dataset. -- Robert ...Show All

• Software Development for Windows Vista The UAC Nightmare

  I'm beginning to reach the conclusion that the current implementation of the UAC in Vista is, IMO, a nightmare that creates more problems than it solves. If Microsoft wants developers - and users - to embrace the UAC (instead of just turning it off altogether) then it better come forward with a LOT MORE information and support than it is currently providing! If it doesn't, I will begin to suspect Microsoft only added the UAC so it can tell Windows users 'well, we added the option to secure Windows - you're the ones turning it off' and therefore wash its corporate hands. I would really hate to see this happening. To name just a few of the problems the UAC brings to us developers: 1 - Applications that require Admin privileges are bloc ...Show All

• Windows Live Developer Forums request.locale needs a default value

  There is a flaw in the sdk examples. The search fails with an undocumented soap exception unless the request.locale is specified, generally "en-US" . Shouldn't this default to some value ...Show All

• Visual Basic retrieve ip and gateway for email

  I have been banging my head against the wall on this one. I need to retrieve the ip and gateway on all nics in the system and convert them to strings, so they can be put into an email for reporting. I have tried two ways. This one works for the ip, but not the gateway. Private Sub Gateway() Dim adapters As NetworkInformation.NetworkInterface() = NetworkInformation.NetworkInterface.GetAllNetworkInterfaces() Dim adapter As NetworkInformation.NetworkInterface For Each adapter In adapters Debug.WriteLine(adapter.Description) Dim adapterProperties As NetworkInformation.IPInterfaceProperties = adapter.GetIPProperties() Dim addresses As NetworkInformation.UnicastIPAddressInformationCollection = adapterProperties.UnicastAddresses ...Show All

• SQL Server Loading BLOB's to Database

  I have the file with binary data on my hard disk. Also I have the table in the database with image field. I want to load binary data from file to this field. Does any body know how can i do it I want to do it using only T-SQL, without any # (etc.) coding - only sql script is properly. ...Show All

• Visual Studio Team System How to get all the target branches for a given source branch through the API

  Hi, I'm trying to get all the target branches for a given source branch through the Object Model I didn't find any way to get this information. I'll be very grateful for some help with this issue. Thanks in advance, Shmulik. Richard, By the way, how do I handle baselsess merges at all in object model It is stated that once baseless merge is performed, the "merge" relationship is established; then if it is not accessible through GetBranchHistory, how do I access those relationships Thanks beforehand. Yours truly, Eugene ...Show All

• Visual Basic Standard Deviation

  Try as I might i cannot figure out how to code the Mean & Standard Deviation HELP!! Actually, you need to square each distance from the mean (which not only makes it correct, but as a bonus even makes each term non-negative). :) See http://forums.microsoft.com/MSDN/showpost.aspx postid=510627&siteid=1 . ...Show All

• Visual Studio 2008 (Pre-release) ComboBox doesn't handle NotifyCollectionChanged, when bound in code to a Collection

  I am switching the ItemsSource binding for a ComboBox on the fly, in code. When I do so, it appears that the ComboBox isn't registered for the NotifyCollectionChanged Event As a result, it does NOT pick up changes to the bound collection. I would expect WPF to wire this up automatically when I set the binding The short version: I was binding the ItemSourceProperty of ComboBox to an ObservableCollection which was implemented as a property on my Source object. When I did so, the combo box didn't pick up changes to the collection, even though I was firing the INotifyCollectionChanged event. I resolved the problem by deriving a collection class from ObservableCollection and implementing the collection as a ...Show All

• SQL Server FK Position

  Does it make any difference where we define the FKs in a table I mean, do I speed up the query if I define it as the second field or the last one What about the other fields, the ones that are not FKs, but are used as filters in a query Raul: In general, none of this makes much practical difference to speed of execution.  The two things that do matter are (1) do you have indexes on the foreign table in place that correspond to your foreign key and (2) does use of that index with a specific query also require a bookmark lookup for that specific query.  If the foreign key has a correspondence to the clustered index of the other table -- and that is often the case -- then no bookmark lookup is necessary.  If the foreig ...Show All

• Visual Studio Report Template not available

  http://www.microsoft.com/downloads/details.aspx familyid=4975F987-2132-4A45-A41E-DBE74F4583ED&displaylang=en I'm using the above template (a reports template) Withing the guidance for the template it explains how to extend the reporting. I have sucessfully created a dataset but when I come to add a new report item, I right click on reports in the 'Solution Explorer' then 'Add' then 'New Item' However I do not have a report item on the list as the example says I should. I am using the express versions of SQL Server 2005 and Visual Basic 2005. I have installed the report viewer redistriutable and I also have the Buisiness Intelligence module installed in SQL Server Manager. The instructions say that I should be OK with th ...Show All

• SQL Server Compositing a SQL Server 2005 web service into another Web Service

  I've developed a simple-minded SQL Server 2005 web service. What is the process to incorporate it into another web service This does not appear to be the same process as simply and generally consuming the service using all of the conveniences of a client-side application developed using Visual Studio. Can anyone point me to a good/functioning example Thank you, Tom ...Show All