ssouki's Q&A profile

• SQL Server SQL 2000 Licensing with CALs

  Hi, I didn't find any other forum to ask this and I didn't find any matching post for my question, so I post it here: We have an application that is running on 2 web servers connected to a sql2000 server with a 2-processor license ... so I think there we have no problem no matter how many users are using our web application. But the web application is producing a huge amount of logs that we want to analyze on a distinct multi-proc sql2000 server with a huge amount of harddisk space that's running with CAL licensing (not really sure how many we have for that server). In a perfect solution we will provide access to the logs via our 2 web servers using the same application, but only for a given number of users (the number of users ...Show All

• SQL Server Changing the language in the Report Builder interface

  Hi @ all, I work on a german Windows environment and use the Report Builder. For showing details in their it is necessary to switch the German interface in Report Builder into English. I already tried to change my environment into English but it even after a restart it did not change the Report Builder interface.... I also tried to search all the XML-files for a language setting - with no success.... Does anyone know how to do this Would be very helpful....! Thanks in advance, Jochen First: thanks for the answer :-) Second: it does not work ;-( Maybe my explanation wasn't precise enough: I'm talking about the Report Builder on the Report Server, which is controlled and used via Intern ...Show All

• .NET Development Attribute inheritance and changing the attribute

  If I have a property, method, or event, which has a particular attribute, of a base class, is there any way of changing that attribute in a derived class without creating a re-implementing the property, method, or event. By re-implementing I mean creating a new property, method, or event of the exact same name and signature. If the property, method, or event, which has a particular attribute, of a base class is virtual, is there any way of changing the attribute in a derived class without overriding the property, method, or event By overriding the property, method, or event In either case is it possible to add new attributes to the property, method, or event in a derived class without re-implementing the property, method, or event ...Show All

• SQL Server Create the package on the server, and execute through sql server agent

  Hi, Some of you guys seem to be gurus with the new Integration Services technology, so I hope someone can lend me some advice, as I haven't worked much with integration before. Ok, here we go. What I want to do is select some data from my database and export the result to a flat file (really a .csv file with values delimited by semicolons). Sounds like a simple thing to do Well, I'm sure it is when you know how to do it :) I know I could manage the same thing by writing a C# class that creates that .csv file, but the decision has been made to use Integration Services for these kind of operations. I created an SSIS project in Business Intelligence Development Studio, and created a package (I defined the task flow etc.). By choosing ...Show All

• Visual C# Build up a variable name with a string

  Hi, I wonder if there's a way (in c#) to build up a variable name by the concatenation of two strings...For example int intTest = 1; string strTest = "strTest"; string strTest+intTest.toString() = "this is my new var"; Thanks in advance James Curran wrote: What does Array have to do with the subject (where Column() is an Array) I am really sorry for a misstatement. The macros are not used in the constructor in VFP but you can use them to significantly simplify the constructor as I will show on C# example. I want you, James, to figure out how I can do it with Arrays in here. It will be very helpful for me. I glued up 24 statements from my ...Show All

• Software Development for Windows Vista where is CEAppMgr.exe? - Unable to Install Windows Mobile Software on Vista

  I purchased some third party software for my Motorla Q Smart Phone. When I try to install the PC portion of it on my Vista RTM Toshiba Tecra M5, I receive an error dialog indicated that the setup program cannot find CEAppMgr.exe. Any ideas how to correct this Thanks, -Howard Hey Howard, There are a few things you can try on your own to make this software work on Vista. First make sure during the installation that you are prompted for administrator elevation. If you are not prompted for admin, right click and select "Run As Admin". If the installation is not a .msi file, but an exe then you can attempt to make it run under xp compatibility mode. To do this: right click and go to properties. On the compatibility ta ...Show All

• Visual Studio Express Editions Setup Error

  When i'm trying to install VB2005 I get a error from BITS or something. So i've downloaded BITS and wanted to install. But then i get this error: http://img178.imageshack.us/img178/7981/bitserrorcw5.png What can I do about it Looking at the request i would go through a windows update and make sure that you have the correct patches and updates applied, then using the CD that you installed the OS with, go to the control panel and add the BITs components then windows update again, and try the install. ...Show All

