Answer Questions

• The Hamster Job activity = slow, non job = fast

  I have created an integration services package with a script-source reading data from Active directory. Pretty much data is read and written into a sql2005 database. I have notised that when I run the package via right-clicking the package (Under stored packages\MSDB) and selecting "Run Package" it takes about 45 minutes for it to complete successfully. The same goes if I run the package from inside Visual Studio. However, when I create a job and put this package as one of it's tasks the task takes about 1h 40min. This is more then double the time! In neither case the server is occupied with soething else. And I have tried it several times so it wasn't just an "accident". Any idea of what this depends on regard ...Show All

• ArtT Automatically print multiple copies of the same report with different label on letter size paper

  Hi, I am new to reporting services and I'm really stuck on a design problem. Can someone please help me I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code Any help would be greatly appreciated! More specifically, the report will indicate that it has multiple pages (hence allo ...Show All

• Leonid Niraev Dimensions within Excel Pivot Table

  Hi I have a cube that has dimensions such as year, company, customer, statustext, employee etc. In the Browse in Analysis Manager - all the dimensions look fine. When I access the same cube from Excel after dragging and dropping the dimensions during analysis the dimensions in the Page section are not what is show when dragged to the row section. For example - i have a display Customer as rows, years as columns. I drag the statustext next to customer and shows customer. The filter in the page section for statustext is correct. I have tried moving the dimension back to the Field List and re-adding, refreshing from the cube makes no difference. The only solution I have been able to come up with is rebuild the Pivot table - not wh ...Show All

• Flame Thrower manipulating ntext in stored procedures

  Hi, I have been trying to write a SP where, in the result set is brought back, two ntext columns are combined with a text string, However I get an error when I click on apply; "Error 403: Invalid operator for data type. Operator equals add, type equals ntext" I can only assume that this means you can't add (or even manipulate) ntext columns in a SP. Short of changing the sp to bring back 3 columns and to do the manipulation in my c# code I can't think of a way round this. Anyone with any ideas thanks in advance rich SP code ( I have highlighted the problem area): CREATE PROCEDURE [dbo].[usp_RCTReportQuery] @PersonType varchar(255), @Status varchar(255), @Oustanding varchar(255) AS DECLARE ...Show All

• Paul-M Nofications assemblies not found with .net 2.0

  Hi guys, I was trying to develop a non hosted event provider and decided to use NS event object api to submit events to NS. My development system has VS 2005 and my plan is to connect to a NS instance running on a machine on the local network. But it is weird that I could not find "Microsoft.SqlServer.NotificationServices.dll" in my dev system. Does it mean to develop NS applications we need to have VS 2005 and Sql Server 2005 on same box. Also note that I have sql server express edition on my development machine and I am aware that express editions doesn't support notification services. Thanks, Shamir Hi Ahmed - You need to install the SQL Server 2005 Notification Servic ...Show All

• rad9k Workgroup -> domain impersonation

  In the following scenario, I am getting the message 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'. I am running a Windows Server 2003 with development environment and Sql Server Management Studio in a workgroup on a virtual PC. My SQL Server 2000 is running on a domain server. On the virtual Pc I have setup my user login and password to be the same as my domain login and password. Why is the Management Studio not using impersonation and allowing me to connect to the SQL server on the domain There are a couple of reasons this why this typically happens: Because SQL Server is configured to run in Windows Security mode only, and the security mode ...Show All

• SOAC Copying tables from access to sql server express

  I am trying to export a databse from access into sql server express. The access database is on a network and the sql server express is on my local machine. Could someone give me setp by step instructions please as to how to export the data from the tables into my sql server express. Thank you very much for your time Access includes a wizard called the Upsize Wizard that can help you do this. Depending on which version of Access you have, it may be on different menus, but last time I saw it it was under Tools | Database Utilities. You may have to install the Upsize Wizard if you don't already have the Advanced Wizards installed. Search the Access help file for information about using this tool. Mike ...Show All

• MagedSalah Configure a Child Package to use the configuration file of a Parent Package?

  Hi guys, Here's the deal. I have a child package, (say, pack01.dtsx), which uses a dtsconfig file for its connection string, which can be called from other packages, but which also can be called by itself. However I also have another package (say, pack02.dtsx) which uses the same dtsconfig file for its connection string. It calls on pack01.dtsx. When I use DTEXECUI and run pack01.dtsx, specifying the proper .dtsconfig file, it goes well. But when I try and run pack02.dtsx, an error occurs saying pack01.dtsx connection cannot be established. How do I pass the connectionstring being used by pack02 to pack01, without having to remove the configuration file setting of pack01 Can a Parent Package configuration and a configuration file try and m ...Show All

