tackett's Q&A profile

• SQL Server How can I be assured that I do have SP1 applied correctly in SQL 2005 Developer Edition

  I installed my SQL 2005 Developer edition and applied the SP1. I didn’t have a time to wait the installation to complete (I needed to reboot) so I cancelled the SP1 which was downloaded from Windows Update. Now, my development PC says that SQL 2005 SP1 is applied but I am not sure if it’s applied correctly. I tried to reinstall SP1 in order to be assured but I can’t get it reinstalled. I get error message saying that you already have SP1 2047 ENU applied. I just don’t want (have a time) to troubleshoot some possible upcoming issues in development because of this. So, how can I be assured that I do have SP1 applied correctly I try to uninstall the SP1 but its not possible, so I guess in order t ...Show All

• SQL Server More Reads then expected

  So I’m at a dead-end looking for the reason behind the following behavior. Just to make sure no one misses it, the 'behavior' is the difference in the number of reads between using sp_executesql and not. The following statements are executed against a SQL 2000 database that contains >1,000,000 records in the act_item table. They are run using Query Analyzer and the Duration and Reads come from SQL Profiler SQL 1: exec sp_executesql N'update act_item set Priority = @Priority where activity_code = @activity_code', N'@activity_code nvarchar(40),@Priority int', @activity_code = N'46DF335F-68F7-493F-B55E-5F9BC6CEBC69', @Priority = 0 Reads: ~22000 Duraction: 250-350 ms SQL 2: DECLARE @Priority int ...Show All

• .NET Development Problem with file download

  Hi, I have two two files startpage.htm and login.aspx. When a button is clicked from the startpage.htm it goes to the login page, after validating the username and password it comes back to the startpage.htm. Now when the user clicks in the same button again it has to open a dialog box to save the file, but it doesn't and it goes to the login page again. If the user clicks another file after logging in then it works properly. The file which was clicked at first can't be downloaded if the user clicks it again, also any other link which points to the same file name again can't be downloaded. This happens only with internet explorer, but with mozilla firefox it works properly. Could anyone provide me a solution for this problem I have giv ...Show All

• SharePoint Products and Technologies LOL: No Knowledge about Knowledge Network

  Just thought it was funny that the "Knowledge Network" had no posts and thus no Knowledge about it :-) To paraphrase the great writer Samuel Langhorne Clemens, better known as Mark Twain, “rumors of my death have been greatly exaggerated!” Okay, so I am the guy who is responsible for bringing Knowledge Network (KN) to market. KN will be released as a technical preview, which is a way for us (Microsoft) to provide a long-lead time to our customers to look at future technologies that Microsoft is working on. The code is just at the stage where we are ready to make it available to the public as a "release candidate" or RC. The function of the RC is that it serves as the almost ready for primetime release and many ...Show All

• Visual Studio Time process with ReportViewer and database fields

  Hello, I have got a database that contains following colmuns: ID DateCreate Date1Action DateResponse DateComplete Now I want to create a report that contains a time process line. The rows should display the column ID. The time process line should display every date in chain like: ID DateCreate Date1ActionDateResponseDateComplete 1 ------------- -- ----------- ------------- -- ------------------- 2 ------------- -- ---- ------- ------------- -- ----- -------------- The user should see how long an action between the dates takes. I have no idea how to do that. Could sombebody help me ...Show All

• Software Development for Windows Vista Cannot install Virtual Server 2005 R2 SP1 Beta 2 on Vista RTM

  Hello everyone, I am trying to install Virtual Server 2005 R2 SP1 Beta 2 in my machine running Windows Vista RTM. All IIS components are installed but when I try to install VS, the port is blank and im receiving error message that says, IIS is not installed. I used to be able VS in Vista RC2 using the same procedure. Could this be an incompatibility issue Thanks! Pom Hello Pom Figueroa, Microsoft does not officially support Beta or pre-release products. I would suggest posting in the beta program forums / newsgroups, the beta program site can be found at https://connect.microsoft.com/site/sitehome.aspx SiteID=151 . I would also suggest posting in the TechNet forums at http://forums. ...Show All

• SQL Server Sum 5 minute data by hour

  I have a table that data gets stored in every 5 mins in intervals marked as 5,10,15,20...2350,2355,2400,5,10, etc. based on the current time rounded to the nearest 5 min interval. Now, with this data, I'm trying to make a query that can be ran to show the sum or average of the 5 min data for every hour interval. So, 100 would sum intervals 5-100 and 2400 would sum intervals 2305-2400. I just figured out how to use the DataGridView controls in the 2.0 frameworks but now I'm not stuck on this query. Thanks! I see what's happening...the 100-155 interval contains 12 values but the 5-55 contains 11 values with the 2400 interval by itself.  The 24 interval should be added to the 0 sum to make eithe ...Show All

