Answer Questions

• bszom Import Data from excel file into Sql server 2005?

  Hi all, I try to import data from excel file, my excel file have column called Name, the value of this column is text: ex: Binh Chanh, 1,2,3,4,5.....When i import into sqlserver 2005, these rows which have value 1,2,3,4,5 (number) , now have Null value in SQL server 2005. How can i fix this error Thanks, Do you use the IMEX=1 switch in the Excel connection string (like: Provider=Microsoft.Jet.OLEDB.4.0;Data Source= <your_file_name> ;Extended Properties="EXCEL 8.0;HDR=YES; IMEX=1 "; ) It did the trick for me, although my problem was the other way around: numbers were correct, text was NULL values. So I'm not sure whether it will work for you. Pipo ...Show All

• Eugene Zakhareyev Database Diagrams - SQL Server 2005 Express

  I have installed Visual Basic 2005 Express and SQL server 2005 Express. I am reading the ebook: "Microsoft Visual Basic 2005 Express Edition - Build a Program Now" that you download when you register the products (it is a PDF file named 6-2213-2.pdf) Page 139 of the book (or 151 in the file) is about "To Create Relationships between Tables". So I follow the instruction and get stuck on Step 1. When I right click on the Database Diagrams folder under CarTracker.mdf database and choose Add New Diagram I get the following message: --------------------------- Microsoft Visual Basic 2005 Express Edition --------------------------- This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, ...Show All

• xtw Connect to SQL named instance from another domain

  Hi, I have two domains setup with two way trust in place. SQL server 2005 is installed in domain A. Is it possible to log in to SQL server using machine account of a machine in domain B I have been told that you cannot access SQL server from another domain using machine account. But I cannot find any resource or references about it. If this isn't the right MSDN forum for this I apologize, but any advice would be greatly appreciated. Thanks in advance. Hi I am facing the same issue ... I have reporting servcies in domain A and Analysis Server on domain B , but there are no trust principles between domains. I need the reports to query the AS but my datasources are not able to establish a connection with t ...Show All

• AndyJ_PS Row height issue on export to Excel

  Hi all, I've been having some problems with a report on export to Excel. I have four tables, contained within a rectangle at the top of the report, followed by a second page of tables dynamically generated by the data being fed into the report. On export to Excel, the top sections of tables appear to export with a fixed row height that does not show all of the string contained within the cell. I've had similar issues before with "title" textboxes, but these are usually easily solved by expanding the height of the box within the report. In this case, this hasn't worked! Any idea Regards, Jon Hi Geoff, Thanks for getting back to me. Yes, the CanGrow p ...Show All

• James2007 datetime to date

  Hi, everybody. I have a parameter from datetime type. Its' values are stored with date and time values together in the database. But I only want to show its' date value to the user. How can I do this Thanks Jan. But my parameter's value is not shown in the report. So I can't write an expression or a method to this.( as Datetime.ToString() ) I think I should do this by SQL side. But when I use a convert or cast function on sql side , there exists a type conflict. Anyway, if you find a solution, share it with me please. If you are using the datetime values as a parameter, the easiest way to do this is to create or modify your parameter query: add a column with only the d ...Show All

• a_jam_sandwich Reporting Service 2000 and VS2005

  Dear all: Can I design report using VS2005 and deploy them on Reporting service 2000 Thanks. Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace. However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and: 1. Change the overall RDL namespace Replace <Report xmlns=" http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition " ...Show All