• irl-barse "Schemas" in same database vs multple Sql Instances

  We have a DataWarehouse project. We are considering using table names (in the same database) like this: Acct.Payroll ... Claims.Payroll ..... Shipping.Payroll ... where the "Schema" differentiates the "Payroll" tables. The tables have similar functions but are quite different internally. We expect these table to grow significantly over time. Question: From a performance\ maximum database capacities, admin perspective what the pros/cons of each approach: 1. Schema approach 2. Multiple instances of sql (up to 16) on a single server 3.Seperate databases on the same server TIA, barkingdog From a raw performance perspective on a singl ...Show All

• R. John An error occured during printing (0x80004005)

  Hi, looking for help! I've been struggling with this error for some time. I can view the reports in the browser fine, but when I try to print using the reporting services activeX conytrol I get the above error. I have installed SQL 2005 sp1 on a server running 2000 sp4. I also get the following in the server event log; Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 22/06/2006 Time: 14:53:28 User: N/A Computer: --------- Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/22/2006 2:53:28 PM Event time (UTC): 6/22/2006 1:53:28 PM Event ID: 56127d43e4734e48ac53a3d7ff86c960 Event sequence: 209 Event occurrence: 6 Event detail code: 0 ...Show All

• Aleniko29139 StrToMember performance issue

  I am building a parameterised report against a cube. After starting with an MDX statement that performed perfectly well and parameterising it the performance went downhill fast. I was able to replicate similar symptons against the Adventure Works cube. In this example I am getting sales values at 2 different dates and breaking them down by Sales Territory and Customer Geography dimensons. In fact they could be any dimensions, but I do need to add a crossjoin in order for the problem to show itself. WITH MEMBER Measures.FirstDateAmount as --([Date].[Date].&[32],[Measures].[Internet Sales Amount]) ( StrToMember ('[Date].[Date].&[32]'),[Measures].[Internet Sales Amount]) MEMBER Measures.SecondDateAmount as ([Dat ...Show All

• Healthcare Network Admin Jerry Transaction Management

  Hi I am a newbie to SQL Server. I had a question about stored procedures. If there is a Long Running SP that has several Insert, Update and Delete statements. These are not wrapped in a BEGIN TRANSACTION and END TRANSACTION block. If the SP executes some of these commands and fails in between, for whatever reason, would the already done changes persist or would they be rolled back. Thanks and regards Vikas Manghani Any completed INSERTS, UPDATES, or DELETES will stay. If it should be an 'ALL or NONE' operation, then use a TRANSACTION. In addition to enclosing the insert/update/delete statements in an explicit transaction you will need to do one of the following: a) Check the ...Show All

• ZDB SQL 2005 vs SQL 2000: Where clause Short-Circuiting?

  Hello all, this is my first post, and I think I've found something interesting between sql 2005 and 2000. Thanks in advance for any help you can provide. I am attempting to migrate a system from SQL 2000(v 8.00.2039 - Enterprise Edition) to SQL 2005 (v9.0.2047 - Standard Edition ), and a few of my most complex queries are generating errors. I was able to isolate the problem to a fairly simple query that works in SQL 2000, but generates an error in SQL 2005. I believe that the problem has something to do with how short-circuiting is handled in the WHERE clause. I'm not sure if short-circuiting is really going on when these statements are parsed, but it seems to describe the situation well. To replicate the problem, first create the ...Show All

• Nikola Atanasov Count Item Number

  Hello; Which is the easy way to do this: I have 2 tables:Work_Order_Header and Work_Order_Detail. I need to generate the Item Number from 1 to "qty of items" when I make the JOIN on WorkOrderNumber. Example: WorkOrderNumber WorkOrderItem WorkOrderAmt 122 1 10.00 122 2 15.25 122 3 24.37 How I generate the WorkOrderItem using a select with a JOIN on the 2 tables Thank you Jens, but I am working with SQL 2000 I forgot to mentioned. Did that solve your problem A sample you be something like: SELECT ( SELECT COUNT (*) FROM [Order details] OD2 W ...Show All

• robvdberg RECEIVING from QUEUE by ConversationHandle

  Is it possible to receive from a queue by a conversation handle In the documentation there is an example that show you how to do it. Yet, if you "read" the whole document it says that the conversation handle can not be an expression. The WHERE clause of the RECEIVE statement may only contain search conditions that use conversation_handle or conversation_group_id . The search condition may not contain any of the other columns in the queue. The conversation_handle or conversation_group_id may not be an expression. Here is what I'm trying to do: ; RECEIVE TOP ( 1 ) @MsgBody = CAST ( message_body as XML ) FROM ProcessingLetters WHERE conversation_handle = @Conversation_Handle It doesn't seem to mat ...Show All