• SQL Server Perform upgrade method

  hi I have two versions of the same dataflow component , i need to use the new version component in the packages created using the old version . How can i do this using the perform upgrade method . Thanks Mani In fact you can automatically upgrade a dataflow component's metadata when you upgrade the component's assembly version. Here's how: 1. Remove the old assembly from GAC. 2. Make sure your new component's CurrentVersion argument of the DtsPipelineComponent attribute is greater than the one saved in the old metadata. That'll ensure that PerformUpgrade of the new component will be called when SSIS opens the package. 3. In the new component override Pe ...Show All

• Visual Studio Express Editions Making a program run at startup (if user wants it to)

  Hi, does anyone know how to make a program run at startup, if a checkbox is checked ( i.e. checkbox in options dialog box checked or unchecked). Please help, thanks in advance Take a look at http://msdn2.microsoft.com/en-us/library/microsoft.win32.registry.aspx and http://msdn2.microsoft.com/en-us/library/microsoft.win32.registrykey.aspx to see some samples on how to manipulate the registry. ...Show All

• Visual Studio Express Editions Could Anyone help me in VBE 2005,I need a way to make a button change to...

  Hello,First,i Am an extreme begginer in VB,BTW,im 13 years old,I have already made very useful Apps,from a calculator with all my Science/Math formulas included with a type of Instant Browser,which helps me in school when in a class,i can use it to ue the internet without any signs of browsing,I know a little of vb,The basic and A bit of more advanced,Any ways,back to the Q I am making a Lights Out Clone for my friend,but while i am doing it,I already designed it,But when i Try the first button,I am able to make that button change color,but not the ones next to it. My Q's 1-Why does'nt it change the ones next to it 2-Why after Clicking it,you click it again and it does not reverse the Colors(I did write the code,dont expect me ...Show All

• Visual Studio Express Editions Again, Mortgage Calculation C++ Console Application

  Hi, This time is about application's execution. I have been my brains out of problem, but I can't solve that, and I don't now a debug tric to help to solve the problem. The linker don't complains about that. The issue is: calls to function's member of class PresVal declared in PresVal.h and implemented in various .cpp, do anything , when called from PresVal.cpp. Where is my mistake, here Thanks in advance for help. See the code, and at the botom, the messages the output of ide debug execution of application. Annuity.cpp #include "PresVal.h" #include <conio.h> #include < iostream> using namespace std; int main() { cout <<"********************************************************* ...Show All

• Visual Studio 2008 (Pre-release) Changing the Color of a Row On a ListView

  I'm trying to set up a listview control where if a row meets a condition i want it to change the color of the text for that row (red) else it should be the default color. I have it bound to a dataset. Could someone point me in the right direction Thanks How to programmatically change the ForeColor and BackColor properties of subitems in a ListView. http://www.windowsforms.net/FAQs/default.aspx PageID=2&ItemID=437&CategoryID=3&tabindex=3 ...Show All

• Connected Services Framework New features/enhancements in next version of CSF

  Hi, Please let me know what new features will be available in next version of CSF – especially the enhancements to the existing features and from developer productivity point of view Thanks, Ashish Malhotra Hi,   When do you plan the next release of CSF  Will it happen this year   Thank you ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tessellation vertexbuffer

  Hi.. In my Application (with managed DirectX) I define a vertexbuffer. The z-value of the vertices are beeing frequently changed. So I get a kind of terrain. But it dosent look so good. I want to make it smooth. Ho can I do that I heard about Tessalation. How can I use it with my Vertexbuffer Or do you use it just with meshes Thanks... ...Show All

• Visual Studio Express Editions How to using COM in C++ appliaction?

  I generate COM in the following way: Create an ATL project called ATLTransmitAs. Add an IDL file named ATLTransmitAs.idl and paste the following code into it. // ATLTransmitAs.idl : IDL source for ATLTransmitAs // This file will be processed by the MIDL tool to produce // the type library (ATLTransmitAs.tlb) and marshalling code. import "oaidl.idl"; import "ocidl.idl"; typedef long DATEXMIT; typedef [transmit_as(DATEXMIT)] struct CUSTOM_DATE { short day; short month; short year; } CUSTOM_DATE; [ object, uuid("AE23C15E-920D-4ffa-B662-7E77E231E951"), helpstring("ICustomDate Interface"), pointer_default(unique) ] interface ICustomDate : IUnknown { [helpstring("method GetDate&quo ...Show All