Tim Dallmann's Q&A profile

• SQL Server Backup databases

  Hi I'm trying to setup a back up plan for a number of databases, I initially set up one plan to include all user databases which worked fine or so I thought, when I check them a few days later I noticed that some of the databases were not appearing in the backup set, the only way I could get these to appear is to set the comp level to 90, now when we run certain applications we get an error, when I return the comp level back to 70 then the application works fine, is there a reason I can not back up any database on sql 2005 without it being a comp level 90 Thanks inadvance I see that on my system as well. Is compatibility level 80 an option for you Databases with that compatibility level ...Show All

• Visual Studio Team System Does TFS support pure Kerberos environments?

  We are setting up a single-server deployment of Team Foundation Server (TFS), let's call that machine OURDOMAIN\TFSSERVER. Clients run Visual Stuido Team System (VSTS) and the client machines belong to the same AD domain. LAN authentication level has been configured with gpedit for all machines, clients and servers, to "Send NTLMv2 response only\refuse LM & NTLM". Further, Minimum session security for NTLM has been set to require "message integrity", "message confidentiality", "NTLMv2 session security" and "128-bit encryption". Unix servers manage Kerberos. 1) Is the above configuration supported by TFS (i.e. running TFS in a pure Kerberos ne ...Show All

• SQL Server Append new records from ODBC source

  I have created a data warehouse that pulls information from an ODBC source into a SQL database. The schema in the destination matches the source, and the packages clear the destination tables, then append all the records from the source. This is simpler than updating, appending new, and deleting on each table to get them in sync since there is no modify timestamp in the source. There are cases where I just want to append records from the source table that do not already exist in the destination table, without clearing the destination table first. How can this be done with a SSIS job Also, how can the job be run from a Windows Forms application Sorry, but I'm still at the 'first, you drag a data flo ...Show All

• Gadgets How do you Add a Picture?

  So far, my gadget is comming along well. I have red text and a red border. Now I am wishing to add two small pictures above and below the text. What is the code to add a picture <img src="myimage.png" style="..." /> If you want to change the size of your image, add "-ms-interpolation-mode:bicubic;" to the style to scale it with bicubic scaling. ...Show All

• Smart Device Development how do i read a file

  hi how do i read file in vc++ for smartphones You read a file on a smartphone the same way you do it anyway. E.g. /* FREAD.C: This program opens a file named FREAD.OUT and * writes 25 characters to the file. It then tries to open * FREAD.OUT and read in 25 characters. If the attempt succeeds, * the program displays the number of actual items read. */ #include <stdio.h> void main( void ) { FILE *stream; char list[30]; int i, numread, numwritten; /* Open file in text mode: */ if( (stream = fopen( "fread.out", "w+t" )) != NULL ) { for ( i = 0; i < 25; i++ ) list = (char)('z' - i); /* Write 25 characters to stream */ numwritten = fwrite( list, sizeof( char ), 25, stream ); ...Show All

• Microsoft ISV Community Center Forums Activate a workbook based on a value in a cell in another workbook

  I want to activate another active (open) workbook only if its name is the same as what I have recorded in a cell in my workbook. If it does return the same name then it is activated, otherwise a message box displays. Example: In my Reports workbook on a worksheet name “formula” in cell B33, I have the value “JulyData”. This represents the name of another workbook (i.e. JulyData.xls) Before a routine is run to import data into Reports.xls I want to verify that the name of the source workbook is actually “JulyData.xls” (as verified to B33 on my “formula” worksheet) and not “AugData.xls”. If it is “JulyData.xls” then I want the procedure to make it the active workbook and start importing data from s ...Show All

• SQL Server jumping to report from report within a same frame

  Let's say I have a web page that has two frames, A and B. Frame A shows lists of products, Frame B shows the Inventory Chart of after clicking a product at Frame A. The inventory Chart has a drill down link to another report XYZ. Once you click on the drill down link, the whole IE will be occupied by the report XYZ. How can I have the drill down report XYZ to be shown in Frame B and Frame A still remain there Thanks Jens. But the script void(window.open('xxx','_blank'))" " is already coded in clicking on a product at Frame A. My question is on the drilldown link in a report showing at Frame B whereby after clicking at the drilldown link, the next report will shows at Frame B. Any suge ...Show All

