Sukhbir Dalal's Q&A profile

• SQL Server Dialog Security questions

  Hi Remus Thank you for the email reply. However i am still not 100% clear, dialog security with certificates when there are hundreds of remote services seems a bit complicated. I have a few more questions. 1. you said " When sending the first message (any direction), we look up the 'best' certificate for each user " My inititor sevice is owned by dbo, i have created certificates only for named users not dbo, how would this work 2. I am going to try settin gup this again, but at the central service i will create a seprate user for each remote service, authorize the remote certificate for this user and use this user in the remote service binding for that remote service, is this correct or am i still doing somehting wrong ...Show All

• SQL Server CLR Stored procedure

  Can I create a CLR stored procedure in VB or C# to print a file. Please give the code sample All you would need to do it create a SQL Server project, add a stored procedure class, write your printing code inside there, and then deploy it to the database. You probably shouldn't be doing this though. Any CLR stored procedures or functions should abide by the same principles as the database, which is to not rely on any resources which may not be there. Communicating with a printer is prone to this type of problem as the network may be down, or the printer may be off or out of paper etc. Therefore it shouldn't really be a stored procedure. ...Show All

• .NET Development Change assembly name stops de-serialization of old data

  VS2005 c# I am trying to work out why changing the assembly name should stop deserialization working, I thought I had it after creating a SerializationBinder to rewrite the assembly name, and this works with a very simplified case, however on our main application a TargetInvocationException is thrown which seems to refer back to the original assembly name. - InnerException {"Could not load file or assembly 'TeletestMock, Version=1.0.0.2809, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.":"TeletestMock, Version=1.0.0.2809, Culture=neutral, PublicKeyToken=null"} System.Exception {System.IO.FileNotFoundException} Does anyone have any ideas of what I'm doin ...Show All

• SQL Server Matrix SubTotals

  I have subtotal at the bottom of the matrix. I am using Distinct Count in the expression field of matrix. But when I run the report, The Subtotal is giving the sum of all not the Distict counts. I can see the properties of Subtotal row. But I can not find the expression Property for that. Please help me anyone know it or had this issue. I appreciate your help. Thanks in advance Rams Hi Hammer, I'm sorry to have to inform you that this is in fact not possible. There has been much contravercy about this and it has been causing many people headaches including me. Thus we have been using this very tedious and redundant workaround.If you follow this link you see in the newsgroup discussion tha ...Show All

