swapna_n's Q&A profile

• SQL Server Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike   Does the file have to be added as an archive to 7-zip  Is this the only way that it will work   It gets all the way to the folder that needs extracted and stops.  Here is what my expression looks like:   7z x "C:\Documents and Settings\mroush\Desktop\Cnet Apps File\OSU.zip\usr" p-mr1   Mike ...Show All

• .NET Development Using XML to select a user

  Hello all, I am trying to create a program that presents the user with a text box where they enter a number it logs them into a system where they have specific things they can do and some they (possibly) can't. I would like to use an XML file to do this. For example Number 0000 Logs in the user Jane. Jane has admin privileges Number 1111 Logs in Dick Dick can only access the Sales portion of the program. I'm not sure if XML is the way to go with this but it seemed to be the best choice. If you need a copy of my XML file I can post it. I think it is done correctly. Thanks Thomas XML allows you to store hierarchical data in a structured manner, sample XML for your problem might look something like: <U ...Show All

• SQL Server How to kill running query?

  Hi! Our users often run malicious queries which could take up to quarter of CPU power for couple of hours. If there is more that one such query, the whole environment is severely impacted with no other recovery that restarting the service. Is there any (easy) way how to kill unwanted connections and related queries If not, could someone please give some explanation for that (is it design issue or what ). Otherwise I'd like to see that functionality in SP2-3. Someone with similar experience out there Absolutly. You can use any client, not only AMO to send a Cancel command. For instance, you can use ActivityViewer sample application to cancel user sessions, or user connections. Connect to Analysis ...Show All

• SQL Server Unable to truncate transaction log -- Replication was the problem

  I'm posting this because I just did quite a bit of searching on dealing with a huge transaction log that wouldn't truncate and didn't run across the solution for my issue, so I thought I'd post it here to help others. We had a Sql Server 2005 that had a huge transaction log and we were backing up the transaction log regularly. We couldn't get the log to shrink because sql server said it was in use. Turns out the problem was that we had played with having the database push a few tables to several sql server express edition databases via the builtin replication mechanisms. Those machines were no longer attempting to replicate however we hadn't turned replication off at the server. As a result it was leaving entries in the transaction ...Show All

• SQL Server sp_createstats change

  I am trying to create a procedure based on sp_createstats with no luck. Basically what I am trying to do is not create stats for a calculated field that I have many indexes on because it kills the SP execution. I created a new SP with the same internals as sp_createstats with the only modification was to one where clause. The problem is not that it gets it list from master instead of the database it is in. it still tries to run in the correct db though. Do you think I am missing something here or is there another way of doing this The option to create and update stats is on by default in SQL Server 2000 & 2005. You don't need to do anything special. You can optionally turn on async update of ...Show All

• Visual Studio 2008 (Pre-release) Listview: dynamic loading content possible?

  I've got a listview containing a GridView. I'd like to fill the content of this listview dynamically. So, instead of loading all my items (could be thousands) into an observablecollection I'd like to give the ListView the count of items, and just load those items that are displayed right now. To get this data from the database is no problem, but I need a way to know which lines I need to load to be displayed right now, need to know when scrolling, resizing or similar is changing these. Is there any known way to achieve this Thanks, Sam You could write your own descendent of ViewBase that adds paging You would also need a paging descendent of ObservableCollection Then you could notify the ne ...Show All

• Visual Studio 2008 (Pre-release) Grid resizing to fill the window

  Hi, I have the following Xaml: < Window x:Class = " xamlWindowsApp.WithGrid " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " xamlWindowsApp " >   < Grid Name = " grdMain " Width = " Auto " ShowGridLines = " True " > < Grid.ColumnDefinitions > < ColumnDefinition Width = " Auto " /> </ Grid.ColumnDefinitions >   < Grid.RowDefinitions > < RowDefinition Height = " 134 " /> < RowDefinition /> < RowDefinition Height = " 20 " /> </ Grid.RowDefinitions >   </Grid> </Window>   ...Show All