• Visual Studio Team System TFS Server Setup Failu - ENU -- Error 28002.Error unknown.

  This is the third time I am trying to install TFS singler server setup. Everytime setup aborts with Retry or Cancel button. I have followed TFS install guide properly and have all the prerequisites installed. Please find the event log as well as excerpts from MSI log and Install log Event Log ---------------------- Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 10005 Date: 9/1/2006 Time: 2:02:05 PM User: VSTS\TFSSETUP Computer: SERVER2003 Description: Product: Microsoft Visual Studio 2005 Team Foundation Server - ENU -- Error 28002.Error unknown. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data: 0000: 7b 35 30 45 35 44 34 34 {50E5D44 0008: 43 2d ...Show All

• Smart Device Development Connecting from Desktop to a PocketPC SQL Database fails

  Hi, I'm working with Visual Studio .Net 2005. I'm trying to connect from a Desktop VB Application to a SQL Database on the Pocket PC. Every time I'm setting up the connection to mobile device, it is automatically resetted to the desktop working space. I can do what i want. It is never keeping the connection as I'm setting it up. On the first screen it states "mobile device" and after returning it is resetted. Does somebody out there have a hint. I don't know what to do nor where else to ask. I' m working with the German language in Visul Studio 2005 Thanks You can not connect from desktop to database on device programmatically. It appears developers believe they can ac ...Show All

• SQL Server min rights required to schedule a sql server job

  Hello, I need to create a user that can schedule jobs. I cannot use the 'sa' account. What rights should I assign this user Michael Here is the link to the Books Online topic for SQL Server Agent security: http://msdn2.microsoft.com/en-us/library/ms190978.aspx Cheers, Dan ...Show All

• Visual Studio Custom Project Item Templates

  Hello everyone, I am developing a new project wizard, and from it I am trying to use an existing project item from a template I created that is working fine. The problem I have is when I call GetProjectItemTemplate from the solution2 object, I get: The system cannot find the file specified. (Exception from HRESULT: 0x80070002) So, I started testing some things, and replaced my call for the custom template with a call to a microsoft supplied template, class.zip: string classTemplate = soln2.GetProjectItemTemplate("class", " csharp" ); I found that this works just fine. However, if i replace "class" with another microsoft supplied template, Form for instance: string classTemplate = soln2. ...Show All

• Windows Forms Two way databinding doesn't work?

  Hi guys I have a class which has a Dob (date of birth) property with validation rule (If user select a date early than 1920/01/01, reset the value to 1920/01/01. If user select a date later than .... ) inside it. Then I bind it to a Windows.Forms.DateTimePicker control and found out that the validation rule works but the new value won't be displayed on the DateTimePicker control until I manually call Form.validatechildren or Bindsourse.ResetItem method in Validated event of the DateTimePicker control. What do you guys think By the way, Yes, I do have INotifyPropertyChanged interface in the class and it works very well except the above problem. And also I know I can use the MaxDate/MinDate properties of DateTimePicker control in ...Show All

• SQL Server Selecting the Column Description in 2005

  I am migrating between SQL Server 2000 and SQL Server 2005 but hit a snag when attempting to write a query to display the column's description. I used this code with SQL Server 2000 to get the "Description" data. select o . name 'table' , c . name 'column' , p . value as 'description' , t . name 'datatype' , c . isnullable 'nullable ' , c . length , m . text 'default_text' from sysobjects o join syscolumns c on o . id = c . id join sysproperties p on o . id = p . id and p . smallid = c . colid join systypes t on c . xtype = t . xtype left outer join syscomments m on m . id = c . cdefault order by 'table' , 'column' How can I re ...Show All

• SQL Server ProcessAdd for dimensions

  I'm poking at some code that sends uses an XML/A ProcessAdd command to incrementally process a dimension. The command contains the out-of-line binding which specifies the query for the new rows. However, when the command gets submitted, I don't see anything that looks like the specified query in the profiler log. As I figure it, either: a) The command isn't constructed correctly. SSAS is claiming success, and the dimension is processed at the end, so if the command is wrong, then I don't know what SSAS would be doing instead (a full process a process update ). b) My expectation of seeing that query, or something like it, in the profiler log, is wrong. We also have ProcessAdd commands for partitions, and those queries DO end up being displa ...Show All

• Visual Studio Drillthrough: A data source instance has not been supplied for the data source

  I'm getting the dreaded "A data source instance has not been supplied for the data source" error when trying to load a drillthrough report. I'm using webforms and tyring to perform basic drillthrough functionality, where the main report displays a list of Reps and the drillthrough displays Rep Details. I'm using datasets that call stored procs. My dataset has one table. Here are the dataset details: File name: RepDetails.xsd DataTable: MyReports_GetRepDetails TableAdapter: MyReports_GetRepDetailsTableAdapter From the Report > Data Sources menu item, the datasource associated with the report file is: Name : RepDetails_MyReports_GetRepDetails Type: Database DataSet: RepDetails Table: MyReports_GetRepDetails Here's my ...Show All