Answer Questions

• Psycho Potato cannot install express edition

  I am using the SQL Server June 2005 Community Technology Preview and installing express edition from it. I did unisntall the old version of sql and .net framework. Then followed the instructions on page http://www.microsoft.com/downloads/details.aspx FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en but I am getting an error "sql server 2005 CTP setup has detected incompatible beta components from visual studio or ...Show All

• jkcy Backup File I/o Error

  Guys, Apologies if this is in the wrong section. I have a SQL 2000 database which I backup to a folder on the hard disk using the following command in a Server Agent: BACKUP DATABASE [Multilog] TO DISK = N'C:\MSSQL7\BACKUP\multilog_backup' WITH INIT , NOUNLOAD , NAME = N'Multilog backup', NOSKIP , STATS = 10, NOFORMAT Recently it has been failing with the following error message: Nonrecoverable I/O error occurred on file 'C:\Multilog ...Show All

• Devilar Data Transformation: copying a table to a table... How does it work?

  Hello, Probabaly a silly question yet as a DOTNET developer, I'm trying to simulate DTS when for example, I don't have permission to perform DTS on a production server. In particular and interested regards caching of rows before the service decides to flush the buffer and write to the target table. Safe to assume DTS is cursor based What type of cursors and where Not really sure where that comes from, as ...Show All

• fordguy67 to get the latest price value

  hello all.. having been search around for days but no clue.. Hope some MVP can help.. typically from transaction, there are TIME dimension, PRODUCT dimension, and there is PRICE value measure.  normally, OLAP returns is the sum aggregation of the PRICE value when cross joining the TIME and PRODUCT.  However, I would like to retreive only the LATEST PRICE of a product.. return result should be:     & ...Show All

• John Garland Printing Blank in Landscape

  I've a report which is quite wide, and I'd like to print it in landscape.  In using the ActiveX control to change the print settings, the Preview looks great in Portrait, yet when I change it to landscape I get 8 pages of blank. If I change it back to Portrait, I get an error saying there was an error rendering the report. Has anyone had any luck with this Thanks. I have set the page size correctly.  It's not that extra blank pa ...Show All

• PKlammer The SQL Network Interface library was unable to register SPN. Error: 0x490

  I recently installed SQLExpress Beta 2 on WinXP. After power up and logon there is a substantial delay - minutes - sometimes maybe forever. In the event viewer I see: "The SQL Network Interface library was unable to register SPN. Error: 0x490" This is on my home network with two computers one using WinXP the other Win2000 configured as a workgroup. I say maybe forever because if I tire of the wait and hit system reset - after ...Show All

• Christian Bayer 64 Bit OLE vs. 32 Bit OLE

  I have a SSIS package that works on Windows Server 2003 32 Bit with SQL Server 2005 32 Bit when I move it to a Windows Server 2003 64 Bit (AMD) with SQL Server 2005 64 Bit it fails with error 80040154 on the connection to an Access 2000 database. The solution maybe Jet 4.0 SP8 however I can not find SP8 for Windows Server 2003 64 Bit AMD (I can find Jet 4.0 SP8 for Windows Server 2003 32 Bit, Windows Server 2003 64 Bit Itanium however). Ju ...Show All

• Sean.Stagner Duplicate Dimension Members

  Hi everyone, In AS 2000, some of the dimensions I was using had both the key & the name of the dimension as the same text field (dimTable.name).  This grouped duplicate dimension members together.  Browsing the dimension only showed unique members. In SSAS, my understanding is you need a key attribute that links to the fact table, or another reference dimension.  Since the dimension I was using had an intermediate key on ...Show All

• daniel sovino Parameterised Query Performance Problem

  Hi all, need ur input for the following short script:  SELECT SUM(Amt_Payable)  FROM ipadmin.Rx rx  INNER JOIN ipadmin.rx_txn rxt   ON rx.rx_id = rxt.belongs_to_rx AND rx.rx_status = rxt.txn_status  INNER JOIN ipadmin.rx_link rxl   ON rxt.rx_txn_id = rxl.belongs_to_rxt  INNER JOIN ipadmin.rx_detail rxd   ON rxl.belongs_to_rxd = rxd.rx_detail_id  WHERE rxt.receipt_no = 'AH0114856'  ...Show All

• mortenmort WHERE includes all letters

  Hi I would like to perform a procedure which takes a string of numbers and searches for strings in a table which include all the given numbers in any particular order. problem is i can only return strings which include 'any' of the letters in the search string and not 'all'. this is how i perform it so far: @IncludeNumbers VARCHAR(50) AS BEGIN SELECT Phone AS [Telephone Number] FROM tbl_Person AS p WHERE (p.Phone LIKE '%[' + @Incl ...Show All

• MaGa820 Can't find properties

  This is the first time I've used SSRS. I've created a report and in preparation for deploying it I am trying to find where I set the properties. In Visual Studio 2005, in the Solution Explorer I right click on my .rdl file and select properties. The only properties listed are File Name (which is changeable) and File Path (which is not changeable). The property pages icon in the same dialog box is greyed out. Am I missing someghing Any help woul ...Show All

• Mark Mrachek How Does one Save a Stored Procedure

  In Microsoft SQL Server Management Studio Express you can right click on "Stored Procedures" under a database in the object explorer and the resulting Context Menu offers a selection called "New Stored Procedure". If you select  "New Stored Procedure", a Stored Procedure Template Document is added for editing.  It has the suffix ".sql";  I can save this document to the file system after I edit it, but  I cannot f ...Show All

• TerryWang Date Format

  Hi, I want my query should return a content of date field in 'MMM-YYYY' format. Can Anyone help me to get this You may use Year() and Month() functions alongside the convert() function. There is no built in function to do that. You can use the date functions like datename to get theappropiate results. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Henrylau Virtual Cube

  From the online help , i got to know that Virtual cube will be removed in the next version of Microsoft SQL Server. I am planning to use virtual cube to encapsulate a subset of the measures, dimensions, and levels contained in one or more cubes. Since it will be remove from next version of MS SQL Server, it will not be a good practice if i continue using it. Hence, i would like to know, is there any method to get data from different cubes I ...Show All

• atreus769 NULL Returned for Populated Column

  Here is a strange one: The following partitioned table (partitioned for 31 days) with a single nonclustered, nonunique index is behaving improperly on a select. A standard select using the index returns all NULL values for altitude yet if I do a select for the TOP x rows ordered by reporttime desc for not null altitudes, I see the values stored in the column. There are over 5,000,000 rows in the table with a relatively even distribution over ...Show All