Tutnik's Q&A profile

• SQL Server Not enough memory to start "Query processor"

  Hi All, I have installed SQL Server 2005 on a Virtual machine (Windows Server 2003 SP1) to use with a Team Foundation Server on the same virtual machine. Everything work fine when I test it. But when I put the Virtual machine on my server (on Virtual Server) I failed to access Team Foundation Server. I soon discover that the source of the problem is SQL Server 2005. It fails to start the MSSQLSERVER and SQL Server Agent services with an ...Show All

• SQL Server Is there any way to the login for existing user

  1. Right click the <DB servername>->Databases-><DB Name>->Security-><Users>-><username>. 2.Click Properties. 3. In the Database User -<User name> window, the login name is not editable. how can change the login name for existing User name. See ALTER USER: http://msdn2.microsoft.com/en-us/library/ms176060.aspx . This article also includes an example of chang ...Show All

• Visual C# Why is the C# team allowing this to Happen? and Why do they close threads on the topic?

  Since PJ. van de Sande Closed the last thread I opened : Why is the C# team allowing this to happen I guess because he didn't click the link or he didn't like the topic.  I brought the link information here.....  So I ask again... Why is the C# team allowing this to happen   If he closes it again, please respond here From the Blog link: From Tom Archers blog Why so many examples in Visual Basic ...Show All

• Smart Device Development Compact Framework Issues

  Hi, Anyone having problems with line breaks in the TextBox control from the Compact Framework I insert a string with line breaks, (yes the textbox is multi line enabled), save it to a database, read it back and all i get is little squares in place of these line breaks. The funny thing is, this same exact data (no changes what so ever) is displayed correctly in a win forms application (running on the desktop). I've tried the traditional methods ...Show All

• .NET Development Deploying web service to test server

  Hi, I have 2 ASP.Net projects, "client_side" and "server_side". Both have a reference to WSE 2.0 SP 3. My intention is to transfer files between the server and the client. I developed both web services on my development machine and they work great. Now I wanted to move the "server_side" web service to the test server. So I installed WSE 2.0 SP 3 run-time version on the test server and copied "server_side.dll" to the test server. (when ...Show All

• Visual Studio Crystal Reports XI and Visual Studios 2005 Questions?

  OK I have read a lot of post here that lead me to believe CRXI is not compatible with Visual Studio 2005. Or should I say not till CRXI r2 comes out in which case it will support VS2005 .net Framework 2.0. On a Project that is updated to VS2005 from VS2003 and CRXI for the most part went very smooth.   Except and for me this is major CR Version is 10.2.3600.0 in VS2005 where as it was VS2003 it is Version 11.0.3300.0 for me. Ok fr ...Show All

• Windows Forms Loading a Form that belongs to another Project within the Solution

  Hi all, I have a solution that comprises of a couple of projects. There is one core project (The Site Diary) that is the main application, in which there is a main menu where the user can click on a button that will load up a Form/Application that is from another Project within the same Solution (these projects include SmartWaste, CaliBRE and Priority1). Now these applications are/should be completely de-coupled and in no way know about each oth ...Show All

• SQL Server Cannot design aggregations because databsae already exists

  I am clicking on "Start" in the aggregation design wizard ("Estimated storage reaches X" is selected" and I get the following error: TITLE: Aggregation Design Wizard ------------------------------ Errors in the metadata manager. The database with the name of 'CoreMarketReturn' already exists in the 'LNVDMFIISUAT01' server. To restart the process, resolve the problem, and then click Start. -------------------- ...Show All

• SQL Server Conditionally dropping a table

  To All How do I check to see if a table exists before I drop it. Thanks David Davis The easiest way to check this in SQL Server 2005 is to use OBJECT_ID. It now exposes an additional type parameter which is useful for checking schema scoped objects. This parameter was not documented in SQL2000. So you can just do: if object_id('[MyTable]', 'U') is not null  drop table [MyTable]; ...Show All

• Visual Studio Team System SQL SP1 killed some reports

  Hi, I installed SQL SP1 onto my TFS. Unfortuntely a couple of reports broke: Bug Rates, Bugs By Priority, Project Velocity, Reactivations, Remaining Work, Unplanned Work now report: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'dsWorkItemHistory'. (rsErrorExecutingCommand) The '20060616' string cannot be converted to the date type. Hmmm... anybody got any ideas - woul ...Show All

• Visual C++ ATL project upgrade -> error LNK2005: xxxx already defined in atlmincrt.lib (atlinit.obj)

  I've recently upgraded an ATL project from VS2002 to VS2005. It compiles fine in Debug mode, but when I attempt to compile in Release mode I get link errors. Can anyone help me please Linking... LIBCMT.lib(tidtable.obj) : error LNK2005: __encode_pointer already defined in atlmincrt.lib(atlinit.obj) LIBCMT.lib(tidtable.obj) : error LNK2005: __encoded_null already defined in atlmincrt.lib(atlinit.obj) LIBCMT.lib(tidtable.obj) : error LNK2005: _ ...Show All

• SQL Server How to display group footer at end of the page

  How to display group footer at end of the page My requirement is: I want to print mutiple orders in a report,  I want to show a subtotal for every order. And that subtotal has to be at the end of the page. Any suggestion In crystal report, it is very easy. ...Show All

• .NET Development Populate C# Datagrid with XLS file

  Hi All, How do I allow a user import an XLS file into a Datagrid on a form in C#. Also, what is the proper syntax to add Columns on the fly Thank you, Paul Start here: How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET http://support.microsoft.com/default.aspx scid=kb;EN-US;Q316934 The above article also contains references to several other art ...Show All

• SQL Server Can't Edit Table

  Hello, I'm an undergrad who is using SQL Server 2005 for the first time. I have a table Components where there are three columns, ID, Name and Value, where ID and name are the composite key. I have entered some data into it from the user interface and it is entered just fine. But when I try to edit data in Value column it can't be done. This error message comes... "No Row was updated The Data in Row 7 was not committed Error source: M ...Show All

• SQL Server Package Migration Wizard error -- Index was out of range

  I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions "Index was out of range. Must be non-negative and ...Show All