QWERTYtech's Q&A profile

• Visual Studio VSS Diff between VSS Project and Local folder

  I know this is silly but for some reason, I am not able to get a diff between a vss project and the same project on a network server. I am executing the following commandsI I mapped the drive K to the location of the ss.exe. then I set the current local project as set cp = \\pwperforce32\ss\common\loadram Then, I ran the following command k>ss diff $/common/loadram -r >c:\temp\ssoutput.txt The result I get consist of a diff between the folder "loadram" in vss and the folder win32 where the ss.exe resides. I am not able to get the diff between the folder on the network versus the VSS Project. Thanks in advance for the Guru. Hi Alin, That helped clear my confusion. Thanks a lot. This has help ...Show All

• Visual Studio VS Team Foundation Server Documentation

  Hello, i want to make the documentation of all the code(xml comments) that i put in my source control folder inside the team project, like i do with NDoc, Is this posibly, Any one can tell me how to.. Thank's Andrew Andrew, Is this a Sandcastle question If it could youplease use Sandcastle: at the beginning of your question. For TFS source control there is documentation available at http://msdn2.microsoft.com/en-us/library/ms181279.aspx If it is Sandcastle then the answer is yes. I have documented them at the FAQ post in http://blogs.msdn.com/sandcastle/archive/2006/07/30/683352.aspx How can change author comments from comments.xml to a different file name Please look at t ...Show All

• Visual C# Refactor - Encapsulate field

  When I use refactor - encapsulate field I get the preparing files dialog and then it scans all the files in the project. It never used to do this and it now takes so long that there is no point in using encapsulate field as it is quicker to type it. On colleagues pc it works immediately without the scan, we are on the same spec pc. Have I changed a config setting somewhere Any help would be appreciated. TIA Thanks for the reply. Yes, I'm using ASP.Net. I'm currently using the file system (internal VS web server) web projects, if that makes any difference. cheers ...Show All

• Visual Studio Team System AfterOnBuildSuccess

  Hello out there, I have a pretty simple question. I already implemented the AfterOnBuildBreak target where an email is sent to all the changeset users. Now I would like to implement something like 'AfterOnBuildSuccess' to Inform the in an XML file stored changeset users that the Build was successfully completed, but I can't find any target in this direction. The only things I found is stuff for a TaskFailure but that seems not useful for me... I would appreciate any help... Bye TheRolle Thanks to both of you, actually I already programmed a workaround. If I have time again I will try out your solutions. Again, thanks Roland ...Show All

• Microsoft ISV Community Center Forums BSC manager - Error connecting to server

  I've installed BSC manager 2005 following these steps: 1. Created a Virtual PC with 512 MB RAM 2. Installed Windows Server 2003 entreprise edition 3. Installed Windows Server 2003 SP1 4. Installed Sharepoint Services 2003 5. Installed Sharepoint Services 2003 SP2 6. Created a site and extended (Port: 46786) 7. Installed SQL 2005 developer edition 8. Configured SPS to use SQL instance 9. Installed BSC manager (server and builder) When i start the BSC builder and try do access the server ( http://localhost:46786 ) I get the following error message "The conection to the server failed. Verify that the connection information is correct". Can you help me What is this server Is it the SQL server create ...Show All

• SQL Server Problem in Restore Database from old version to SQL Server 2005?

  Dear All, I am experiencing a problem that, after i have made a backup database file in SQL Server version (9.00.0190), when i restore the database in a newer SQL Server 2005 version(9.00.1399), an error occurs. The error is: Restore failed for Server 'demo'. (Microsoft.SqlServer.Smo) Additional information: System.Data.SqlClient.SqlError: The database was backed up on a server running version 9.00.1090. That version is incompatible with this server, which is running version 9.00.1399. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo) Anyone can tell me how i could fix this Why would it happen Thank you very much Regards, George ...Show All

• SQL Server Conditional formating in Subtotals?

  I have subtotals in a matrix and I want to format the background color depending on the subtotal value - > 95 = "Green", < 95 > 90 = "Yellow", < 90 = "Red". I go to the Subtotal properties and put the iif expression in the background color, but it's not detecting the Subtotal value. How do I refer to the Subtotal value in a formating expression Robert was right. The InScope works, but I needed to add the matrix name and underscore to the row and columns group names since I had more than one matrix in the report. Thanks Robert! ...Show All

• SQL Server Incrementally processing "new" files

  Hi, I'm just starting to learn SSIS and would like some advice on how to handle something I encounter frequently. I often have to connect to a remote FTP site which contains a large number of files. Each day a number of files are added (old files are not purged). So each day I need to download all files which have been added since last time I checked, store on a file server, then load to a SQL database. I've written a DataFlow using a script which generates a list of files and dumps to a raw file and doing the same for FTP directory listing wouldn't be too hard - I could then feed these into a third DataFlow to work out what the new files were, then a third to download the files to a temp directory etc. But is there a cleaner way ...Show All