• John.Doe @@ identity does not work ?

  By standard i try my questions in SQL Mangment. set nocount on insert into [order] (orderdate,deliverydate,status,Totalprice,customerID) values(2006-02-23,2006-02-23,'N',10000,10) (insert into temp (orderid)values(@@identity)) Major Error 0x80040E14, Minor Error 25569 > set nocount on insert into [order] (orderdate,deliverydate,status,Totalprice,customerID) values(2006-02-23,2006-02-23,'N',10000,10) (insert into temp (orderid)values(@@identity)) Invalid set option. [ Set option = nocount ] Without Nocount: insert into [order] (orderdate,deliverydate,status,Totalprice,customerID) values(2006-02-23,2006-02-23,'N',10000,10) (insert into temp (orderid)values(@@identity)) Major Error 0x80040E14, Minor Error 25501 > insert into [order] (o ...Show All

• cssjm Sorting by date dimension in report

  I'm trying to build a report with a cube as a data source. Date dimension has the following components: year, month (name), month of year, date. Report is supposed to have 'year-month' hierarchy. It works by the month level is sorted by month name not by it's number in the year. This is not happening when I'm browsing data in SSAS. Is there a way to sort the month names in a proper order Thanks Actually, month is retrieved from a higher member of a hierarchy (year-month-date). Our attempts to format date itself were not successful: whatever we had been putting into FORMAT did not have any effect on date presentation (it still displayed in a default format). OTOH, date extracted directly f ...Show All

• Pavel Makovec Sql Query to update a Column when the subquery returns more than one row

  Hi People, I am having a table which has some 10 cols, only one column had all Nulls. DB-SQL2K5 I am now writing a query like Update Test1 set Id = (Select t2.Id from Test2 t2, Test1 t1 where t2.Name = t1.Name) as likely this query is faling as the sub query is retuning more than a row. What is the best method to achive my requirement Thanks Use this please Update Test1 Set Id=T2.ID From Test1 T1,Test2 T2 Where T1.Name=T2.Name You modify the subqery a little bit: Update Test1 set Id = (Select top 1 t2.Id from Test2 t2, Test1 t1 where t2.Name = t1.Name) Oh Yup , but i ve a query in here.. when u use top1 will it not update my entire table ...Show All

• DanR1 problem with foreach loop container and excel files

  well i am trying to follow the example of msdn help on how to loop through excel files and it doesn't work. the variables have the project scope. what can i do I have a working example that I have done can be download from here . Uses c:\Temp as source directory for Foreach Loop Thank Sutha     All I have done in that example, is just to get the xls files in c:\temp, assign each file name and print the variable to a message box. you still have to do data flow task. Thanks Sutha You are not trying to do this on a 64 Bit by any chance "You may not be able to connect to as many data sources from a package executing in 64-bit mode as you can from a pack ...Show All

• Brandon Lilly SQL 2000 - "Unable to get list of data mining algorithms" - PLEASE HELP

  Hi, I recently started using SQL 2000 Analysis Manager. I wanted to try data mining but was unable to get the Mining Model Wizard to load available techniques. When I select a cube and "New Mining Model" I get the following error: "Unable to get list of data mining algorithms." "Object of provider is not capable of performing requested operation" Please help. Thank you very much, Robert This usually only happens when a) the server isn't started, or b) you don't have the most recent service pack installed. Please verify that both of these has occurred. Thanks -Jamie Thanks Jamie! My issue got resolved with SP4. ...Show All

• jgwufgator ReportViewer Toolbar

  Hi I have deployed my Reports using SQL Reporting Service 2005, but i use ASP.NET page using Report viewer to show the reports to the users. when viewing the report using Reportviewer i would like to customize the toolbar like the background color which comes in gray i would like to change to white. any dea Also i have multivalued parameter, i would like to have a<Select All option > inside on clicking it should select all the options in the list. Any possibility Ok thanks will try..... but there are many .CSS files in the ..\MSSQL.3\Reporting Services\ReportServer\Styles folder which should i change Look for the CSS files in the reporti ...Show All

• khen Fatal Error

  Need help, I am trying to update my server connection ( Microsoft.AnalysisServices.Server.update ( ) )and got the following error message: Microsoft.AnalysisServices.OperationException: Fatal internal error. at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadRespon se(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfEr ror) at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate) at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions o ptions, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult) at Microsoft.AnalysisServices.Server.SendUpd ...Show All

• arkiboys mdx questions

  I'm going to start reading through the performance document, but in the mean time any suggestions on how to speed up the following with member Measures.bucket1 AS sum ( filter (([REL TURN HRS].[REL TURN HRS].[REL TURN HRS]. members * [Measures].[FACT CUT RELEASE Count] ) ,[REL TURN HRS].[REL TURN HRS]. membervalue < 6),[Measures].[FACT CUT RELEASE Count]), NON_EMPTY_BEHAVIOR = { [FACT CUT RELEASE Count] } SELECT NON EMPTY { [Measures].bucket1} ON COLUMNS , NON EMPTY { ([CUSTOMER JOB].[Cust-Title-Issue-Job].[JOB_NUMBER]. ALLMEMBERS ) } ON ROWS FROM ( SELECT ( { [CUSTOMER JOB].[CUSTOMER NAME].&[T016]&[TIME4 MEDIA, INC. (T016)] } ) ON COLUMNS FROM [DW INSIGHT]) WHERE ( [CUSTOME ...Show All

• Michael J. O. Mirror Setup Problems

  We are having problems getting the two databases to connect with each other for mirroring. We have the following setup: - Doing Principal and Mirror (no witness) - Using Management Studio - Both servers are SQL Server 2005 SP1 Standard Edition - Same domain account, same user id - We can telnet to both and connect to both from Stuio. We were originally getting error 1418, but now we're getting: " Neither the partner nor the witness server instance for database "tmsng" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)" This is what the log file looks like: ------------------------------ 2006-11-06 13:01:59.62 spid24 ...Show All