Salman Maredia's Q&A profile

• Customer Care Framework Error while opening Admin Console through MMC.

  I get the foll. error when I try to connect to the CCF IIS server in MMC to configure Admin Console. I get the same error while debugging Agent Desktop. I verified that 'Microsoft.Ccf.Common dll is present in GAC. Please help/advice on this issue. System.TypeInitializationException: The type initializer for 'Microsoft.Ccf.Common.Logging.Logging' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Ccf.Common.Listeners.Configuration.ListenerConfiguration' threw an exception. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Ccf.Common, Version=2.6.0.0, Culture=neutral, PublicKeyToken=4f00c1aa5320a4d9' or one of its dependencies. The system cannot find the f ...Show All

• SQL Server Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS ...Show All

• Windows Forms Accessing objects on a form via a class

  I have a form with a text box and I need to access the textbox and some other events within the form class from a seperate class. How can I get access to that textbox The form is making a call to a method within the class class.getCommand(command); and then the getCommand method needs to be able to modify the textbox within the form. Any suggestions would be great! Thanks! Scionwest Hi, this overview and sample may point you in the right direction: http://themightycoder.spaces.live.com/blog/cns!EBFBA22CD769E10B!144.entry Mark. ...Show All

• Visual Studio 2008 (Pre-release) Support for templates in WPF Deisgner?

  We're building a large WPF application. In order to provide some consistency of UI, we're using a lot of <DataTemplate>s and <ControlTemplate>s, in application resource files. When I design a <Window> or a <Page>, I have to specify the appropriate template for every child control. If I attempt to use the designer on such a xaml file, it immediately starts adding properties to the actual controls themselves (Width="xxx", etc.). Is there a way to turn this behavior OFF Also, is there a way to work with the templates in the designer directly (right now, I have to edit the template xaml code manually - it would sure be a lot easier if I could use the designer). Thanks, in advance, for any help anyone provides ...Show All

• Windows Forms Datagridview cell coloring problem

  I have created the two datagridview control named: dgvDBtemplate1 and dgvDBtemplate2 with 2 columns one column of type DataGridViewCheckBoxColumn and another column of type DataGridViewTextBoxColumn, added at the design time. Now what need is to color the selective DataGridViewTextBoxColumn of dgvDBtemplate2 when the CellContentClick event is fired from the DataGridView named dgvDBtemplate1. I managed to to get the particular cell of dgvDBtemplate2 that is to be colored and applied the property as: dgvDBtemplate2 .Rows[idxGrid].Cells[0].Style.BackColor = SystemColors.MenuBar; The property worked but the problem is that instead on coloring single cell, it colored the whole cells. Pls, let me know how to solve this problem. Thank you ...Show All

• SQL Server CASE Statement

  Hello All, I have a condition for which I am trying to write a case statement as follows.. SELECT @Segment_Field = 'Acct_Status_' + CASE @Public_record_Type WHEN NULL THEN ' ' WHEN 'BP' THEN 'BP' + ((CASE @Bankruptcy_Type WHEN NULL THEN ' ' ELSE '1' END) OR (CASE @Acct_Status WHEN NULL THEN '' ELSE '2' END)) END But this is not working.The condition is actually tht I have to set the value for the variable @Segment_Field acc to the value of variables @Bankruptcy_Type and @Acct_Status. It should first check for @Bankruptcy_Type and if it is not null then the value should be Acct_Status_BP1.Then it should check for @Acct_Status and if it is not sull then the vlaue should be set to Acct_Status_BP2. Can somebody please ...Show All

• Visual Studio Tools for Office VSTO project crash MS Word and Outlook

  hi, i'm working with [2005 .net version] C# on a VSTO project the problem i'm having is when [MS word, Outlook, or my program] any of these crash; all 3 if running will also crashing. i wonder if there is a way in VSTO to run your project as it owns instance of MS word. I don't want to user to lose the data just because one of these crash When i run my VSTO project then turn on MS Word or Outlook; i only see one WINWORD.EXE in the Task Manager. I'm expecting to see two WINWORD.EXE in the Task Manager for this case Thank in advance Paul Unfortunately this is not possible. Word application is designed in such a way that all its windows/frames share the same processe. Although it is possible to ...Show All

• SQL Server installation issues~

  I am unable to download security updates for Outlook 2003- the message I got is: Error Code: 0x80070641... when I tried installing any of the service packs (1,2, & 3) I am unable to as well. The message I get when doing this is: The expected version of your product was not found on your system. How can I fix this Thank you, Ramzer This is the SQL Server forum. My suggestion would be to locate an Outlook (or security update) forum and post the question there. I tried looking for one, but couldn't find it quickly. You could also post in the "Where's the forum for " to see what they suggest. Thanks, Sam Lester (MSFT) ...Show All

