Rajesh batchu's Q&A profile

• SQL Server where can i put my stored procedure

  hello friends i am doing databases shrinking.i take connection as as admin of sql. every thing is write i need to shrink all my databases. i written one stored procedure ALTER PROCEDURE [dbo] . [SHRINK_SP] ( @TABLE varchar ( 15 )) AS SET NOCOUNT ON ; EXEC ( 'DBCC SHRINKFILE (' + @TABLE + ', 0)' ) EXEC ( 'DBCC SHRINKTABLE (' + @TABLE + ', 0)' ) but i dont know where to execute this stored procedure if i execute this stored procedure in one datbases its working remaing thigs its not working how to solve my problem anybody help me.. thanx ya its 36% free space is there i need to write this should be one stored procedure because i have 8 Databases is there .what i am dev ...Show All

• Visual Studio Team System Build fails with MappingConflictException

  My team build failed with a MappingConfictException. The conflict listed was for an old workspace. I used the tf command line to remove the workspace, which it appeared to do because it doesn't show up in workspace lists any more, but the same conflict still occurs. Here's the error log: Target InitializeWorkspace: DeleteWorkspaceTask Name="VPCBUILD001_DesktopIntegration_Nightly Build" TeamFoundationServerUrl="http://tfs:8080/" Workspace VPCBUILD001_DesktopIntegration_Nightly Build does not exist. CreateWorkspaceTask Name="VPCBUILD001_DesktopIntegration_Nightly Build" TeamFoundationServerUrl="http://tfs:8080/" MappingFile="WorkspaceMapping.xml" LocalPath="c:\build\DesktopIntegrat ...Show All

• .NET Development How to query delete commands against table with ado.net?

  Hi, guess this should be really simple but seems as if I am just on the wrong track. All I want to do is delete every dataset in a certain table, which I would do with a query like that: "Delete From myTable" But how can I do that with ado.net I read through msdn-library but all I could find was something like: "myDataSet.Tables["myTable"].Rows .Delete();" Of course I am not willing to iterate over all my entries. Can somebody just tell me how I could do that otherwise Thanks! You can use a command object with the SQLtext set to: DELETE TableName.* FROM TableName; Where tablename is the name of the table in your dataset..and then use executeNonQuery to re ...Show All

• Software Development for Windows Vista DIFxAPI problem with DRVSTORE on XP upgrade to Vista

  I'm having trouble with the XP to Vista upgrade. I have a PNP Driver for our USB Devices. I use DriverPackagePreinstall to pre-install my signed drivers on Windows XP. They install correctly, and I can see them in the Windows\System32\DRVSTORE. I then use the released Vista to upgrade my PC from XP Pro to Vista Ultimate. I then plug in my USB device on the PC for the first time. It says that it can't find the driver, and asks me to point to locate the driver source. I look in the Windows\System32\DRVSTORE, and my driver is still there, Vista just doesn't seem to be looking there for it. Any ideas ...Show All

• Microsoft ISV Community Center Forums Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• Visual Studio Team System Making Area and Iteration Read-Only

  I would like to make the fields Area and Iteration appear as readonly to every group except 1. We have our product management team enter these values, so we do not want anyone else to have access to these fields. How would I go about adding this functionality I tried adding the "Read-Only" field for "Not" the Product Management group, and it worked on other fields but did not allow me to do it for these ones. Here is what can be done it's not bullet proof but is likely acceptable: In the <FORM> section of the workitem find: < Control Type =" WorkItemClassificationControl " FieldName =" System.AreaPath " Label =" &Area ...Show All

• Software Development for Windows Vista Unpredictable event reception in state machine workflow

  Hi, I'm relatively new to WF, and developing a state machine workflow project. The workflow runtime is hosted in a windows exe which raises events to it when requests come in from a browser UI via a web service interface on the host. This all works fine.. sometimes! Specifically, when I'm running in debug mode through VS, the events get fired and everything happens correctly the first time through. But when a second request comes in from the web service, the host raises the event, but the workflow never hears it. And when I run the service as an exe, the workflow never picks up the events. In either case, no error is raised, but nothing happens. The data exchange service and my own service for the workflow events are correctly att ...Show All

