Answer Questions

• BullZhot aka Klaes SqlServer2K5_BOL.msi

  In July I obtained and installed the dvd's SQLServer 2005 Developer Edition CTP so I assume this is the June 2005 version and VS2005  Team Suite Beta 2. I tried downloading the above file for Sql server 2005 Books online and it fails saying I need .Net 2.0  (  seems VS2005 installed .Net 2.0 Beta ) I am also having trouble understanding some concepts ( I am relatively new at this ) Why do I even need this SQL Server 2005 dvd   ...Show All

• Scooter! Reusing package configuration file across all packages in a solution?

  I have 5 packages in a solution. For 1st package, I add a package configuration file (xml) named common.dtsConfig containing only Database Connection configurations. For the same package, I add another package configuration file names first.dtsConfig containing configurations specific to 1st package. Now for 2nd package, when I reuse from existing package configuration (common.dtsConfg) with same name, it allows me to do that. I also c ...Show All

• vortex-31 How do i watch variable values during debugging ?

  Is there a way i can see the value of the variables during debugging Yes i have a problem seing breakpoint in for example VB i a script component. I can set the breakpoint, but when i close the script windows in SSIS the coding windows closes as well. And when i run the package or open the script editor again, the breakpoint is gone Yes. Use the Watch window. Covered ...Show All

• Andy Olson - MSFT Issues with moving backups via XCopy

  When we take backups, we xcopy them from a folder (on a remote server) containing all of the backups for the databases on that server accross a network onto a central server, into a folder for that server/database. However, should one of the backups we have moved accross the network and onto the central server get deleted or moved, the XCopy does not attempt to move the copy from the remote server back onto the central server the next time we r ...Show All

• Steve R Server Application Unavailable

  Sorry I ask many questions. But I'm fully testing beta 2 and my system is really unstable. Due to a fatal error. I have to reinstall SQL Server 2005 Database Engine. I recover databases from backup. But now when I want to acces reporting services it says Server Application Unavaible. I reinstalled .net framework again and nothing happend. I reinstalled reporting services again and nothing happend. I made new databases for reporting services and ...Show All

• drrubberchub Problem in SSMS and BIDS with STDEVP function query being changed by tool

  I previously asked this question in Transact SQL forum but I think I'm dealing with a tool related problem and not with a Transact SQL problem. I am currently unable to get the stdevp function to work when I am using the SQL pane of either SSMS or BIDS for SQL 2005 standard edition. The query is as follows: SELECT stdevp(Schedule_Weight) AS Expr1 FROM Order_Start_Steps_Weights WHERE (Schedule_Weight_Type = 1) When I try to execu ...Show All

• NDaigneault Reference variables with identical names but different scopes

  Hi, I have a script task that can "see" 2 variables with identical names. The only difference is that they are scoped differently. As far as I know my script task will use the most locally scoped variable by default. Is there any way to make it use the other one -Jamie Give people a chance, you only posted a few hours ago! Saying that from all we have learnt about the “precedence” behaviour of variables and scope, I certainly don’t thin ...Show All

• j.hu@sbcglobal.net SSIS WorkFlow

  Hi Can any one provide sample for work flow in SSIS . and how to excute package conditionaly like if package1 is sucess then excute package2 else excute package3 .( more like writeing batch file in Data Stage ETL Tool ). Thanks & Regards Jegan.T Hi Jamie, Thanks for your suggestion Jegan.T Oh, and if you want to ensure that packages execute in a ce ...Show All

• Keith Henkel 3rd-party report editors

  Does anyone know of any products out there that allow end users to control the layout and fields of a report without having to install any special software on their machine SQL 2005 has a web-based Report Builder which may do the trick for you. SQL 2000 + Panorama Enterprise Report Builder is another option. You could also try ActiveReports by Data Dynamics - http://www.datadynamics.com/P ...Show All

• G. Arends Is it possible to make Calculation-values persistent in a Cube !?

  Hello Is it possible to make Calculation-values persistent in a Cube ! I made an very intensive calculation based on historic data.  This resolves rather in a complex MDX-statement and becomes slow at retrieving time  I was wondering.... Is there a way to calculate the value at processing time (by MDX-expression) and store it in the cube I know there is a field 'MeasureExpression' but this field is not full MDX suitable ! ...Show All

• mj585 Error 29503 - SQL Server 2005 DB Engine install Fails

  Hi, I've just tried to install SQL Server 2005 Standard and I'm getting an error that I can't find any information on.  In the log, I find Error 29503.  A message after it indicates that it couldn't start the server.  In the setup, I'm getting the error when it is trying to start SQL Server and it can't.  I've tried to go to the services window to manually start the engine, but immediately after it starts, it shutsdown ...Show All

• Russk2t Connection to Analysis services from VB - very slow

  Dear All, I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine. I ran dependency walker and found that the dll WS2_32.dll (winsock dll) ...Show All

• Steve Warwick And/or filter field not enabled in the group filter tab

  Howdy, I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" ...Show All

• Gusti Satria SP Error Handling and Try/Catch

  I'm looking for a discussion of the pros and cons of using TRY/CATCH as an error handler in a standard fashion with Stored Procedures.  I've been using SQL Server for some time, and am accustomed to an approach of error handling in SPs that returns control from an SP via a common exit routine.  Has anyone defined an approach they would consider sharing   I realize that the reasons for standardizing on an approach incl ...Show All

• Trevin Chow Error in Report "Memory Consumption" after upgrading with SQL2005 CTP SP1

  There's a little bug in the CTP SP1 release of SQL2005. Opened MS SQL Server Management Studio. Connected to a SQL2005 64bit server with 6GB memory. Choose Summary, Report, Memory Consumption and in the graph for Buffer Pages Distribution (#Pages) there's no graph, but the following error " Unable to retrieve data for this section of the report. Following error occurred. Msg 8114, Level 16, State 1 Error converting data type bigint to int. ...Show All