Answer Questions

• arghhhhhh Paging large result sets

  I use SqlServer on my web app written in Java. I have went through quite a big effort in trying to realize a flexible paging algorithm that I can include in my set of libraries. However having to deal with too many unknows like do I want the RS ascending/descending, what is the first/last itemid, next/previous page (and then invert logic what is up what is down) I'm quickly going mand. I realise there is a fine line where this is a tsql problem ...Show All

• Harald Kjersen memory management

  Hi all, I'm probably missing something here but I need to know why AS2005 is not using the maximum memory available on our production server. I have a 3.5 GB cube on our server and the process msmdsrv.exe is only using around 100 mb currently. When multiple users are hitting the server at the same time, msmdsrv.exe goes up to around 650 mb but will eventually return to 100mb. There is actually 4 GB of memory available on the server, is ...Show All

• Joel Holder Why use CLR procedures for simple queries?

  Allow me to preface this by saying I'm really excited about writing stored procedures, etc. in C#!! Now...on to my question. When an application needs a simple result set (i.e., SELECT....), why use C# to write this In the samples I've seen, the developer ends up writing the select statement anyway in the CLR hosted stored procedure. What would be the benefit You end up writing more code just to write the same query. Now, executing complex logic ...Show All

• Samster DtsBackup2000 for SSIS packages??

  hi everyone, Up to moment I've been using Dtsbackup2000 for do backup for our DTS but now, which let's allow do the same with dtsx TIA If its a .dtsx file then a file system backup will do the job. -Jamie I don't realize and I've deleted a package. If I would have a backup I could restore it as in old times by dtb/dts you're right ...Show All

• motters Uninstalling SQL Server 2005

  Besides going through add/remove programs then selecting the components you want to uninstall, is there anything else left over from the uninstall such as mdf files, registry keys, etc. that I need to take care of to feel 100% confident that SQL Server 2005 if off my server before I reinstall a fresh copy If your upgrading from CTP to RTM, its best to do a scratch install All "user data" is left behind. T ...Show All

• JCCJ Problem in Deploying Analysis service projects using SQL server Business Intelligence Development Studio

  after creating Analysis service projects using SQL server Business Intelligence Development Studio when the project is deployed it gives following error......... Error 1 The project could not be deployed to the 'Solversa-201\SQL2005' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Sol ...Show All

• adman666 Problem Installing SQL Mobile 2005 Tools

  I'm trying to install the SQL Mobile 2005 Server tools on a Windows 2003 Server with IIS & MSSQL 2000 sp4. I've stuck .NET 2.0 on already, but the installer for the server tools Sqlce30setupen.msi just goes straight to the last page of the wizard and says the install was interrupted. I've run the install with logging turned on and this is the last portion of the trace. Can anyone shed any light on whats going wrong. -------- ...Show All

• Chester03 web services as data source?

  I'm having a difficult time getting a handle how to pass datasets to my remote reports, and I'm trying to avoid programming in C# or VB as much as possible, but it may not be feasible. Although we are successful when we use the Report Designer to cut and paste SQL queries from our TableAdapters, I want to abstract the data access code from the report code, and simplify my reports as much as possible. Can I point to a web service which returns a ...Show All

• wywy connection problem

  Hi I want to connect a VB6 application to a sql express 2005 database. My database is on a server with windows 2003 server and my application is running on a windows XP machine. I try to use ado and almost all connection string i saw on internet, the best i got is the error: connection failed SQLState '01000' SQL Server error: 53 SQL Server does not exist or access denied. even if i use the same server name and authentific ...Show All

• Troy Neville ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• m.delara Trouble importing csv with flat file source

  Hi, I am having trouble importing a CSV file with double quote as a text delimiter.  The problem arises because one of the text fields has double quotes embedded in it.  This file loads perfectly in SQL 2000 DTS, but SQL 2005 SSIS will fail on the flat file source.  I would appreciate any input on this. Thank you, Nick Russo Craig, I can't reproduce the failure you're encountering.  Here's ...Show All

• j_jst Management Studio and Beta versions

  Hi, Does the SQL Server Management Studio Express (CTP) November 2005 work with Sql Server 2005 Express which was included in the Visual Studio Team Suite 2005 Beta 2 Thanks, shiversticks SQL Server Management Studio Express only works with the RTM versions of SQL Server 2005, SQL Server Express, SQL Server 2000, and SQL Server 2000 Desktop Engine. You can download the RTM SQL Server Express here: ...Show All

• TheShadow Using Teradata .NET data provider as data source

  Recently I installed the .NET data provider for Teradata. In a regular C# application I can add the namespace, " using Teradata.Client.Provider; " to connect to this data provider directly without going though ODBC or OLD DB so I know it works. However, when I open Reporting Services (new project -> Business Intelligence Projects) I do not see how to add the Teradata .NET provider. I only see the same standard data types ...Show All

• Ken Courts Internal error in fresh install of reporting services

  Hi, Im having difficulty getting a report to work with SSRS for SQL server 2005.  The server configuration utility looks fine, but when i try to deploy a report, or access the site, i get: (rsInternalError) heres the log file: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>   <Locale>en-US</Locale>   <TimeZone>New Zealand Daylight Time</Time ...Show All

• Ovidiu Getting error working with Transfer SQL Server Objects Task

    I was trying to transfer a SQL Server 2000 database  to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered:   "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“   can anyone suggest me what is the error here Is there any other way possible to achieve ...Show All