• Smart Device Development how do i start mobile programming?

  how do i start creating mobile applications................ Ilya Tumanov wrote: 1. Purchase VS 2005 SE or above. 2. Create device project. 3. Create your code and design your UI. 4. Debug your code. 5. Create setup project. 6. You're done, congratulations. I'm assuming by "mobile programming" you mean "Windows Mobile/CE" programming. If that's not what you meant you're in a wrong forum. hey! can you shed some light on simulators to be used and how to decide upon mobile specific issues like UI max size limit etc. regards Sumit Dagar ...Show All

• SQL Server Error when browsing processed Cube

  Hi, I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM. i.e. if I change the following working piece of MDX in a calc Aggregate( { [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC T ...Show All

• Visual Studio Unable to add references to Business Objects Enterprise assemblies

  I’m currently developing reports in ASP.NET 2.0 using Crystal Reports XI & VS 2005. I’ve Crystal Reports XI installed on my machine. There is also Crystal Reports Server 30 Days Evaluation version in Business Objects XI. I need to schedule reports using Crystal Reports Server. Now problem is I’m not able to add references to Business Objects Enterprise assemblies which are required in scheduling & exporting reports. Expecting reply ASAP Hi, Crystal Reports XI, and Crystal Reports Server XI are not supported when using VS 2005. You will need to upgrade to using Crystal Reports XI release 2 and Crystal Reports Server XI release 2. Crystal Reports XI release 2 is available from: http://www.businessobjects.com/pro ...Show All

• SQL Server How to backup Tr. Log when database is OFFLINE and mdf file is remote my mistake?

  I ‘d like to discus with you the following REAL enough disaster scenario: 1. The TEST database is in the FULL backup mode. 2. WE have a full TEST DB backup and all tr. log backups. 3. DBA moved TEST database OFFLINE for maintenance operations. 4. MDF file for TEST DB was removed by mistake. 5. TRANSACTION LOG (LDF) file is OK. 6. DBA want to recover database to the point of failure. According with MS SQL Server 2000 documentation it is possible. We need to backup the transaction log , BUT I CANNOT DO THIS. PLEASE, HELP. In the same time, I can make LDF backup and recover database to the point of failure, if database is online and I stop/start SQL Server to remove MDF file. ...Show All

• Visual Studio Team System Where does the "Assigned To" list come from?

  I would like to add some groups to the assigned to list. How can I do this It doesn't seem like I have access to this. Thanks, I also noticed that you need to remove the "Valid user" clause if you are using a "Allowed Value" list - such as a global list ...Show All

• Commerce Server Problem about import userobject profile into commerce server by using biztalk

  trying to import profile from RMS(Retail Management System) to commerce server by using biztalk. I use storeprocedure queried out latest updated and added account and form the profileimport.xml. the XML file is follow the format from profiledocument.xsd which is generated by ExportProfileXsd.exe the schema I generated is user object of the default profile definations. but when I trying to submit the xml file to profile web service it always come back Error message as follow The Profiles web service cannot see any profiles. Check the web service authorization file to make sure that the user id that this BizTalk instance is running under is authorized to retrieve profiles. ...Show All

• Visual Studio How Do I Disable *.suo Files Being Generated

  Hi, I'm wondering if there is a way to disable *.suo files being created in Visual Studio 2005; the program has been crashing quite alot; so if I remove that file then open the solution everything works, even with the files that where saved to be opened in the *.suo file. Thanks Glenn The cause of the crashes at this stage looks to be the Web Application for 2005; we are developing with Visual Studio .Net Professional in VB.Net. There are 6 developers working on separate parts of the project, and some days it will crash multiple times. After deleting the *.suo file the crashes will stop and may not come back for a day or 2. I have noticed that it sometimes may be related to refreshing a web browser while t ...Show All

• Windows Forms Updating an unbound DataGridView at Runtime

  I am a beginner programmer, so please bear with me. Say you have a DataGridView. You dock it to a Window Form. You set some properties such as AllowUserToAddRows and AllowUserToDeleteRows. So far, so good. Now, according to MSDN, a DataGridView can be eighter bound to a Data source, or it can be used as is. If it's not bound, you simply add rows, fill them with data and it should work just fine. My problem is this. I build the solution, add a Setup project to it and then I deploy it ( that is, install it ) on my machine. Now, I open the application and start populating the rows with data. Everything is fine. I close the application. When I open it again, bingo! All the data is gone. There must be some king ...Show All