Answer Questions

• ReneeC Aggregate non-filtered members of hierarchy

  Is there a way to create a calculated field that aggregates all members (including hidden ones or maybe non filtered) of a specific level in a dimensions hierarchy ...Show All

• graab Integration of RS with Sharepoint

  Good Day , May I know if there is any sites which explains the integration of RS with SPS Regards Alu You can utilise URL access to the report server or query the web service directly May I know the means for communicating the to the database from Sharepoint to generate reports based on the input by the users in Sharepoint sites Regards Alu You need to use a report viewer web part http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx Basically, I would like a user using the SPS to query and generate a report....with or without RS Regards Alu correct me if i am wrong ...report server is part of the RS package...and does it means that the service pack 2 can do ...Show All

• hazz Is this considered scale-out?

  I picked back up an effort to get our reporting services DR scenario in place and am having some issues. Our corporate approach for production databases is to back-up the database to the local server disk, copy the back-up files to a remote office and restore the databases on remote DR servers. This process is scripted to run overnight so in the case of failure of the production environment we lose at most one day of work. Now, I would like to set up a parallel scenario for Reporting Services and started with reading a bit of documentation. I read "Moving a Report Server Database to Another Computer" and "Backing Up and Restoring Encryption Keys" and then set to work. I have two instances of SQL Server 2005 Standa ...Show All

