Answer Questions

• fly_eye save data selected in cube browser tab

  Hi, I'm using cube browser tab for browsing for interesting cube data. Once selection is made, I want to save results to file.  Also, I would like to use cube actions and their involved features to accomplich that. Is it possible to make my own custom save method, wich will be used from various application for cube browsing, such ProClarity is. Does someone know something about... with regards   ...Show All

• basedissonance Sign a document by SmartCard on the .NET client and verify on the SQL 2005 server

  Hi! I'm working on the following application: In the client application (written in C#) an user signs a document by private key, stored on chip card. Signed document and the signature are stored into database on SQL 2005 server. There is my client code for demonstration: Client application sample: System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("Data Source=localhost;Initial Catalog=Tes ...Show All

• ManishMenon Hiding the header on first page

  When I hide the header on the first page of a report, the objects in the header (i.e. textboxes) don't show up on the first page, as expected. Unfortunately, the space the header would occupy DOES show up, it's just empty/whitespace. Example: What page 1 should look like: | ------------------- | Report... | | | | | |------------------- What page 1 does look like: | ------------------- | (white space) | ------------- ...Show All

• Matthias Eck Problem in SQL 2000 Analysis Service installation on windows 2003

  I am installing SQL 2000 analysis service on Windows 2003 but when the installation bar reaches to its completion, it closes down without any warning. I can see the directory created but no related service or icon is created. Also there is an error message in the even viewer. Faulting application _INS5576_MP, version 5.53.168.0, faulting module,oleaut32.dll, version 5.2.3790, fault address 0*00060484 It is probably the case - AS 2000 ...Show All

• Habbit Problems with Lookup task and dates

  I’m trying to make a Lookup transformation with a relation on two string columns and a between dates condition set by parameter: select * from  (select * from [dbo].[RgnErhverv_Ansvar]) as refTable where [refTable].[Opretdato] = and between StartDate and EndDate where the second parameter is my Date column (FakturaDato_konv) . My problem is that I keep getting the error: "Error 1 Validation error. Data Flow Task: Looku ...Show All

• Diego Gonzalez Urgent help is needed.

  Hi, I am trying to connect to a SQL server on a deferent machine using ASP.Net written in C#. The machine on which the SQL server reside dose not have the ASPNET user and the authentication is falling. Any ideas on how to connect using a different User. I changed the ASP.Net service on my machine to run as a deferent user MyUser, which is a domain user that have access to the server machine Note: We can not change the privilege ...Show All

• Jason Zhang Upgrade/migrate to new hardware. What's best?

  We have a new server with Windows Server 2003 and SQL Server 2005.  Our current box is Windows 2000 server with SQL Server 2000.  All have the latest patches.  The new SQL Server has no databases installed, it's a brand new, clean installation and it is not in production. We have no specialize components or anything on our SQL 2000 box.  Straight tables, view, stored procdures, functions, etc. What is the best way to mo ...Show All

• Mustapha64925 How can I read data from a dataset directly into a sql database table using IS ?

  Hi ! I've got a series of datasets which I need to transfer directly into a set of database tables.  I can't find any tools in the IS for doing this, except using a XML source, which means I have to use a temporary file, which I of course won't have.  What am I missing   What  is the way to do this Any help appreciated ! They reside in .net assemblies.  The data comes from a system w ...Show All

• djm0412 No recovery/no log file wanted

  I have a SQL Server (Express) database that I use in a Visual Studio (Visual Basic) 2005 application. The application is of the Decision Support type, that routine deletes the contents of some of the database tables and then re-populates them with new data. There is no reason for keeping the "old" contents and no reason to restore the old content. (It does this using "BULK INSERT" statements, as in: "BULK INSER ...Show All

• ME1258 Usage of Raw File in SSIS

  What is raw file in SSIS, could you tell me samples for usage of raw file Oh please. Did you even bother to look at the links above You need another data-flow with a raw file source adapter and then you treat the data as you would any other data in the data-flow. -Jamie Have you looked at BOL http://msdn2.microsoft.com/en-us/library/ms140169.aspx http://msdn2.microsoft.com/en-us/library/ms14 ...Show All

• Eric Oostergo permissions for developers not working after 2005 upgrade

  Prior to our move to 2005...permissions were granted to developers by adding them to the following fixed database roles...db_ddladmin, db_datareader, db_datawriter, and db_securityadmin. They created their objects using 'dbo' as the owner. After upgrading to 2005, suddently they are having difficulty accessing their objects with this same security. Do they need permissions on the dbo schema They are making ...Show All

• odklizec How do I extract data from selected rows from my excel source file?

  The columns in my excel source contain data of different types with the column name being a string and the data in those columns being integers. Is there any way to only extract numeric data , in short I want column names to be omitted. Also the data is distributed unevenly , beggining at various rows in each column. Thanking in advance :) You can try to create a named range in the Excel sheet and then import only the range. HTH. ...Show All

• EileenWin Disable password policy enforcement SQL server 2005

  Is there a way to do this at the server level Thanks Yes, but then you would disable the policy enforcement at the OS level, not at SQL Server level. Thanks Laurentiu No, there is no global switch to turn on or off this protection. Thanks Laurentiu I guess yes there is you have to open the Local Security settings using the mmc plugin and disable the Enforcements of policy settings li ...Show All

• maxmin Parameterized Query Using Wildcards in VS2005

  Hey everyone, I have a smart device project in Visual Studio 2005 that has a SQL Mobile data source. I am trying to create a parameterized query that utilizes 'LIKE' and wildcards. My query is below: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @StreetName + '%') However, when I test this on my PDA, I get the following error: SQL Execution Error. Exec ...Show All

• Nicolas B. Is it possible to create a bar code in SQL reporting?

  I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.   Thanks thanks Or you could try this Windows Form Control that supports Reporting Services. http://www.technoriversoft.com/developer.html IT is not good way it is because when you comp ...Show All