• Visual C++ VS 8 issue

  Hi, I am having a dll which uses a static library. I am dealing with opening and closing of files. My static lib is basically third party code which I could not understand much. However, I found that it is trying to close a file which has already been closed in previous function call. Everything works fine on VS7 but on VS8 it gives assertion in close.c line 48. ["\Program Files\Microsoft Visual Studio 8\VC\crt\src\close.c"] Third party code [Its basic C code] is using open() to open the files and close() to close the files. Any idea, what can be the problem and how it can be resolved Can I put a check before calling function close() to check whether is open or not Thanks, Rama No, third part ...Show All

• Visual Studio Express Editions Different Coloured Brushes

  How do I change the brush colour so that each square is different I was thinking of using an array, Dim arrCol() As String = {"Red", "Yellow", "Green"} but string can't be converted to system.brush. I tried Dim arrCol as System.Brushes, but that doesn't work either. So any ideas please. Here's the code, Dim B1 As New Bitmap(146, 92) Dim G1 As Graphics = Graphics.FromImage(B1) Dim PB As New PictureBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim X, Y, W, i As Integer X = 0 Y = 0 W = 128 For i = 1 To 40 G1.FillRectangle(Brushes.Blue, X, Y, 16, 16) X += 18 If X > W Then X = 0 ...Show All

• .NET Development Web Service Schema Validation

  I'm looking for a way in which I can validate the XSDs/schemas calls via Web services. My application is very basic however it has a strong dependency on these XML requests and as a consequence I would like to detect as best I can.   As such there is anybody know of any good examples/demonstrations of best practices that will show how I can best implement this, ideally using 2005   Your help would highly appreciated   Thanks in advance Paul I guess both upon reflection - however recent investigation has lead me towards WCF and i'm curious - whether or not i can use this to help me solve both these scenarios ...Show All

• Visual Studio Team System get latest on checkout macro with prompt

  I want to implement the get latest on checkout macro mentioned before on this forum, but I would like to get prompt with warning, that newer version exists on server then I have. Thanks Can you point us to the location of that macro ... there are way too many things on the forums right now and it takes too much time to find the exact thing. Either way I think your question is about programming a message box within the macro or obtaining information from the OM so you can display the correct thing. For the message box just read documentation online on the language the macro is written on and for TFS API and OM questions reference our SDK documentation. thanks, mario ...Show All

• Visual Studio I need help with installing SQL Server 2005 Express

  Dear MSDN, I'm having a problem with installing SQL Server 2005 Express. In the past, I installed Visual Studio 2005 Beta (with SQL Server 2005 on it) and it runs fine. But I made a mistake uninstalling the beta version. I used the Control Panel and uninstalled the components in random order. When I installed the Express Edition, SQL Server 2005 Express failed to install, but Visual Studio 2005 Express is running fine w/o SQL Server on it. I need to install SQL Server 2005. Please help me how to fix this. Thanks. Hi, sory for the late reply. I uninstalled the VS 2005 express edition then i used the clean-up tool to remove the remaining beta components, but the tool also failed to clean ...Show All

• SQL Server Report Model with XML datasource

  Is there a way to create a Report Model with XML / WebService as datasource I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer . I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not. ...Show All

• Visual Basic Multithreading cancellation Methode

  Hi All, Lately I explore about multi threading,because there is a urgent need to implement this feature.I came up with a case of multi threading cancellation. There is two kind of multi threading we have. 1. threading in the program itself. ex. Private Sub Worker_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles Worker.DoWork Dim intI As Integer Dim intJ As Integer Dim intK As Integer Dim counter As Integer For intI = 1 To 20 For intJ = 1 To 20 For intK = 1 To 20 counter = counter + 1 'DO SOMETHING HERE Next Worker.ReportProgress(counter / 8000 * 100) Next Next End Su b 2. threading t ...Show All

• Visual Studio Express Editions Can't close com port

  Hi After my program sends and receives data with the serial port, it hangs up. I've tried inserting comPort.close() in variouse places but it doesn't work. How can I close the com port Imports System.IO.Ports Imports System.Text Public Class Form1 Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strOutput As String Using comPort As SerialPort = My.Computer.Ports.OpenSerialPort("COM1", 19200) comPort.Encoding = System.Text.Encoding.GetEncoding(28591) 'comPort.DtrEnable = True strOutput = Chr(&H24) & Chr(&HDB) & Chr(&H0) _ & Chr(&H0) & Chr(&H1) & Chr(&H4) & C ...Show All