Answer Questions

• SpunkyMan Error while executing insert statement on DB2 using OLEDB Provider

  Hi, I am using simple data flow task to move data from SQL Server to DB2 using OLEDB provider on both ends. I am using OLE DB Command task to execute inserts on DB2. Following is my statement. Insert into MMTSTLIB.INTIIF (IIFDTA) values ( ) In column mapping, correct column is assigned to parameter and column data type is unicode. Data viewers attached show correct data. However when executed, it gives following error. [ OLE DB Command [138]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "Null values are not allowed in column or variable IIFDTA. SQLSTATE: 23502, SQLCODE: -407". ...Show All

• zlatkoc SP2 CTP November 2006 installation failed

  I have Windows XP Home Edition SP2 English Version. I installed MS SQL Server 2005 Developer Edition and after reboot I Installed SP 1. Now I try to install SP2 CTP November 2006. In Installation Progress dialog when Setup Support Files are in progress I get an error message - Unexpected Error Occured Unable to create backup folder and show me second message box with error Hotfix.exe has encountered a problem and needs to close. Regards Maciek I have the same situation. My SQL install is on a VPC - I hope that's not the issue. Please let me know if you find the solution. Thanks Hi I have just tried to install SP2 from the MSDN June release and get a very similar problem. I am ru ...Show All

• StarsFire 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. The data involved is huge (millions of rows) but regardless the sql statements copied from the proc and written in query window returns result in 5 ...Show All

• twospoons Hierarchical Cumulative Sum

  I have a table consisting of 3 columns: Parent varchar(50), Child varchar(50), Pop int. The table is setup as follows: Parent Child Pop ---------------------------------- Europe France 0 France Paris 1 New York New York City 10 North America United States 0 North America Canada 0 United States New York 0 United States Washington 0 Washington Redmond 200 Washington Seattle 100 World Europe 0 World North America 0 This is just some sample data modified a tiny bit from an example of a hierachical print out sample that is a stored procedure that allows me to pass any place and see all of that place's children/grandchildren. I need to figure out how to write a query to show me cumulative sums (ROLLUP ) of the whole tree. So the output should ...Show All

• kuria Upgraded XP and my MSSQL 2005 no longer Login ID / Can't start server

  Hi I upgraded my XP and when attempting to restart my web site using MSSQL 2005 my login credentials were not recognised. Now, the Databse does not want to start and I can not login to check error logs. I have enclosed the error message that I am experiencing. Can anybody please help. Regards =================================== Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again. =================================== An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared ...Show All

• i.eat.idiots.06 Move SQL Server and Analysis Service from C: to D:

  Hi all, We need to move the sql server and analysis Service and report server from C: to D:. Can some one outline the steps how should precede without losing any data I am new at SQL Database, a detailed outline will be appreciated. Thanks, Yankua Easiest, could be to create backup of all of your databases and re-install all products on another drive. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• PerPixel Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All

• GlennZarb Problems with performance when programmatically printing large amounts of pages

  We are using VB.NET 2005 to develop a WinForms application that uses SQL Server 2005 Reporting Services to produce reports. Originally we tried  using code found on Bryan's WebLog,  http://blogs.msdn.com/bryanke/articles/71491.aspx , but found that for reports of 300 pages it was taking about 2 minutes to render each page. When using RenderStream to render idividual pages, reports of about 20 pages printed without a problem, but for reports of 300 pages we recieved the follwoing error: "The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database." Is there some cache or something that we should be using Any ideas appreciated. -- Leah The ...Show All

• MU786 Logging Query Messages From ExecuteSQL Task

  The ExecuteSQL task makes it easy to capture the resultset of a query or stored proc in a variable. But what about the messages that would normally appear in the Messages tab when running queries in Management Studio or Query Analyzer There must be a way to display and log rowcounts and other messages that a query normally produces.   Various package/task logging configrations haven't helped. I've read discussions about logging rowcounts in data flow tasks, but what about capturing messages in ExecuteSQL and other control flow tasks that run T-SQL   I only have enough time to dabble in this technology so I may be missing something obvious or approaching this incorrectly. Any sug ...Show All

• R Raghu Cross assembly or cross domain calls not supported

  If I compile a simple .NET DLL with the following function and register it as an assembly in Analysis Services: public static int MyFunction(object o) { return 99; } When I run the following query I get an error which reads " Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure failed with the following error: Cross assembly or cross domain calls not supported!. Execution of the managed stored procedure CSng failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException. " with member test as MyAssembly.MyFunction(CSng("2.5555")) select test on 0 from ...Show All

• waheyluggage System.OutOfMemoryExecution. Why?

  When I do "preview" , after I while I have this error: System.OutOfMemoryExecution Anybody can help me Thanks Can you give a bit more details How much available memory does the machine have when you try to preview How much data is in the report How many rows go in and how many rows go out Does the report render if you publish to the server and view there Do you receive a callstack Thanks, Donovan. ...Show All

• Amorous Storing calculated measures into existing measure groups

  Apologies if this is a really obvious question, but how do I put calculated measures into existing measure groups I have a calculated member Z that's defined as Measures.X / Measures.Y. I want to put Z in the same measure group as X, but I don't see an option to do so on the "Calculations" tab. Thanks! Not sure what would it mean to "put" calculated measure into measure group. You can specify AssociatedMeasureGroup for calculated measure, but it has no meaning for semantics or functionality, perhaps some effect on UI - i.e. in some client tools such calculated measures will be grouped together with measures from their measure group. Cool. Looks like you can use the Display Fold ...Show All

• Chips_in Intermittant Connection Errors

  I have a Merge-Pull subscription setup between two SQL 2005 databases. While watching the status messages display for the subscription, I am constantly seeing the following message being displayed: "The merge process could not connect to the Publisher '{server}:{database}'. Check to ensure that the server is running." It will display for anywhere between 15 seconds to a few minutes, then it will display the standard "Waiting 60 seconds..." message which is what I'm used to seeing when all is working well. There doesn't seem to be any network issues that I can identify. I ran a quick script to run ping continuously against the publisher server and verified that the server was constantly "pingable", ...Show All

• orent Stored Procedure Validation

  Hi All, I am working on a project in which an Integration Services package should be executed 24 times a day. Everytime it is executed, it validates for tables, views etc. I am able to validate for tables, views, partition functions etc. But when I am trying to write a code as If not exists (select name from sys.objects where type='U' and name='SP') Create Procedure SP Begin End I am trying to put the above as a task in Integration Services. When the task is executed, it is throw an error 'Create Procedure should be the first line' etc. How to solve the above problem Can any help me immediately Thanks Moving to Integration Services forum. Edward. -- This posting is provi ...Show All

• lizital service broker and database mirroring

  I read the blog about service broker and database mirroring. Have you actually gotten this to work I have a database that is mirrored. A third party vendor's software is using query notification which in turn uses service broker for dirty cache notification. Based on your blog I created a route specifying a mirror address. CREATE ROUTE ServiceBrokerMirrorRoute AUTHORIZATION dbo WITH SERVICE_NAME = 'http://schemas.microsoft.com/SQL/Notifications/QueryNotificationService', BROKER_INSTANCE = '70D4070D-C739-43B3-9167-7156209F87BA', ADDRESS = 'TCP://10.128.183.210:5100', MIRROR_ADDRESS = 'TCP://10.128.183.211:5100' And then I tried to ALTER DATABASE SET ENABLE_BROKER but it fails with a Server: Msg 9778, Level 16, State 1, ...Show All