Answer Questions

• Pennysworth #N/A in measures - Excel 2003 client

  After giving some users read access to the cube, by using a readonly role - The [Measures] are displayed with #N/A in Excel 2003. Only users with loal administrator previledge can see measures. Please advise. Dear ASMK , Please check your cell security MDX, the measure you are viewing might be in the denied member list. This might be helpfull. Can you pl ...Show All

• SamLowry General Network error

  I am using Windows Form with web service, I am getting error ocassionally when I am accessing records " System.data.sqlclient.sqlexception General Network error " , When I click again the error disappears. This is not a security related error. You should try the SQL Server Data Access forum. If you want, I can move this thread there, just let me know. Thanks Laurentiu The information here is really not sufficient for us to he ...Show All

• __den Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT.

  We are using SQR for Peoplesoft 8.47 and MS SQL Server 2000. I have a straightforward program that inserts Merit and Accomplishment data from a csv file into 4 tables. The majority of the fields that are inserted for each table are obtained by doing a select on that table. The csv file provides the updated fields to include in the insert. What I have run into is this: If the CSV file has more than 50 rows in it, it bombs with the follow ...Show All

• lekkie CTE in a DSV named query

  Hello, I have a CTE that I want to put into a DSV named query. here is the CTE (which anyone can run): WITH mycte AS (SELECT TOP (200) object_id, name, column_id, system_type_id FROM sys.columns) SELECT object_id, name, column_id, system_type_id FROM mycte AS mycte_1 I can put that into the named query editor and run it, no problems. Upon clicking "OK" I get: Incorrect syntax near ')' In ...Show All

• ckm rsexecutionlog_update.dts RS 2005 Equivelant

  Hello All, In RS 2000, MS released optional scripts (including a dts package) that would suck out data from the ExecutionLog table and perform archiving of this data etc. These scrips could be found in \80\Tools\Reporting Services\ExecutionLog. Is there an equivelant in RS 2005 Cheers Rob ...Show All

• SherryZ. Cannot access Calculations tab, BI Studio hangs up after installing SP1 and Hot fix.

  Dear All, I have installed SQL Server 2005 SP1 and Hot fix, and after that I cannot access calculations tab in BI Studio. any suggestions! Thanks Some questions. 1. Are you working with the offline project files on disk or you connected BI Studio directly to the database on the server 2. If you work with the offline project on disk, does it happen with all such projects or with some s ...Show All

• acorn_atom SqlDeveloper/SqlExpress Conflict.

  Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access my database, so after three attempts I gave up temporarily. When it looked as if I was actually going to finish my project, I decided to sort out ...Show All

• Rajat Tripathi Using same data for training and test?

  Question; You should never train a DM model and use the same data to test the model prediction performance. But. If using clustering, and using PredictCaseLikelihood trying to filter away outliners (in a DTS package), does it matter if you train the model on the same data as later will run through the DTS package I mean - this is not really a prediction, but instead a measurement of how rare a case is, based on a whole population. Than ...Show All

• Ted Sung Watermark Generation is Invalid Error

  We are currently doing a proof of concept using SQL 2005 merge replication.  However we are currently encountering the following errors: "The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up." " The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be los ...Show All

• Haggerty Trim Strings

  I have a lot of data that I import from a flat file that is generated by an AS/400 system.  Some of the flat files have 30-50 columns that are all character data.  The file is fixed width.  When I import into Sql Server, I always end up with the trailing spaces at the end of the string.  I know I can setup a convert column task and trim each column, but I was wondering if there isn't an easier way to trim all string data ...Show All

• Odie5533 SQL Studio 2005 projects vs. VS.NET database projects. Which is better?

  I've been using VS.NET to create database projects and store sql scripts for quite some time now ( file -> new project -> other project types - database). But now with similar projects also in SQL 2005 Management Studio, which is the best approach to use What do you think Here’s my initial assessment and please feel free to chime in because I’ve been using SQL Management Studio projects for only a couple days. Both have integr ...Show All

• mark92929 ODBC data source

  All I want to know is... Is it possible to have an ODBC data source in Analysis Services 2005 (I am using the June CTP of SQL 2005.  I create a new Analysis Services Project using VS 2005.  When I try to add a new data source, "ODBC" is not listed in the Provider list.  What am I doing wrong ) Reply from newsgroup from Microsoft: AS2005 is not going to support ODBC data source. However, you c ...Show All

• mynakedrat Thank Microsoft for many and nothing

    Sql server has some very good features but some possibilities are forgotten.   For instance in DTS2000 there was a possibility to make data transfer packages from  a AS400 ODBC connection (With parameters )  to Sql server tables. Those parameters were set in a dynamic properties task. In Sql server I can get variables out of sql tasks and even pass a parameter to an ODBC Sql task. This all works find. However when ...Show All

• Arnaut How to execute ssis package from stored procedure

  how to excute ssis package from stored procedure and get the parameters back from ssis into the stored procedure. Can I ask why you want to do this I have a SSIS package that does data query based on the Fuzzy Logic. Parameters are passed to SSIS and SSIS returns the recordset. Now I have a Java based web application that calls the procedure for many things, one of the things that procedure wants to do i ...Show All

• Nchantim beginning SQL

  I purchased SQL Server 2005 and intend to take a class this month. I have installed it. How do I get started trying it out I took an online tutorial, but I don't understand the mechanics of accessing the db to start with or if I even have a db to work with. Any suggestions Book on line > SQL Server 2005 Tutorials >SQL Server Tools Tutorial ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/655e709b-34 ...Show All