• Windows Forms Little help with DataGridView please

  I have a dataGridView and an arrayList. I bind the arrayList to my DataGridView with: dataGridView.DataSource = arrayList; dataGridViewMessages.Refresh(); And my dataGridView displays correctly. Later in my code i wish to clear my dataGridView, so i go: arrayList.Clear(); dataGridView.Refresh(); but it reports an error. Whats the correct way to clear my DataGridView Later I wish to fill my datGridView again. Thanks. Paul. By the way, Did you try: dataGridView.Rows.Clear(); arrayList.Clear(); This will clear the rows keeping the data source as the arraylist! Hope it helps! ...Show All

• SQL Server SQL server Management Studio Express

  We just installed SQL 2005 server. It works fine (allows to setup backup jobs, create other jobs etc). I also installed MS SQL Management Studio Express on my PC to access the server remotely. Connecting under SA account gives me a full vew of the database, but with very limited rights regarding to the server management. For example, I can see what names of maintanence plans but once I right click on the name it only gives me an option to REFRESH and nothing else. Also SQL Server Agent is hidden and I can not see and manage any jobs running. Please let me know how to set more rights or am I misisng something on Studio Express setup Thanks! SQL Server Management Studio Express is limited as well as SQL Server E ...Show All

• SQL Server Calculate difference between two rows

  Hi, i have a matrix, and in that matrix i need to have one column which calculates the percentage change between a value on the current row and the same value on the previous row. Is this possible The RunningValue() function isn't of help as it can't help me calculate the change between two rows, and Previous() doesn't work in a matrix (why !!!!!). Also calculating this as part of the query isn't possible as there is a single row group on the matrix, and the query is MDX.* Thanks, sluggy *for those who are curious, the matrix is showing data an a per week basis, the row group is snapshot date, i am trying to measure the change in sales at each snapshot. Hi i've just done this by cre ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to take advantage of DirectX debug mode?

  The DirectX SDK use to give an option of installing in debug/release mode, but the latest SDK doesn't suprisingly. In VC++ 2005, I have the debug option on. I'm curious how I can tell what the SDK installed as Also, I remember there was an icon in the Control Panel that aloued me to set Direct3D as debug mode. The icon isn't there anymore. Does DirectX now assume I am debugging when the debug option is set in Visual Studio Try this: Start | Programs | Microsoft DirectX SDK | DirectX Utilities | DirectX Control Panel You should see options for selecting Retail/Debug versions there. ...Show All

• Visual Studio Team System Cannot install TFS (DEU) on a Windows 2003 Server (ENU) with SQL Server 2005 (ENU)

  Hello, i try to install the TFS (DEU) on a Windows 2003 Server (ENU) with SQL Server 2005 (ENU). While setup is installing the components i get the following error EventType : visualstudio8setup     P1 : 12840     P2 : 8.0.50727.147._vstf_x86_cd     P3 : msi     P4 : inst     P5 : f     P6 : - P7 : -     P8 : 1603     P9 : -     P10 : -   thanks and regards j3ns3n Hi Matt, we did not get the problem solved. we installed the sql-server two more times, but we were not able to install the tfs af ...Show All

• SQL Server Time Dimension skips DAY

  Hello I'm using a field from a fact table with the following format: 2006-08-30 11:52:56.200 . The fact table is automatically generated from the Windows Relog utility which converts performance counters and pumps them in a CountersData table (my fact table). The funny thing is that this field has a nvarchar data type although it's a date. I can't change the datatype as it is generated by Relog. I tried SSIS with substring functions to create Year, Month, Day, Hour, Minute and Seconds fields as derived colums from the string so I could use them in a Time dimension. I'm able to create a time dimension using the dimension wizard but the outcome is always: Year, Month, Hour, Minute, Second. The question is: where is the DAY I'm su ...Show All

• SQL Server Restoring database problem

  i have developed an application where in one form i placed two buttons, backup and restore. when i want to take backup from database to which i currenly login, i can . But when i want to restore database that bakup to database to which i currently login, i get an exception. So then add following method myConnection.Close() RestoreBackup(); even though it is not restoring. the resore backup method is following public void RestoreBackup() { // If there was a SQL connection created if (srvSql == null ) { Connect(); } if (srvSql != null ) { openBackupDialog.InitialDirectory = "./Backup" ; openBackupDialog.DefaultExt = "bak" ; // If t ...Show All