• wtrn is there an easy way to replace a db name in all stored procedures

  I have a database with 20 sp's. All the 20 sp's were referncing to a look up db whose name has been changed. I dont want to open all the sp's individually and change the lookup table name. Is there an eay way to do a search and replace by using a another sp or something that will look at all my 20 sp's and make the change Thanks Not really. Just script them out into a file and do a search and replace. Hopefully your database name is not the same as any other object, and it should be pretty easy. No. The 'best' option, as Louis indicated, is to script out the stored procedures. In SQL 2000 Enterprise Mangler, you can right-click on the database, click on [All Tasks], and then [Generate SQL ...Show All

• Ridge subreport displays

  I have a few reports that include subreports in them and they are displaying the data fine, but the problem is that when I go to display the report for our users over my site, the subreports seem to loose their alignment. They seem to get padding at the top, and since the reports show each line as alternating colors of grey and white, the grey rows seem to look like they have a nick at the top only where the subreports are displayed. But the reports when printed from the site look fine, is there any way to correct how they are being displayed on the site so our users don't think that there is something wrong ...Show All

• Ryan_H Non windows clients

  What about non windows clients (mac, linux etc) Can they access Reporting Services with personal permissions/settings as long as they are given a windows account on the RS-machine/domain Or... do I have to implement custom security in order to give access to non-windows users Regards Andreas At its simplest, the clients can be given access the Report Manager. You can configure the Report Manager for basic authentication and browser would prompt the user for credentials. Once the user enters the credentials of the local Windows account, she will be given access to the Report Server based on the permissions this account has to the report catalog. Thanks! That's exactly what I wanted to know. ...Show All

• Buster95127390 Import Fixed-width data with DSNs

  Ok, so I've been playing around with SQL Server 2005 64-bit Dev Edition in readiness to phase out my existing SQL 2000 box. I've been having difficulty with importing fixed-width text data with SSIS. To explain, we use a linux based ERP system which is stored in a non-standard, encrypted flat-file format. So, each evening, I have a cron job spin off some shell scripts that use the ERP's report tool dump all of the relevant databases I need into a fixed-width format text file. The ERP platform also has a db layout report which is also in text format, I use this file (mangle it with VB first) and dump it back out into the format used to make a DSN file. DSN connector file (dbname.dsn) [ODBC] DRIVER=Microsoft Text Driver (*.txt; *.csv) UI ...Show All

• J. Clark How to install sql server 2005?

  Hi all, I dont know whether it is right place or not I am using .Net 1.1 and Sql server 2000.Now i have installed .Net 2.0 andthis time i did a small project with .Net 2.0 with Sql server 2000. But my client needs .Net 2.0 with Sql server 2005 regular version. Now i uninstall Sql server 2000. But when i insert Sql serevr 2005 cd it shows 1.Prepare a.Review hardware ....... b.Read the relaese notes c.Install Sql server Upgrades advisor 2.Install a.Server Components ,Tools,Books Online.... b.Run The sql Native Clients Installation Wizard 3.Other Information .... Which one i hav eto click to install a fresh new copy of regular version of Sql server 2005 Thanks Ujjwal ...Show All

• Zero_ Novell

  I have not read anything about SQL running on a Novell server. Does any one know if SQL will run on a Novell Server No, SQL Server runs on Windows only. ...Show All

• AaronJ Conversion MSAccess -> SSCe

  We have plan to migrate our database from Access to SqlCe. Here our situation: We will never use a Pocket PC applications, only Windows desktop application. We want to migrate the .mdb file to a .sdf file (I've seen the ADS application, but since we don't use mobile devices, it's no use) The .sdf will be use on local client machine only. Here's my problems: I've use a conversion to migrate from access ( http://www.primeworks-mobile.com/Downloads/DPW.html ) and seem to work fine. I updated the source code to use the SqlServerCe dll instead of OleDB. Some of my queries work fine, but others just won't work in VS2005 using C#. To check if the query is really wrong, I take exactly ...Show All

• IlCapo what is the best way to concotanate two integer fields?

  one of our marketing people downloads the DNC list from the FTC or one of the other F agencies. he then screens his cold calling list against it. he wants to put it into sql to make it faster. it's a text file and imports 2 fields. The area code and the phone number. I want to import it as integers so i can put some logic to automatically screen his list against it. I can't concontanate two integers into a third column so I'm looking for some advice. should i import them as strings originally, dump to a flat file and then import the full phone number as an integer Or is there a better way You can do this all in one data-flow. No need to export to a file. Import the numbers as strings. Then you c ...Show All

• guyinkalamazoo2 Invalid attempt to read when no data is present?

  when execute If IsDBNull(sqlreader.GetValue(i)) Then Error info:Invalid attempt to read when no data is present but i am sure there were records Any ideas Regards it's ture,below is my code For i = 1 To sqlreader.FieldCount - 1 If IsDBNull(sqlreader.GetValue(i)) = false Then Row.fieldname = Trim(sqlreader.GetName(i).ToString()) Row.fieldvalue = Trim(sqlreader.GetString(i)) End If Next both fieldcount and getname are right Have you checked sqlreader.Read() is true ...Show All

• PMancini SSIS import of dBase tables

  I followed the steps outlined in http://msdn2.microsoft.com/en-us/library/aa337084.aspx and was successful at importing ".dbf" files from a dBase 7.0 folder. However, this import was quite slow: approx. 2000 rows per second. Some of the tables I must import have over 8,000,000 rows, which would then take 4,000 seconds, or over one hour. This import rate seems unaffected by whether or not I put a "Copy Column" Data Flow Transformation task between the "OLE DB Source" and "OLE DB Destination" objects. In SQL Server 2000 it was much faster to import such large tables. The 8 million row table takes only 14 minutes (800 seconds) with SQL Server 2000 -- giving a transfer rate appr ...Show All

• IMBack NEAR syntax in Full-Text Search

  In tuning our search engine which is running against SQL 2005, I'm trying to understand the "near" operator in my CONTAINSTABLE query. I'm doing a query like the following: select * FROM CONTAINSTABLE ( Catalog , *, 'FORMSOF(INFLECTIONAL,"class") OR FORMSOF(INFLECTIONAL,"calendar") OR ("class" near "calendar")' , 1000 ) Entries that have class and calendar directly next to eachother are being ranked higher, as would be expected. But entries that have Class <word> calendar, are being ranked the exact same as they would be with just the two Inflectional ORs and no near syntax. I thought the near syntax was supposed to be useful up to 50 words The near syntax is useful up to ...Show All

• April m Not Associated with a trusted SQL Server connection

  I setup a DSN to a remote SQL 2000 Enterprise Server and was able to successfully complete the test connection. However, when I went to use the DSN to establish a connection in Integration Manager for GP 8.0 I got the following error: "Integration Manager was unable to obtain column information. You will not be able to map to fields in this query until the following problem is corrected: Could not create connection to Data Source '_Web Customers': Attempt to open connection Failed: [Microsoft][ODBC SQL Server Driver][SQL Sevrer]Login Failed for user'(null)'. Reason:Not Associated with a trusted SQL Server connection." I have tried everything I have been able to find on Trusted Connections but nothing seems to wo ...Show All