Answer Questions

• zerovelocity The media set has 2 media families but only 1 are provided.

  I made a backup of my database from ServerA (SQL 2000) and trying to restore it to ServerB (SQL 2005) and get this error below, even after configuring the log and data paths for the restore: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'serverbname'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All membe ...Show All

• Nick K. UNIQUE/PRIMARY KEY confusion.

  I wrote this stored procedure and it works fine, it seems. The questions I have are as follows: (1) What is the difference between PRIMARY KEY and UNIQUE. They seem to pertain to the same behavior. When I used only UNIQUE as qualifier I did not see that the column was marked as primary in the SQL Management Studio. What I need is for a column to be unique in the sense that it would not allow duplicate values and it must have an INDEX on it. I need it to be descending . (2) Did I do it right or there are aspects in here I do not quite see set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[CreateTableDailyClose] @symbol varchar (10) = null AS BEGIN SET NOCOUNT ON; DECLARE @SQL VARCHAR(500) SET @SQL = 'CREATE TABLE dbo. ...Show All

• arogan Problem with Query

  I need to replace the text (III|xII) with (1II|xII)'. For that i created the following query. SELECT (REPLACE((STUFF(Col1,1,1,'1')),'I','1')) FROM SourceData WHERE Record = (SELECT Record + 2 FROM SourceData WHERE Col1 = 'MILESTONES' AND Heading = 'Milestones') AND Heading = 'Milestones' The problem with this query is that it replaces all '|' with '1'. ie, it gives (111|x11). Could anyone ple show me what's wrong with the query. All help appreciated. Thanks, The following code will give you the flexibility to change any char in the string, at any position, at any length. This function returns max 15 chars (but that’s easy to change)… CREATE FUNCTION dbo.FixString ( @DataString varchar(15), @StartPosit ...Show All

• MCFH package 'Microsoft sql management studio package' failed to load.

  When trying to start the sql management studio i am receiving that error below and then the program closes. I am running Windows Vista Ultimate x86. any help would be appreciated. Until SQL Server 2005 SP2 is release, SQL Management Studio is not supported on any Vista edition. Only SQL Express SP1 is currently supported on Vista (excluding Express Advanced and Express Tools, which also won't be supported until SP2). Current plan of record for SP2 release is sometime this quarter. jeff. Now i understand, thank you very much so basically my best bet for what i am trying to accomplish is to wait for SP2 to be released. thank you very much. I currently do not ...Show All

• xyzt Report Title Help

  How can I make my report title width the same as the table The table can hide some columns based on the If/Else logic, but Report Title textbox is always static. What happens is that my table can be longer or shorter then my title. Thanks Yadgor2000 You can add an outermost table with two header rows to your report. Put the report title textbox in the first row, and the table you currently have into the second row. That way, the title textbox will grow or shrink based on the width of the inner table. ...Show All

• Bizzeh Strange behaviour with Sequence Container task

  Hi everyone,   Our VB application throws .dtsx on-demand by using Threads. Everything's fine but a little detail: when it goes to launch a SSIS package with a only task, concretely a Sequence Container task (empty, without tasks inside) fails Prevalidate method.   Attach you the snippet of code:     pkgResults = pkg.Validate( Nothing , Nothing , EventsSSIS, Nothing ) -- pkgResults returns me Failure {1}   If pkgResults = DTSExecResult.Success Then .. ..   Validate method, as usual, do EVENTSSSIS.PreValidate event and after that, returns instead of follow raising events.   Perhaps it's mandatory to set one task as a minimum, I don't get the point at ...Show All

• Mirko Messori FIX TO: The attempt to connect to the report server failed. Check your connection information...

  If you get the error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. If you then scan the recent logfiles in C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and find the following exception: Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: . it means that you have configured the /reportserver/ app to not be reachable via http://localhost/ ... - there are two options ...Show All

• Philos100 SQL Server 2005 can't be added Active Directory, but the documentation says it can.

  Hi, I've installed SQL Server 2005 on Windows Server 2003 SP1 Standard Edition. Before I install SQL Server 2005, I've configured Windows to be an domain controller with Active Directory. As the documentation said that using Object Explorer and then selecting Properties, I have the property page of Server Properties. But I still can't find the Active Directory page. When I try to run the system stored procedure sp_ActiveDirectory_SCP, I can't either register or update. Is this an error or bug Using SQL Server 2000, I can easily add it to Active Directory. Now I can't do it in 2005 version. Please help! Eriawan Please answer my questions... I still can't register Sql Server 2005 to my Active D ...Show All

• Stefan Wenig HideMemberIF: Parent vs. Only Child w/ Parent

  Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions: (1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property (2) If so, has that changed with SP1 This is very encouraging ...Show All

• Asday how is the market for Analysis Services

  Hi Friends, Many of them are not aware of MS Datawarehousing(DWH) tools and technique. How is the market for Microsoft DWH in general are there a demand and need of skilled personals in these areas Thanks, Rajiv. It is a fast growing market. Have a look here for information about market shares for OLAP: http://www.olapreport.com/market.htm These figures say nothing about SSIS, SSRS and they are from 2005. HTH Thomas Ivarsson ...Show All

• Joseph Stalin Web Service Task always failing

  Executing the simplest of Web Service tasks consistently fail with the error: "Object reference not set to an instance of an object". This really isn't a very helpful message for this task, and there's nothing from the task editor that can be adjusted. I am using SP1, the HTTP connection to the service tests OK, the WSDL file downloads OK, and the methods and parameters appear OK. Suggestions Richard Here's the entire error message as displayed in Visual Studio 2005: SSIS package "ConvertMoney.dtsx" starting. Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.W ...Show All

• xboxracer Query VS Stored Procedure problem

  Hello. I am having a strange problem with SQL Server 2005. I have written a SELECT query that contains unions, joins and group functions. when the sql query is run using t-sql statements, the query completed execution in about 10-12 seconds. When the same query is written in a stored procedure without making any changes in the SELECT query (only adding a date parameter), it does not generate any result. I waited for about 1 hour for the stored procedure to give me the result but it did not. Can anyone help me out with this problem Thanks in advance. obviously probelm is with the date. remove the date from SP and verify. Can you explain what is your requierment on date field Could you v ...Show All

• vishuonline Package Configuration with XML

  Hi, i am haveing package which is devloped in BIDS and i am executing the package from DotNet (Windows Application C#).during development my package is pointed to Server1,Database1.when we move the package to another test environment for a different server and database (Server2,Database2). we are giving the connection string details in dtsConfig file .but  Package is not takeing the new connection string instead its takeing the old connection string (design time connection) and throwing error.what could be the problem Invoking Code (C#) --------------------             btn_SaExecute.Enabled = false;            ...Show All

• dchurch24 Mix and Match Rows

  In the trading (stock market) industry there is a practice of rolling up (merging) multiple trades into a single trade in an effort to save on ticket charges. The way this is done is performing a SUM() on the quantities and calculating an average price. (Average price is the SUM(Qty * Price) / SUM(Qty). So, given : Qty     Price 20      $5 20      $10 You get: 40      $7.5           -- 20 + 20 and SUM(20 * $5, 20 * $10) / SUM(20 + 20) Here is my dilema: If given a set of trades, I need to loop through them and check every combination to determine which one matches the expected ...Show All

• belgerog Installing SQL Server 2005, Detecting Installed IIS

  When trying to install SQL 2005, the installation halts at "Detecting Installed IIS". From a previous forum discussion I tried disabling Norton Anti-Virus and Firewall, but the install still does not get past this point. Please help. Since the install seems to be hanging, the logs probably won't be of much use. Go ahead and send me the zipped up log files to samles@microsoft.com . I can take a look, but my guess is that you may need to toggle something in your anti-virus/firewall/DNS settings. This issue has appeared a few times and the solutions have been in these areas. Sorry about not having a more direct answer. Thanks, Samuel Lester (MSFT) %ProgramFiles%\Microsoft SQL Serv ...Show All