Answer Questions

• NURBY Nerd I concur

  For your consideration and comments: I want to consider changing the way our transaction logs grow and what the initial growth defaults are to see if I can improve processing performance for one particular process (and perhaps others as well). I want to get away from allocating new space by percentage of current space, because as the space gets significantly larger, the 20% naturally represents lots of megabytes, resulting in some very large numbers after this update-intensive process run. I don't know if it is better to have a fixed amount of growth versus a percentage amount, but I'm guessing that as the growth amount gets progressively larger, that the time it takes to get the larger amounts of space becomes a significant drag compare ...Show All

• DLdfrd Regarding Installation of SQL Reporting Service

  Dear Friends,            This is narendran. I want to install the SQL Reporting Service. I am facing some problem. Here Microsoft SQL Server 2000 Enterprice edition installed one server. I am trying to installed the Reporting Service another one system. During the Installation I am facing the following errors. During the Installation: Installer ask some options... that are SQL Server Instance name:...........                 that in combo box First problem:- Combo box is empty, Here I am gave the database server system name assume "kersql" Name :................. text box.... what am i suppose to do here ...Show All

• ReneeC Cannot view browser or load metadata in KPI tab

  Why is it that after generating the cube with all the connections to the database setup ( in data source etc) i cannot browse the cube and has the following error message:Either the user, xxxx, does not have access to the xxxx database, or the database does not exist. (Microsoft SQL Server 2005 Analysis Services) I have created an sql server auth. account in the database and use it in AS. Thanks. Regards Alu Sorry I did not deploy. :) Thanks. ...Show All

• DevelopperX Using Triggers to track Changes in a single Audit table

  Hi, I am looking to track any changes made to any table within a db into a single audit table which will hold as fields: the table that has been updated/inserted, the field that was changed, its primary key, the old value and the new value specific to that field, and the date it was updated/inserted. From what I have read, it does not look like this is possible with a trigger on table as it is not row specific and that I might have to control this from the business layer (vb.net). I am correct in this assumption, or is there a way of tracking specific data changes through triggers. thanks Welly Thanks for the fast response. Will work my way through it and at first glance it looks like it migh ...Show All

• Seppe001 ExtendedProperties Performance

  Has anyone found a way to speed up the retrival of the "ExtendedProperties" on a column via SMO yet I had a search around but couldn't spot anything. I have an applicaiton that currently cyles through 180+ tables (with the number growing all the time) and the "ExtendedProperties" access is abosultly killing it ... taking it from seconds to minutes. If anyone could provide any information (even if it's a "no it's not possible to speed up") or an alternative retrival method I'd greatly appreciate it. I'm retriving the ExtendedProperties from Columns, not Tables :) I've tried including the SetDefualtInitFields(typeof(Column), "ExtendedProperties") but it doesn't have much effect. The people in this thread are ha ...Show All

• raveesh SQL Server CE 3 Constraint Problem

  SQL CE 3.0 I am trying to add constraints using SQL statements but get an error saying that the constraint would cause a cyclical reference. The same statements work with SSCE 2.0 Eg CREATE TABLE A(pkA integer NOT NULL CONSTRAINT pkAx PRIMARY KEY); CREATE TABLE B(pkB integer NOT NULL CONSTRAINT pkBx PRIMARY KEY, pkA integer NOT NULL, CONSTRAINT fkBA FOREIGN KEY (pkA) REFERENCES A(pkA) ON DELETE CASCADE ON UPDATE CASCADE); CREATE TABLE C(pkA integer NOT NULL, pkB integer NOT NULL, CONSTRAINT fkCA FOREIGN KEY (pkA) REFERENCES A(pkA) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fkCB FOREIGN KEY (pkB) REFERENCES B(pkB) ON DELETE CASCADE ON UPDATE CASCADE); I dont see that the foreign keys should cause a cyclical reference problem. I have ...Show All

• mistry_bhavin http://localhost/reportserver returning CS0016: Could not write to output file

  Hi, This is on a brandnew Win2003 server install with SQL Server 2005, RS 2005 and VS.NET 2005.  I'm not able to log to the reportserver site to configure/publish reports.  I'm logged in the system as administrator. From IE6 I enter http://localhost/reportserver  or http://localhost/reports and all I get is: Server Error in '/ReportServer' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\report ...Show All

