Thomas Abramse's Q&A profile

• SQL Server Getting error 0x80004005

  Hi Everybody, Iam a sql server developer,iam on a migration project,iam encountering an error when iam editing the control flow task.it says the sql server doesnot exist or access denied,pls can anyone help me on this. Thanks and Regards, sg ...Show All

• SQL Server composite nonclustered index

  Hi everyone, I have some problems on composite nonclustered indexes. I could not exatly understand their logic. In my opininon, suppose that we have a table called Order and we create a composite nonclustered index on this table for OrderID column and OrderDate column. So I am using this query; SELECT * FROM Order WHERE OrderID > 12 ORDER BY OrderDate So in here, I think our first research is based on OrderID and ten after ordering our data pointer according to the OrderID and then our index is converted to an index which is based on OrderDate while performing ordering. So is this correct Would you please explain this Thanks Hi, Thanks for this reply again. In here, SELECT * FROM Order WHERE OrderID > 12 ORDER BY OrderDate ...Show All

• SQL Server Indexed View Not Performing As Expected (Worse Performance Than Underlying Table)

  I tried constructing an indexed view to help improve the performance of our system, but it strangely appears to have a very negative impact on performance. As an example of what's happening, let's say I have a table like this: CREATE TABLE MyTable ( KeyPart1 varchar(50) NOT NULL, KeyPart2 varchar(50) NOT NULL, SomeValue varchar(50), SomeOtherValue int ) CONSTRAINT [key] PRIMARY KEY CLUSTERED ( KeyPart1 ASC, KeyPart2 ASC ) And a view like this: CREATE VIEW MyView WITH SCHEMABINDING AS SELECT KeyPart1, KeyPart2, SomeOtherValue FROM MyTable WHERE SomeOtherValue IS NOT NULL ...with an index like this: CREATE UNIQUE CLUSTERED INDEX name ON MyView ( KeyPart1 ASC, KeyPart2 ASC ) In my real-world example it's ...Show All

• SQL Server Create a calculated member on one measure.

  I have a Version dimension which is used to break out the Net measure by 'Actual' or 'Budget'. Net is the only measure I'm using. By not using the Version dimsion. The net is incorrectly totaled by both values. Both are not used together. 'Actual' and 'Budget' are the only two members of the Version dimension. I want to add a third member which subtracts 'Budget' Net measure from the 'Actual' Net measure and call it variance. A caculated measure isn't working for me because obviously subtracting Actual - Budget doesn't work so well. Can anyone help me with that First - please remove NON_EMPTY_BEHAVIOR - it is defined absolutely wrong. Second, how exactly it doesn't show up If you connect with SSMS to the cube and browse the ...Show All

• SQL Server Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare for Execute (Success) - Pre-execute (Success) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started. (SQL Server Import and Export Wizard) - Executing (Error) Messages Error 0xc02020a1: Data Flow Ta ...Show All

• Software Development for Windows Vista Where is the Application database to be installed?

  From managed code, use Environment .ExpandEnvironmentVariables( "%PUBLIC%" ).ToString() This will return a path such as "C:\Users\Public" ...Show All

• .NET Development Problems in Serializing obsolete properties

  I am trying to version parts of my code and part of the process of versioning is giving my clients enough time to use the new method instead of the old one. I do this by using the [Obsolete] tag on methods/properties I am planning to remove in the future. There is some inconsistency on how XmlSerializer handles serialization of methods and properties when these objects are used in webservices. [Obsolete] methods continues to appear on the wsdl while [Obsolete] properties were not included in serialization. Is there a way for me to include [Obsolete] properties in XmlSerialization I still need these properties today. One suggestion I got was to duplicate the property using a different and use [XmlElement("Name")] for it to b ...Show All

• Visual Studio Team System Branch from a label - why didn't this work?

  I have a semi-automated build process that's building my product and labelling the main branch at each build. For example, I have a label: AFF-20060706-0043@$/Development/Products/ProductName/Main Now, I want to create a "1.0" branch for this product so I can proceed with development of v.Next features. So I selected the $/Development/.../Main folder, right-clicked & chose Branch... In the dialog, I chose Label as the branch-from version, then chose the above label from the find label dialog. When I attempt to perform the branch though, I get an error: No items match $/Development/.../Main in the label AFF-20060706-0043@$/Development/.../Main Huh If I examine that label in the Find Label dialog, I can c ...Show All

• Software Development for Windows Vista stop printing from a filter

  is it possible to stop the printing from an xps filter would a call to RequestShutdown be the proper way to cancel the printing RequestShutdown(HRESULT_FROM_WIN32(ERROR_PRINT_CANCELLED)) works, too ...Show All

• Visual Studio Express Editions What gives?

  I wrote this code for my program to create a directory. It looks like this: My .Computer.FileSystem.CreateDirectory( "C:/Documents and Settings/" + Environ( "USERNAME" ) + "My Documents/" + TextBox1.Text) and it wont do it... it just gives me an error that says that the file path isn't supported. It still doesn't work the code looks like this now. Imports System.IO Public Class Form2 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mydocuments As String = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) My .Computer.FileSystem.CreateDirectory(mydocuments & "\& ...Show All

• Visual Studio Express Editions Registration

  I registered about a week ago. Now they are offering free icons, and images for registering. How can I get them I would like to do that, Please dont tell me I have to uninstall, redownload, reinstall and reregister. Thanks, Brian Thank you. That seems to have worked, just the activex prompt isn't coming up and the images are not downloading......I'll figure that out later this afternoon. Thanks, Brian ...Show All

• Visual C++ stdio.h errors in Visual Studio 2005

  I just finished installing VS 2005 (is it that hard for microsoft to just let people download like, a zip file of it, rather than an img file, which i had no idea what to do with at first ) and tried the following code: #include <stdio.h>    // include the standard input/output header file void main(void)    // our program starts here {     printf("Hello World!");    // print "Hello World!" into the console     return;    // return void to windows } It was part of an origionally blank win32 console app called test.  When i tried building the solution or compiling the file separately, I got all those errors: ------ Build started: Project: Test, Configuration: De ...Show All

• Microsoft ISV Community Center Forums insert a picture into an excel template

  I am creating a template in which i would like the user to be able to click a command button or image button, and for the file open menu to open for the user to select an image off his/her harddrive and insert it into a cell. I would also like the image to be inserted to fit a certain size restriction within the cell so it will not cover the entire screen. Is this possible and if so, could you all point me in the right direction Thank you There is an example of what you need using the FileDialog Object on the following msdn page: Working with Files and Folders in Office 2003 Editions ...Show All

• SQL Server Problem with reportfooter and header

  Dear sir, i am developing reports in sql server businessintelligence development studio...i deployed the reports in reportserver and i was able to see it..but my requirement is all my reports should have the same header and footer as of all other pages must uses custom footers and headers....hw to use thatcustom footer and header in my reports Regards, Pradeep Hi, do you want to create custom report headers or use the same for all reports This is not quite clear. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I need to create a mesh from scratch

  Hi Xnacers: I need to create a mesh the from scratch, not load a predefined mesh from an x file using the content manager. I have looked into the ModelMesh and I see that it has Vertex and Index buffers but there is no constructor defined. Is there a way to create a mesh without loading it from a file The code (MDX 2.0) I need to port to Xna is the following. I want to know if this is posible. The steps I used to create a in MDX 2.0 mesh where: //1)we create the mesh mesh = new Mesh (this.device , solidPrimitiveIndexList.Count , solidVertexList.Count , MeshFlags.IndexBufferManaged , PositionNormalTextured.Format); //2) set the vertex buffers using (Graphi ...Show All