• Software Development for Windows Vista Does WWF itself be totally written in dotNet (C#), or written in C++?

  Does WWF itself be totally written in dotNet (C#), or written in C++ Are you asking if you can write a workflow in C++ The answer is yes - you can build a Workflow or an Activity (since a workflow is an activity really) in any language that targets .NET - C#,VB.NET, C++/CLI, JScript.NET, etc. But the designer support is only available for C# and VB.NET. I could see reasons to do activities in C++/CLI when you are integrating an activity with a C++ library or API. ...Show All

• SQL Server INDENTITY_INSERT

  Hello. A question please. When I run my applicacion which use the table1, I get this message: Cannot Insert explicity value for column in table 'table1' when IDENTITY_INSERT is set to OFF. could anyone help me An field (column) that is defined as IDENTITY is similar to a 'Autonumber' field. Under normal circumstances, you don't add values to this field, the values are determined by the database engine to be the next in sequence when the row is added. The error indicates that you are attempting to add one or more rows where that field value is included. Normally, you don't want to include that field in your row. However, if you are moving data from a source where the field already has a va ...Show All

• Visual Basic converting datagrid control to html table

  I have several datagrid controls in an application i am finishing up on, i need to output the contents to an html file, so i need to convert the datagrid control into a html table, their wouldn't happen to be any easy way of doing this rather then going though cell by cell, extracting the contents and adding it on to a string along with the html code to make it a table is their well from the sounds of it your idea is harder to impliment, i think i'll stick with my idea, i just need some help doing so. Here is my Pseudo Code: - Create a string, start off with the <table> tag - Go though each cell one-by-one - Extract the contents - Wrap the contents in the necessary HTML tags - Append the result to ...Show All

• Windows Forms Scrollbar.value cant be set to scrollbar.maximum

  In a windows form app it's impossible to set the value of a scrollbar (hScrollbar or vScrollbar) to it's maximum by moving the thumb or clicking the scroll arrows. The value will be no higher than approx. 90% of the maximum. It makes no difference whether the maximum has been set in the IDE or from code. Repro: - create a new Windows application - add a scrollbar and a label to Form1 - add a scroll handler to the scrollbar and add the following line to it: label1.Text = "Maximum: " + Convert .ToString(hScrollBar1.Maximum) + " Value: " + Convert .ToString(hScrollBar1.Value); - run the app and try to set the scrollbar to it's maximum value I can't imagine that no-one has encountered this befo ...Show All

• Software Development for Windows Vista State Machine - Resume Workflow with newer version of the workflow library

  Hi all, Is it possible to have a persisted workflow instance resume on a newer version of the workflow webservice I've got a StateMachine workflow published as a web service and it works fine, but if you make any changes to the workflow and publish the webservice, it cant resume the workflow (IndexOutOfRange Exception). Is there something I'm doing wrong or is there a workaround / fix Thanks Hi, I've had a look at various dynamic update samples and can't seem to find anything that solves the issue that I am having. I have a State Machine published as a web service. Now I've changed some code within the code activities of a few of the workflow steps... Now I want to publish the up ...Show All

• Visual Studio Express Editions How to close an application from another application

  hi. simple question I hope how to close an application from another application ps. I made them both It's the same in VB as C#: use one of the many tools to convert, if syntax is a problem for you, for example: http://www.carlosag.net/Tools/CodeTranslator/Default.aspx ...Show All

• Visual Studio Tools for Office Controlling Excel's popup messages..

  Hi, I am using framework 1.1 and vsto 2003. Is there anyway I can stop Excel's own popup messages from popping up Is there any thisWorkbook or thisApplication property that controls it I want to stop popup warning messages such as do you want to save changes, or do you want to open another sheet and messages like that. Thanks, You really need to discuss this with the Excel specialists in the excel.programming newsgroup, as they'll be best able to describe what's possible and which commands you require to do it. The Office apps weren't designed to run without user interaction, as this KB article describes. You can limit messages to a certain extent (DisplayAlerts) when running macros, but you can't suppre ...Show All

• .NET Development Windows 2000 System.AccessViolationException

  I have an app that happily loads a dll, and then uses something as IntPtr = GetProcAddress ...delegate ... = System.Runtime.InteropServices.Marshal.GetDelegateForFunctionPointer(... and then obsessively calls the function that was just loaded. Now, in Windows XP, on lots of different computers, my app runs perfectly well. But then on Windows 2000 after a few thousand calls to the function I get an error like this: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at MyApp.MyClass.MyDelegate.Invoke(... Ideas No...but then I started getting a bunch of errors on XP when my remote class would raise an event, ...Show All