SpyderF16's Q&A profile

• SQL Server SQL Server 2005 Nov 7 GA Installation

  I know SQL Server 2005 is to be released on November 7 and I hope that date is truly realized, but I would like to start planning now.  We are currently running SQL Server 2005 from the Beta 2 of VS 2005 and was curious if we will be able to upgrade that version directly to the GA release on November 7th or if it will require a complete reinstall Thanks in advance, Steve Hi there situation: .NET Framework  v2.0.50727 installed ...Show All

• Windows Forms Visual Studio 2003 hangs up at start if I closed with a design view active

  If I close a solution with a form in design view, next time that I want start the vstudio 2003, it hangs up before loading the project. I need to remove the .sln file and open the project, just comes in seconds and then save the .sln. At times, this troubles me too. Looks like recurring issue, but could not get a hotfix from microsoft. In another forum, people said hotfix is likely in feb 2005. If any of you know the solution or hot fix, please ...Show All

• SQL Server Storing the ErrorDescription on DFT -> Flat file error output

  I have a Flat File Source that redirects bad rows to a DB Destination. I can Audit and get the ErrorCode (as well as an ErrorColumn, whatever that is ) but I need to save the error description as well. Is there a way to do this How Also, is there a way to email the error description / rows in the data flow task Thanks, Jason Hi Doug, How come, when you look at the error output in a data viewer, it contains an error descript ...Show All

• Visual Basic Weeknumber

  How do i get the weeknumber in Visual Basic 2005 Express edition Well that doesn't work for me. There's an interesting article about this here http://www.thecodeproject.com/csharp/GregToISO.asp msg=396665 The code is in C# but shouldn't be too difficult to convert ...Show All

• .NET Development HELP Required in Webservice access by C# Client Application.

  Dear All i am accessing a webservice from a C# desktop application. i have included the web reference in this application for my webservice. The webservice is running fine and easily accessable from the IE. but when i access it from my client applicaiton it gives me an error for The request failed with HTTP status 401: Access Denied. well it sounds like a pretty easy error to update, that i should check my webservice rights n al ...Show All

• SQL Server ANN:Dundas Chart for Reporting Services now in Beta

  For those interested, Dundas Software has just announced the Beta program for Dundas Chart for Reporting Services, which extends the charts within Microsoft SQL Server 2005 Reporting Services. Features include:  many new chart types, seamless integration, advanced Data Manipulation/Filtering/Forecasting abilities and more. We have also created a new website, dedicated to our new line of Reporting products - ( http://www.dundasreportin ...Show All

• Visual Studio Express Editions Populating/selecting/manipulating windows file names in a checked list box

  After many hours of trying to solve this problem I can't proceed without some assistance. Thanks Shakalama for the previous helpful information. I need to read in multiple windows filenames into a checked listbox component with the multiselect option. Wrox page s855-857 has some clues but I still can't solve my problem. After the following initialisation: Me .lblApplicationStatus.Text = "Started to retrieve text files..." ...Show All

• SQL Server Cursor Help Please

  I have a requirement for a user to access time sheet information by accessing a SharePoint portal listing. They will be required enter a date range. The login will be based on their domain access. Based on the query below, I can return a result set which gives the user all rows they'll need, grouped accordingly and based on a date range. Except for a required billable percentage figure. A billable percentage is defined as billable hours / t ...Show All

• Visual Studio Team System TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed

  Im trying to create a project and i got this error any ideas. Error TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed during task WITs from group WorkItemTracking. Explanation Plugin error text: “Value cannot be null. ---> Value cannot be null.” User Action Contact your Team Foundation Server administrator. Warning TF30144: The New Team Project Wizard attempt ...Show All

• Visual Studio Tools for Office Deleting a line break

  Hi All, I'm writing a Word Add-in which finds for a string in the document and deletes if there is a line break just before it. Can anyone help me on this TIA Pavan Hi, You can search for a paragraph mark + the string, and replace it with "nothing" or replace it with just an empty paragraph mark if you want to retain it. For example, if the string you're looking for is "find string&qu ...Show All

• Visual Studio Express Editions Problems converting VS 6 solution to Visual Studio Beta 2 C++ Express

  I have an  application that was developed in Visual Studio 6 that needs to be updated. I am trying to do this in Visual Studio C++ Express Beta 2 which I downloaded yesterday. I  think I correctly created the solution and added the old projects. When compiling I got lots of syntax errors which I expected and was able to fix with online help about the error codes. But now I have two last (I hope) problems I have spent a couple of  ...Show All

• SQL Server can't get the complete list of tables owned by the dbo

  Hi, i am using sp_tables to get the list of the tables in the database owned by dbo The database i am trying to query would let me query all the tables present in the database.there are almost a 1000 of them(owned by dbo) .I can query them and i get the records.   But the execution of the stored procedure  "sp_tables"  would return only 10 or so  tables.I was puzzled by this.   can someone clar ...Show All

• SQL Server Full text searching in advanced services edition

  I have installed the advanced services edition but cannot find out how to build and populate full text catalogs. Nothing shows on the MSSMSE tool and when I try to use a sql command to create a new catalog it says that the full text service is not installed. Am I missing something The Full-text Search menus in Management Studio have a dependency on SQL Agent, so they were excluded from Management Studio Express ...Show All

• SQL Server Nested cursor

  Is there a better way to nest cursors in SQL Server (I'm using 2005). Due to the nature of the solution a set-based approach will not work. Essentially I have a list of People. Each Person has Multiple Properties, so at the moment I have something along the lines of ... Declare PersonCursor Open PersonCursor Fetch Next Person Cursor While FetchStatus <> -1 Declare PropertyCursor (for Select according to current values in PersonCursor) ...Show All

• Windows Forms Can't Kill WINWORD.EXE...

  I've posted a message before, but my question wasn't really answered.    I'm using VB.NET to open, print and close a Word Document.  Thing is it leaves an instance of WINWORD.EXE in TaskManager - and it seems nothing will kill it. Aft ...Show All