SolveIt's Q&A profile

• Visual Studio Team System BVT's without Team System Tester Edition - Possible?

  I'm trying to create a Team Build that will run all my unit tests as part of the build. The problem is though, when going through the wizard it allows me to select the vsmdi file, but there is no test lists available in the drop-down (and since I don't have team tester edition I don't think I can create new test lists). We can still run the tests in our Team Software Dev Edition, is there a way to make a Team Build that will also run all the tests as part of the build process without purchasing Team Tester Edition You can now run tests as part of your build without using .vsmdi files. See http://blogs.msdn.com/buckh/archive/2006/11/04/how-to-run-tests-without-test-metadata-files-and-test-lists-vsmdi-files ...Show All

• SQL Server Need help with records not locking...

  Hello, Can anyone help find a solution to a strange record locking problem in SQL 2000 This stored procedure is run every two seconds by two workstations to auto-process specialized "jobs". This convoluted code began as a simple update statement, but as grown to this in an effort to prevent the two workstations from picking up the same record at the same time. Unfortunately, the machines are STILL managing to pickup the same job, which seems to be indicating some form of record locking issue. We've tried a number of locking hints, single BEGIN/COMMIT transaction command sets, and now a granular pair of transactions complete with additional filtering in the update command's where clause, but the two client machines continue to get the ...Show All

• SQL Server The old song: trimming the transaction log size on disk

  We have a new sql 2005 database with 14 millions records (converted from a non-sql databse). It's now one day old and the mdf is about 14GB in size while the log file is 37GB! Normaly we use "Full" recovery mode and the daily maintenance job updates indexes, etc. Suppose, at 8pm, after the shop closes, I set the Recovery mode to "Simple", backed up the database, and then reset the Recovery mode to "Full". Would that reduce the size of the trans log on the disk Or can you suggest a better way. TIA, Barkingdog P.S. Given thet we dump the trans logs to disk hourly I can't understand how the trans log could get so large. Both data and log files reserv ...Show All

• SQL Server Executing a batch script from "Execute Process" Task

  Hello, I have an "execute process" task which executes a perl script. When I run the task, it shows a prompt with the message "the publisher can not be verified". It gives the option to continue the task or to cancel. The problem for me is that I want to schedule this package to run automatically, and I don't want the automated process to show this dialog. I need to override the security setting and have SSIS execute my batch scripts without prompting. Assuming I don't want to rewrite the Perl code into a script task, is there a way to do acomplish this Thanks! Arkadiy Thanks, I found another way of solving this without changing the security settings. The trick is to inv ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual Studio 2005 Pro and XNA

  For whatever reason, I can't get XNA of any flavor to run with Visual Studio 2005 Professional. (A legal copy, before you ask.) I'm told when I try to install XNA that I need Express Edition. Surely XNA won't lock me out because I have a better program than the required edition Anyone You must not have read the FAQ : Q: Are there any prerequisites to run  XNA Game Studio Express A: Yes, you must download and install Visual C# Express and the latest DirectX runtime updates . The full DirectX SDK is not required.   Once you have XNA installed you can uninstall VC# Express if you wan to use VS, but as they run side-by-side without problems why bother, unless you're hard up for disk space. VC# Express offers featu ...Show All

• Software Development for Windows Vista Fault handling in RC2

  I can't seem to get fault handling to work in RC2. It worked for me in Beta 2.2. I have a state machine workflow that I've published as a web service. I've added a fault handler activity with one code activity as a child. My code activity gets executed, but then, when I retrieve the Fault property of the fault handler activity, it's always null. Any thoughts You need to be using GetActivityByName(string,bool) to get the correct activity. Because of spawned contexts in a StateMachine you are getting the template activity an not the actual instance. For more info on spawned contexts take a look at Nate's blog post . ...Show All

