Answer Questions

• Gulden process analysis server objects from web via ASP.NET + C#

  Hi! We are running several Analysis Services Cubes on a Database Server (SQL 2005) machine. Another machine is our web server (IIS, ASPX) which displays cube content and allows drill down to several levels. Everything works fine and we are looking forward to optimizing the whole data management process. At the moment we try to develop DTS packeges (SQL 2005). Is it possible to initiate a cube processing (without DTS in the background) from eg an administration section in the web page TIA and kind regards from Vienna JohnnyR The control used in the browser is the Office Web Components 11.0 PivotTable control. You can use this control in your asp.net app by referencing this cont ...Show All

• DavidAWinter Referencing the return value of a Subreport

  I have a subreport inside my main report and it is working just fine. The subreport is called sbrCaseSummary. In an expression of another txtbox in the main report I want to reference the value returned from the subreport. How do you reference it I can't find out how that's done. Help. I am having the exact same problem. Anybody have any ideas BJ ...Show All

• Tim C. Connecting to Oracle 9i Server using ODBC from an SSIS package

  I am trying to connect to a Oracle 9i Server to execute a sql task, but the connection when tested seems to fail with the following error from the Integration Services Project: Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). The connection was configured and tested from Oracle's SQLPlus session. Please note that the port that the TNS Server is listening is not the default. Is there somewhere I can sp ...Show All

• cosminb SQL 2005 Performance and SP1

  Has anyone found that installing SQL 2005 SP1 resolves any performance problems that they were having We have many complex queries that are doing a lot more IOs under SQL 2005 than they were under SQL 2000. I have found ways to make some of these queries perform better but others are particulary troublesome. I am wondering if the SQL query engine will behave better after installing the SP1 service pack. Has anyone found this to be true Thanks in advance. ...Show All

• Rattlerr Restoring database from MS SQL 2000 to SQL Express 2005

  Hello, I tried to restore a database which I backuped from MS SQL 2000 to SQL Express 2005 but it always failed with the following error message. What could be the problem Restore failed for Server 'SERV\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional information System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'gtp' database. (Microsoft.SqlServer.Express.Smo) Thanks hi there for the error : "Restore failed for server ser_name\SQLEXPRESS " ,restore cannot proceed database is in used when u r trying to restore from a .bak file Please try the following : Go to Security Option below the database ...Show All

• Matt A merge input output selection dialog is hanging

  Hello I'm trying to use the Merge component. When i attach a datasource to the the component, the Select Input/Output dialog box should popup.. It does, but VS.NET is hanging and i can only shutdown the procesess... Any idea how i should solve this how can i re-register this component ps. sql 2005 sp1 is installed. Thanks Marco Beta Place closed some time ago. You can of course raise a PSS support case for full paid support, or just log the bug/request online at MS Connect, effectively the replacement for Beta Place - http://connect.microsoft.com I am experiencing the same problem. I have SQL Server 2005 SP1 and Visual Studio 2005 SP1. I thought I had worked around this in the past by a ...Show All

• CSharpShooter Tools for database design....

  We have several developers that design DBs using the SQL 200\2005 Database designer. What tools, of reasonable price (< $!000 ) are availabe today for database designers. IA, Barkingdog if by database design you mean data modeling - we recently selected Toad data modeler from Qwest software. Reasonably priced compared to competitors and fairly full-featured. Also works against most relational DB types, not limited to SS. ...Show All

• Coryc how do i look through the log to see updates to tables in sql sever 2005?

  hi. changes were made to a dababase and we need to read the log file to see how much exactly was changed and what. how do i read the log file in sql server 2005 with out buying 3rd party software hi winston,  if you want a cheaper alternative to know what has changed you can use a database snapshot solution as a baseline for comparison.    there's no easy way of looking at the logs you have to use a 3rd party tools such as lumigent or apex sql   joey I posted a reply in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=655927&SiteID=1 thanks lads. i ended up getting ApexSQL Log. ...Show All

• Philip Coupar Enclosing a table create inside BEGIN END

  The following SQL (after the "The SQL" marker) works fine. But I want to enclose it in a check to make sure that a previous script hasn't already created this object and its CRUD. If I enclose it in a block like this... IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ZIPCODE]') AND type in (N'U')) BEGIN blah blah blah END It won't parse. It seems to me like this should be a no brainer, but it is hurting my brain. The SQL... CREATE TABLE [dbo].[ZIPCODE]( [Zip] [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Latitude] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Longitude] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [City] [nvarchar](25) COLLATE SQL_Latin1_Gen ...Show All

• Jamie Thomson How to add a group header and footer for a report

  I have a report that is being called via stored proc, and i want to group by contract. when report gets generated i get multiple contracts info. but will be grouped/sorted by contract. please how can i have a group header and also a group footer to show a summary of each contract information with some calculated fields in it. i may get 100 records related to 10 contracts , 10 rows for each contract. as soon as the first contract info is shown on the report it has to show a summary related to the first contract in the group footer, and then continue populating the second contract info and so on. Please i am totally new to reporting and help would be appreciated. thank you all. Here's what you ...Show All

• Mervin Lobo SQLBULKCOPY Date Formatting Issues

  Hi guys, I have come across an infuriating problem. I have an excel spreadsheet with formatted data. I also have a SQL Server table with 17 columns all nvarchar(255). I have been trying to use SQLBULKCOPY to import the data from the worksheet to the table. This worked with only limited success as it seems to ignore certain values and insert nulls. I converted my excel spreadsheet to a CSV file and tried the same. Now it imports most of the values but seems to be very VERY odd in its handling of what it perceives to be data in date format. In certain cases it ignores the value altogether and inserts NULL, in others it inserts the value but formats it into a datetime format instead. I don't want it to do this, I simply want it to save the ...Show All

• Purnendu flat file connection bug

  What happens is that the flat file connection non of the columns can be altered you can set them in other ssis packages but not in the one that you want to use and when it comes to changes the flat file complains that not a correct file is set, even though there is one set, and when it comes to altering a flat file source it complains that it can not find the connection and the database destination can not find the meta data BUT when it is run it works perfectly, so what i have had to resort to is making the part of the dts package in another package and then copying it accross Do you have delay validation on the connection or source, or are you working off line. Some of the compon ...Show All

• Florim "Package Configurations" Problem

  Hi all, I have just set up my first deployment utility for the Integration services package i've been building. I seem to be getting problems with the package Configurations. I added an XML config file so that i could change the values of my SQL connection manager at deployment time. This was so that i could deploy it on both a test environment and the live environment. Any other variables can be changed in code by the calling application. As soon as i added the options for the sql connection manager and enabled package configuration i got errors when running the application: [Execute SQL Task] Error: Failed to acquire connection "InternalProductionData Connection Manager". Connection may not be configured correctly or you may no ...Show All

• maddman Problems after service window

  This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working. A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3). This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded). I have ...Show All

• progames25 Linked server and replication

  Hello, I have one server using SQL Server Express (Server1\SqlExpress - Sql Authentication) and another one using Sql Server 2005 (Server2 - Windows Authentication) My Server2 is the publisher for a replication and Server1\SqlExpress is the client for this replication. For any reason that has been discussed in details with Raymond Mak in some other threads, some triggers and stored procedures cannot be replicated via the replication, so I use a post replication script. To avoid having to maintaint coherent my source control, my master DB and the post replication script I wanted to create a script that will extract from the master DB the source code of the problematic triggers and stored procedures. To do that, here the kind ...Show All