• MarcoB Need SQL Support

  Dear friends I am a new developer. I need some SQL Language examples to write some quaries. Ex. how you collect last record that relevent for the last record updated for a relevent employee in a record table which includes RecordNo and EmployeeNo, salses Thanks Any help is greatly apprciated Amila Hi, e.g. SELECT TOP 1 RecordNo, EmployeeNo, salses From SomeTable WHERE EmployeeNo = 'SomeValue' ORDER BY TheColumnWheretheSalesDateisStored DESC HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Greg_Dodd Making my containers visible design time

  Hi all, I have run into a problem! Im developing a SSIS package programmatically using C#. But when i create and add a container (foreachloop and sequence) the container is not becommming visible in design time in my intergration services designer (when i open the .dtsx package afterwards). Does anyone have a solution to this problem It is only a problem with containers i create myself (it is working when im adding e.g. dataflow tasks to existing containers). Sincerely Bryan I have not observed this when building packages programmatically.  Here's a basic C# package generator which adds in a single sequence before saving to disk.  Does this sequence container not appear when your run the generator using Syste ...Show All

• austriana how to invoke/call Drillthrough Action

  Hi, experts: In AS 2005, there is this new type of action, Drillthrough. Is it possible to invoke/call it in MDX to get the results of data defined by the drillthrough action I'd like to use it in RS reports, is there a way to get the results from Drillthrough action maybe via a custom assembly There got to be a way, since it is available for pivital table in SQL BI Dev Studio's Browser. Any idea, sample thanks William Thanks for the reply. However, I'm talking about the Drillthrough Action as created from Drillthrough Action Form Editor, not the Drillthrough statement. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/225fd818-b5ea-494f-b67b-66e09798274a.htm If I can call the predefined ...Show All

• Vantoko Parameter boxes

  hey there Is there a way to reduce the parameter box size. I am using a date/time picker so want that to be the prominent part for the user at the moment it shows like this StartDate (inputbox) date/time picker if that inputbox could either be greyed out or smaller cheers jewel oh ok thanks You cannot make changes/customize the standard report toolbar. ...Show All

• evilc Create element names from data in "FOR XML PATH" query?

  Hi, all. I am writing a stored procedure to create an XML-formatted export from a relational database. I am succeeding for the most part with "FOR XML PATH" queries, thanks to help from these forums, but I've hit a new issue. I have a table we'll call "facet", and here is a subset of the table's columns: - facet_id (nvarchar(10)) - facet_type (nvarchar(3)) - facet_value (nvarchar(255)) Part of the XML schema requires that I list these facets, and the element ID is the facet ID. I need to create this: <facet_id>facet_value</facet_id> <facet_id>facet_value</facet_id> ...with, of course, both "facet_id" and "facet_value" populated from the database columns ...Show All

• Ted Carron Error message running a SSIS package in a Job

  Hello, I'm having problems when I try to run a package from a job in SQL Server Agent. I have the same package in a server and it works fine,but when I try to install it in a different server I keep getting this error: Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 01:19:10 p.m. Progress: 2007-01-30 13:19:10.40 Source: Delete scripts Execute Process Task Operation Complete: 0% complete End Progress Error: 2007-01-30 13:19:10.57 Code: 0xC0029151 Source: Delete scripts Execute Process Task Description: In Executing "C:\Project_SSIS\Delete_Items.bat" "" at "", The process exit code was "1&quo ...Show All

• siavoshkc Printer control

  Is there a way to specify the tray to print a page from I am working on an invoice that needs the first page printed on special stock and any additional pages printed on normal paper (done now using printer codes). If it were a single invoice this could be handled at print time, but we print thousands of invoices (of varying page counts) at once. there is no way to set this from the printer itself, the only thing i could suggest as an answer for you is to change the default printer to set output to the tray you need. ...Show All

• Prasant Swain IS service won't start after installing SP1

  I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services. Before the SP was applied the service was running fine. I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message: "The service did not respond to the start or control request in a timely fashion" This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated) Please help! ...Show All