• Software Development for Windows Vista Trouble with WF HOL Lab 3

  This is regarding Lab 3 of the WF RC Hands On Labs , Hosting the Windows Workflow Foundation Runtime. Even after doing a repair installation, I am missing the SQL scripts for this lab. CreateDatabaseObjects.cmd executes Tracking_Schema.sql, Tracking_Logic.sql, SqlPersistenceService_Schema.sql and SqlPersistenceService_Logic.sql from C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN\. That path does not exist on my machine. I did a search on those scripts and couldn't find them anywhere on my C: drive. Has anybody else had this problem If so, how did you resolve it Also, if anyone can send those scripts in a zip file to me, I can take it from there (hopefully). Thanks! Camey Combs, WF Newbie The ...Show All

• SQL Server How to load data from a data warehouse to a Cube ?

  Hi All, I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions). Whenever there is a change in the data warehouse, it should be reflected to the fact table and dimension Does any body have some way to achieve this I appreciate if any body provide me a good material which describe this scenario. Sincerely, --Amde Hi Amde, You should process your cube, every time that you have news records in your fact table. If you have data every month, for example, then you could use partitions cubes by month. Good coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All

• Visual Studio Team System ManualTest.mht - where is it?

  I'm a sw developer who needs to document some manual tests. Where is the manualtest.mht file located I've looked in my TeamExplorer\Documents\Test folder, but I only have the TestApproach.doc available. Thanks - Jennifer Hi David, Thanks for the quick reply. I've tried what you suggested but the Manual Test (Word format) does not appear as an option. Could it be because I do not have the Tester version of VS Jennifer ...Show All

• Windows Forms open chm from winform

  How can I invoke chm file in a windows form by clicking a button -Not help button of form- thank you! I didn't know about this method. well I think your solution is much better. ...Show All

• SQL Server SMO Performance: .Alter()

  Is there anyway to do a batch alter on the whole database rather than just a table I've looked at the MSDN documentation for Database.Alter() and as usual it has nothing helpful. I've also had a search around on the forums and the net in general and can't spot anything on how to achive this. Any pointers would be greatly appreciated. What exactly are you trying to accomplish If you've made changes to properties of the database, then the Alter() method will implement them. If you're trying to change properties of other objects you've got to use the appropriate method for those objects. Please supply more details so we can help with your specific question. ...Show All

• Visual Studio 2008 (Pre-release) Don't Forget MARS

  If you are triyng to do lazy loading direclty with the objects, you'll get an error when you try to load children cust.Orders.Load You'll need to edit the connection string to turn MARS on MultipleActiveResultSets=true Note - I have only tested scenarios with direct object context access, not queries, so I am not saying you have to do this with queries (yet) But I have to bolt, so thought I'd put this here. The key thing to remember is that while you are enumerating the objects that result from a query there is a DataReader open streaming those results from the DB. If you call .Load on a collection while you still have that DataReader open, then we will need to execute another query which mean ...Show All

• Community Chat Clockless Chip

  Anybody knows about Clockless chip is it really possible having taken a few hardware courses I dont think it is, but if there does exist this kind of technology kindly reply asap. regards Sumit Dagar ...Show All

• SQL Server Want to see which queries are executing in SQL Management studio

  Without going to the MDI option and getting SQL 2000 windows, is there anyway to get the tabs to show what queries are running   Obviously, you can open the Window menu to see this, but it would nice to be able to just look at the screen and know what's going on. Also, what happened to SQL 2000 Query Analyzer's CTRL + W shortcut for Windows   ALT+W , W is not too much of an extra step, but it is not as convenient.  It would be nice if the Windows would show a globe instead of a partially obscured Exe...  Has anyone else had trouble with this I would post this on the http://connect.microsoft.com/SQLServer/ , but the option to submit feedback isn't visible, even in Search.   --Andy ...Show All

• Visual C++ need help to deal with char* pointers on COM interfaces

  I need to reimplement legacy COM interfaces (derived directly from IUnknown). A lot of methods on the old interfaces are equivalent to the following: HRESULT setValue (const unsigned char* value); HRESULT getValue (unsigned char* buffer, int bufferSize); The pointers on both methods are in fact the addresses of unsigned char arrays, which may be allocated on the old COM client's stack. The COM server needs to use the pointers either to fetch a C-style string (in setValue method), or fill up the client's buffer up to the buffer size (in getValue method). See the big problem (flaw) here The COM server must be able to access the COM client's internal memory directly. But the problem is, that can't happen all the time, because COM ...Show All