floatping's Q&A profile

• SQL Server Determine if Service Pack 1 is installed on SQL 2005 ?

  How can I determine if SP1 is installed for SQL Server 2005 TIA select @@version Frank ...Show All

• .NET Development Specifying user account to run a Thread

  Hi, I want to start some asynchronous operations in a thread and I want the new thread to run under a specific user account. Is it possible to achieve this in threading and how Thanks, Prakash Hello Prakash, The type of functionality I believe you are looking for is called 'impersonation'. Effectively, you want your code to impersonate another identity or role during some portion of execution. Impersonation ha ...Show All

• SQL Server SQL Server 2000 DTS Tools Web Download

  Is the Web Download to install SQL Server 2000 DTS tools available yet If so where Thanks Darren If I answer my own question, at least I'll get one right. SQL 2000 DTS tools are now available as part of the - Download details: Feature Pack for SQL Server 2005 Nov 2005 ( http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en ) The direct link to the MSI- http://www.microsoft.com/dow ...Show All

• Visual C# Creating Events in C#

  Hello Everyone, I have something like this in C++ enum { READ_EVENT, CLOSE_EVENT, NUM_EVENTS}; int run() { _events[READ_EVENT] = CreateEvent(NULL, FALSE, FALSE, NULL); //unnamed _events[CLOSE_EVENT] = CreateEvent(NULL, TRUE, FALSE, NULL); //unnamed if ( _events[READ_EVENT] == INVALID_HANDLE_VALUE || _events[CLOSE_EVENT] == INVALID_HANDLE_VALUE ) { return false ; } private: ULONG _refcount; HANDL ...Show All

• .NET Development Converting streams

  I have a Stream which is Stream stream = httpWebResponse.GetResponseStream(); I need to convert this System.IO.Stream into System.IO.MemoryStream. How can I do that with C# 2003 The data that a server returns is an image. I would do byte [] data = webClient.DownloadData(uri); but for certain reasons I have to use HttpWebRequest/Response. Thank you. You can't convert it from one to the other .. you would read data from that stream into a ...Show All

• SQL Server SUM problem in SSRS 2005 report

  I don't know how best to explain this but will try. In my SSRS 2005 report, i have one group in my table.  In that group, I have a field that for each company record in my dataset, this field value is repeated for each record. This is a transactions table so you'd expect several records in the dataset for each company..that's not the problem. example data from dataset: TransID     CompanyID   &nbs ...Show All

• Visual Studio Express Editions Q : Exceptions

  hi, i want to ask about try and catch should it be used just for exceptions or i can use it like "if" for example i have a treeview and i want to know if the node has a parent or not so i don't know anymethod to indecate that so i used try and catch like this, Try mylastfolder = mylastfolder.Parent Catch mylastfolder = Nothing End Try or should i use catch null ...Show All

• Visual Studio Team System Merge tool

  Is the Merge tool that TFS uses available to run standalone The reason being, I have a set of files that may be different to what is checked in and I want to merge my changes with the latest version from TFS SCC. Thanks Graham Graham, did you check out the files that you wish to merge   If so you'll get conflicts when you run get or check in if the files on the server are different that you have checked out. ...Show All

• .NET Development I can't update data with a tableAdapter

  I’m using Visual C# 2005, and I used assistant to add an Access data base. I created a Binding Navigator but I can’t record new  data (in the Data base)  insert in the dataGridView.   The save event is the default one (make by the assistant).   private void pruebaBindingNavigatorSaveItem_Click( object sender, EventArgs e) { this .Validate(); this .pruebaBindingSource.EndEdit(); ...Show All

• Visual Basic Learning VB6

  Hi, Im wondering if anyone could help me out I have got Visual Basic 6.0 and Visual Studio 2005 and want to know if there are any good sites with tutorials on using these packages (particularly VB6 for starting up) , Can I get learning Packages or Starter Kits , I dont know any code but understand how it works, I know HTML and tried some JAVAscript ... can anyone please advise.. Thanks Paul Hi ReneeC, ...Show All

• Windows Forms Web Deployment

  Hi, I've converted a VB6 application for a friend into VB.Net but he has asked me to modify the application so that it can used via a web browser. Is this possible or would I have to re-write the application in ASP.Net Thanks Eric. ...Show All

• SQL Server Reporting Services Error - SQL Server does not exist or access denied

  Hi, I am unable to view my reports once deploying them.  The error I get in Report Manager is SQL "Server does not exist or access denied".  What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003).  When I try to use the same connection string in Report Manager I get the error.  Please note that I deploy the reports from my computer onto a ...Show All

• Windows Live Developer Forums any MSN messenger web service API to add contact ? Pls. help

  pls. mail me on this. thanks Sharad When someone is logged in to MSN Messenger (or WLM), you can make a link to msnim:add contact=email@hotmail.com to add email@hotmail.com. This only works when the visitor is using Internet Explorer though. It's not really a web service though, but maybe you can use this :) ...Show All

• SQL Server Extended Stored Procedure(write in C++ and C#) called from UDF under transaction not work!

  I use sql2000 on win2003 sp1 I use a dll(write in VC++) to handle ods's parameters input/output, and provide a interface so can use C# to implement Extended Stored Procedure Business Code. All is right, but now have 2 problem: 1. When call Extended Stored Procedure(eg: execute a stored procedure) from UDF in user transaction, i can connect back to sqlserver use ADO.Net (SqlConnection) and can build SqlCommand parameters for the stored procedu ...Show All

• SQL Server Backing up a schema

  Is it possible to only backup the tables that belong to a schema ...Show All