Answer Questions

• Panther37 Restricting number of records

  I want to restrict the number of records coming from an OLEDB source. I have 500 records in my source table and I want to process one record at a time I have I set the MaxBufferRows parameter to 1and it l sends 8 records from OLEDB source Any help is appreciated. I tried with restrictig rows in sql using 'select .... from where id='. and using a for loop container. However when I executed it I got buffer over flow error after inser ...Show All

• Frank Srebot Strange behavior with Calculated Members

  After creating a Calculated Member like this: CREATE MEMBER CURRENTCUBE.[Product].[Family Line Product].[Line].&[PCs].[XPC] AS AGGREGATE({ [Product].[Family Line Product].[Family].&[Business PCs], [Product].[Family Line Product].[Family].&[Home PCs] }), FORMAT_STRING = "#,#.0", VISIBLE = 1; I would expect to find this Member only in the [Product].[Family Line Product].[Line].&[PCs] Member Identifier. But this C ...Show All

• Debblr User Access issue

  Using Developer 2005 The Analysis Server is Started   The fact and dimension tables are in an Access DB locally on the machine.   The cube builds fine but when I try to view it in the Brower tab (VS) I get the following error:   Either the user, Dev3\User, Does not have access to the ASP1 database, or the database does not exist. OK, You all wanted me to figure out this on my own ...Show All

• ChrisMSG Retrieving multiple Result Sets from within a stored procedure

  A coworker of mine came to me with a question about a stored procedure he's working on. In this case, he has a stored procedure which invokes a second stored procedure. He wants that second stored procedure to return two result sets and then make use of both of them in the original stored procedure. I know how to make a stored procedure return multiple result sets (just do two select statements), but how would you utilize those from the original ...Show All

• Ben Rinaca From MySQL to MSSQL 2005

  Hello! I'm installing the MSSQL 2005. And i want to transfrom the DB from my old MySQL DataBase to new MSSQL Database. How can I do this With Import|Export Utils I can't do this task =( Pleasure Help me. Thanks Hi, just wondering, did anyone manage to get it to work properly Daren Issues I've noticed so far with OLEDB: a) mysql 4.0 date column type is not recogni ...Show All

• Ryan Lowdermilk multiple instances of Reporting Services - is it possible?

  Hi there, is it possible to host multiple Reporting-Webs and Reporting-Databases on a single Server What I want is to create two virtual directories http://myserver/reports http://myserver/reports_internal and each web points to a different Database with different reports. Best regards Markus It would be very helpfull if you could tell me how this work! Thanks Markus ...Show All

• thn SQLAgent2005 not starting

  I installed SQL 2005 successfully but sqlagent is not starting, giving the following error: SQLServerAgent could not be started (reason: Error creating a new session). And in the agent log I see the following error. Message [298] SQLServer Error: 208, Invalid object name 'msdb.dbo.syssessions'. [SQLSTATE 42S02] Can anybody give any ideas how to solve this Thanks... Doesn't work for me. Yes - the agent st ...Show All

• GavinRitchie Setup Sql Server in Client Server Environment, access from PDA and laptop

  Hi, I want to set up MS Sql Server 2000 in client server environment. Basically I want to have my Database server in my desktop from where I can administrate, allow and restrict user access, and maintain the database. Then I want the ability to access the database from my laptop, and PDA using LAN, TCP/IP protocol. I also don't know if there is any client software, which only allow select, insert, update, delete capability from the client ...Show All

• Philip Falkenberg Currency Symbol Problem

  I am currently writing a report in SQL 2005 RS and have a problem with the format of a currency field. I am creating the report through the 'SQL Server Business Intelligence Development Studio' In the report preview (and live) it shows the prefix for the field to be $, and yet when I look at the custom format for the field it shows it as being Format Currency and the sample shows the output will be ￡1,234.00. If I change the format to percentag ...Show All

• Cordt How connect SQL server 2000 with c#.net .....?

  Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs i am working on windows 2000 prof O/S i have just downloaded the sqlserver 2000 form the net for installing this i have used the command in dos prompt... C:\Program Files\Microsoft Visual Studio .NET 2003\Setup\MSDE\setup sapwd=logic securitymode=sql a ...Show All

• BDavlin What is faster: DataReader or DataSet or something else?

  Hi, I need to read 250,000 records and show this information. I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast. What is faster: DataReader or DataSet or something else Thank's Alexei Is it an I/O issue   Have you tried looking at some performance counters to see where the bottleneck might be   Is it a query issue   How complex is the query   Do yo ...Show All

• SummerBob DTS Package with Dynamic Properties running Analysis Services Processing

  Hi, I wasn't sure of the location of this as it spans quite a few areas. I have created a DTS package with Dynamic Parameters. The package is going to process the Dimensions of a cube therefore I have a dynamic property : DimFolder -> String -> myServer\myCube\DimFolder Which sets the TreeKey of the Analysis Services Processing Task to set the DimFolder to the correct server. When I click on the parameters task and run is it ...Show All

• uanmi Rendered html report has incorrect hyperlink url

  I edited the RSWebApplication.config parameter <ReportServerUrl> to put in an ip address so that reports have ip address not name (i.e. http://192.168.1.5/reportserver ).  That seems to work fine except for hyper linked reports from within a rendered html report.  I still get the server name not the ip address.  I also tried the parameter within a report of =Globals!ReportServerUrl and it gives the server name not ip address ...Show All

• goatchees How To Avoid Table Scan

  Hello All, Is their any way I can avoid a Table Scan by modifying the follow WHERE clause WHERE tbl_mis_Dashboard.loan_active_flg = 1 AND [tbl_mis_Dashboard].[loan_create_dt] between DATEADD(dd, DATEDIFF(dd,0,dateadd(mm,-13,getdate())), 0) And getdate() The field loan_create_dt is indexed on the table tbl_mis_Dashboard. The query returns approximately 256K records which is appropriate and necessary. Thanks all, Orlanzo ...Show All

• Michael Sync Help! getting errors when trying to connect to SQL Server Management Studio

  Hi All, I have Windows 2003 Server with MSSQL 2005 Standard. I am able to connect via Windows Authentication, but when I try to change it to SQL Server Authentication with user 'sa' I'm then being prompted with the error msg: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient ...Show All