• SQL Server Alternative for Cursor use

  I am having a table that has a column called sequence which stores the sequence of Chapter and can be changed by user.Sequenece can vary from 1 to n. Structure of table is Id int CourseId int Chapter varchar Sequence int and sample data is Id CourseId Name Sequence 1 92 Chap1 1 2 92 Chap2 2 3 92 chap3 3 Now, when i delete second record i.e. Id=2, I want that sequence of Id=3 should become 2. For this I am using cursor. CREATE TRIGGER [Et_TriggerReOrder] ON [dbo].[ET_CourseChapter] FOR DELETE AS BEGIN DECLARE @id as integer DECLARE @Sequence as int DECLARE @Count as int DECLARE REorder_cursor CURSOR FOR SELECT [id], [Sequence] FROM ET_CourseChapter WHERE courseid = (select courseid from deleted) order by [Sequence] OPEN REorder_cursor FET ...Show All

• Windows Forms Listview Column Widths

  Hi, I have inherited a program with a listview with various columns, only some of which are visible to the user. Problem is that the user is able to resize the columns of the 4 columns they can see, but what is happening is that they occasionally get to see the data of the columns with width set to zero. Know I haven't explained that well, but basically what I am after is a way to "lock" the column width of certain columns but not others. Any ideas gratefully received, or confirmation that it cannot be done , if that is the case... but then I will have to bash my head against the wall!!! Thanks       You can do it by handling the ColumnWidthChanging event: Pr ...Show All

• SQL Server SQL Native Client issues?

  This issue sounds a little like the "SQL Server Destination" issue that this forum answered earlier. Thanks in advance for your responses! I am deploying the first packages to the (64-bit) server (SQL-2) from my (32-bit) workstation. I've managed to make the AS400 OLE (IBMDASQL) connection work, but the "Microsoft SQL Native Client" connection isn't doing so hot. There are two different problems; the elusive error code 0xC0202009 issue and a "Login failed for user 'sa'" error. In the second case, I need to provide a password (and later down the road, another SSIS-specific username). But I don't see any facilities for doing this that would be appropriate for the 30+ packages I'm eventually going to deploy. Stra ...Show All

• SQL Server What is the best way to copy database?

  I want to copy database (offline) to another machine. I can generate SQL script for table structure and stored procedures. But how can I easily copy data As far as I know, 1. Detach and attach is not 100% working if I copy the another machine with different version of SQL Server 2. Restore and backup is for the same machine 3. DTS is for online copying only Please help me. Thank you. Actually, I used to do this all the time as well... until one day when I thought the job was done, but the application would not login to the database. When I went into EM it was suspect. I did everything I could think of and could not get it out of suspect mode. I finally coughed up $245 for a per incident charge and we recove ...Show All

• Visual Studio 2008 (Pre-release) InstanceContext initialization, IContractBehavior and IContractBehaviorAttribute

  I want to basically hook into InstanceContext initialization and, via what little I could find in the documentation , IContractBehavior seems to be the way to do it. So, first question is: is this the right approach If so, the documentation for IContractBehavior claims that there are two ways to hook the behavior into the flow of things: Programattically to add it before ServiceHost.Open. Implement a custom IContractBehaviorAttribute. I'd rather not do option #1 because it just feels so anti-configuration/declarative which is what seems  to be one of the great things about WCF. However, given the lack of documentation around IContractBehaviorAttribute, I'm lead to believe it's not a much better route because y ...Show All

• SQL Server capture delta

  how can I capture delta in SQL Server 2005 to refresh base tables in a data warehouse When you install SQL Server, by default it will also install SQL Server Books Online, the product documentation. Try looking "SCD" up in the index, it has an entry "SCD transformation". This will take you to the "Slowly Changing Dimension Transformation" topic. Here is the online link as well- http://msdn2.microsoft.com/en-us/library/f8849151-c171-4725-bd25-f2c33a40f4fe(SQL.90).aspx There are products out there that can read a transaction log, Apex SQL, Red-Gate, Lumigent all have them, but I think they are all interactive tools, rather than a way of capturing and replaying the statements. You could use SQL Trace (Pr ...Show All

• Smart Device Development Breakpoints do not get hit...

  Hello,   a colleague has big troubles debugging compact framework 2.0 applications from his VS2005 environment (to be more specific: he has hijacked my PC because the troubles do not occur there ). The problem is that every CF2.0 application he runs will not break when run on a device, but the same application runs and hits the breakpoints on the device emulator. It doesn't matter if it is a big multi-project solution or just a simple little HelloWorld project, the debugger just isn't interested in breakpoints anymore.   We searched over this forum, but none of the solutions work for him. Some of the things we found and tried are: Deleting de bin/obj folders. Showing the Debug toolbar. ...Show All