• .NET Development Is it possible to get method's parameter values in runtime?

  Hi all. I want to get method parameter's value in runtime. It's for debugging and error handlering purpose. How can I implement GetMethodValue() method below System . Reflection . ParameterInfo contains meta data not value of param. Is it possible or not Please help me with any comment. private void Test( string s, int i) { object[] values = GetGetMethodValue(); //values[0] is value of string s //values[1] is value of int i Utils . GetMethodName( 0 ); } public static object[] GetMethodValue() { } public static string GetMethodName( int stepBack) { System . Diagnostics . StackTrace stackTrace = new System . Diagnostics . StackTrace (); //use 1 to return parents method. //us ...Show All

• Windows Forms Where can I access the commandTimeout property in a DataAdapter

  It boggles me that I found this same question in the forums twice and noone from MS has commented on this BUG. I went into the Generated code and found this procedure and added the commandtimeout line. But this is not the way to do it because it gets written over anytime the dataset designer is updated. Private Sub InitCommandCollection() Me ._commandCollection = New System.Data.SqlClient.SqlCommand(0) {} Me ._commandCollection(0) = New System.Data.SqlClient.SqlCommand Me ._commandCollection(0).Connection = Me .Connection Me ._commandCollection(0).CommandText = "dbo.spRaChecks" Me ._commandCollection(0).CommandTimeout = 0 Me ._commandCollection(0).CommandType = System.Data.CommandType.StoredProcedure Me ._comm ...Show All

• Visual C# Run exe from command prompt

  Can i create a console application to run a exe in the ms-dos prompt, on a timer application Has anyone every done this before If so can someone shoot me a link thanks So i should do something like...... static void main(String[] args) { //go through each element in args and pick out the arguments passed and act upon it for(int i = 0; i < args.length; i++) { args[0] = "Some arguement"; args[1] = "Another Argument" } } ...Show All

• Visual C# using vb6 component ?

  Hi, Is there a way to use vb6 components in C#, just like in old asp (Server.CreateObject)... I tried with Activator.CreateInstance but didn't worked...is continue to as kfor the reference... I think for that you need to typecast/convert object "c" to appropriate type. In your case it is recordset which is getting return. Hope following article helps you http://support.microsoft.com/kb/308611 and http://support.microsoft.com/kb/313330 ...Show All

• Visual Studio RefreshReport closes my application

  I have an application with a reportviewer - the report works perfectly on my machine - when running at my clients machine - the app closes (no message, no execeptions, nothing in the event log...). I have nailed it down to the .RefreshReport method - as soon as this line is hit the app closes. The ReportViewer control is properly installed on the machine. Anyone experience this If an exception is being thrown, you should be able to see it in the debugger by unchecking the "enable just my code" option in Tools-->Options-->Debugging and by breaking on all exceptions. You won't be able to see the source code, but you should get details on the exception. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiuser games?

  Just curious... but has anyone used XNA/C# to develop MOG's or even MMOG's @jackline Yes, lots of people have created C# multiuser environments. Just look up client/server projects over at The Code Project, example (http://www.codeproject.com/cs/media/mdxsnake.asp). Easy, and good for a small number of players. That said... I've seen some MMOG C# projects, but honestly they don't get far off the ground. Mostly because it's hard to get the kind of support you need to make an efficient MMOG system. But also because an MMOG server should never be written in anything other than C/C++ simply because of the amount of data you need to move and info you need to process. One should never say never...but you do lose 15-20% performance moving ...Show All

• SQL Server Installation Error Sql Express 2005

  When I open the installation, everything is fine. The report says that I do not meet the reccomended hardware requirements, but I checked and I am above the minimum requirements. This is the report: System Configuration Check - WMI Service Requirement (Success) Messages WMI Service Requirement Check Passed - MSXML Requirement (Success) Messages MSXML Requirement Check Passed - Operating System Minimum Level Requirement (Success) Messages Operating System Minimum Level Requirement Check Passed - Operating System Service Pack Level Requirement. (Success) Messages Operating System Service Pack Level Requirement. Check Passed - SQL Server Edition Operating ...Show All

• Visual Studio Team System View History Errors

  We are getting errors on some files when we try to View History. Event Type: Error Event Source: TFS Version Control Event Category: None Event ID: 3000 Date: 10/5/2006 Time: 2:27:19 PM User: N/A Computer: TFS1 Description: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 10/5/2006 9:27:19 PM Machine: TFS1 Application Domain: /LM/W3SVC/3/Root/VersionControl-2-128045557970820364 Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details: Process Name: w3wp Process Id: 5716 Th ...Show All

• SQL Server Designing SSIS package to Cater to SQL Queries invloving multiple joins

  I have  a query that works fine in SQL Server, SELECT TC.[TestId] ,TS.[NameId] ,[regressionLevel] ,Mstr.[MethodId] ,users.[UserId] FROM [db_db].[dbo].[TEST] TC join [NEW_DB].[dbo].[Users]users on users.FirstName=TC.Username join [New_DB]..[Method_Master] Mstr on Mstr.Description=TC.Method join [New_DB]..[TestSource] TS on TS.Name = TC.TestName basically there is a join between three tables to repalce all the varchars to the corresponding ID. Please guide me in how should I go about in designing my SSIS package to achieve this requirement.   thanks in Advance   MShetty wrote: Jamie Thomson wrote: So you have a natural key in y ...Show All

• .NET Development Object Oriented

  Hi, I'm having a problem with OO and CompoBoxes I wrote this code to get drives and then create an object contain some information. My problem is how to add this object to a combobox and then display only a proberty as a default property or something. This is a class for example: Public Class DCompoI Dim text_ As String Dim drivetype_ As IO.DriveType Public Property Text() As String Get Return text_ End Get Set ( ByVal value As String ) text_ = value End Set End Property Public Property DriveType() As IO.DriveType Get Return drivetype_ End Get Set ( ByVal value As IO.DriveType) drivetype_ = value End Set ...Show All

• SQL Server lookup task running very slow when deal w/big tables

  I try to convert a Procedure that join 8 tables with INNER AND OUTER JOIN, my understanding is that the Lookup task is the one to use and I should break these joins into smaller block, it takes a long time to load when I do this, since each of these tables had 10-40mill. rows and I have 8 tables to go thru, currently this Stored Procedure took 3-4min to run, by converting this to 8 Lookup tasks, it ran for 20min. has anyone run into this issue before and know a work around for this. Thanks Yes, I am setting 500mb Cache size and select 3 integer and 2 varchar(50) fields only, I also try to re-arrange the lookup tables, but since all of them are big, it's limited what I can do by re-arranging them. The ...Show All