Answer Questions

• dba72 suppress the display of a txt box when null

  I have a text box in a list, which i only want to display if it is not null. How can i do this in reporting services. thx la You must put in the value the expression: = IIF(CSTR(Fields!EvaluatedField)="", "", "The Title") I hope it helps you Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. ...Show All

• MiggyE (SQL Server 2005) Instead of Delete Trigger

  Hi, I simply need a trigger to delete some datasets from a view but have some trouble writing an adequate trigger. Here is my attempt: Use myDB ; Go CREATE TRIGGER IO_Trig_Del_myView ON myView INSTEAD OF Delete AS BEGIN SET NOCOUNT ON -- Check for dataset, if present delete. IF (EXISTS ( SELECT Z . [myPk] FROM myTable t , deleted WHERE t . [myPk] = deleted . [myPk] )) Delete From myTable Where myTab ...Show All

• Jesus Ponce Problems instancing Reporting Services

  I set up Reporting Services as a Web Reference and when I try to instance it, I get a "type expected" error message.  Let's say the web reference is named SQLRS.  When I do a DIM rs as NEW SQLRS, a blue squiggly appears under SQLRS and it displays the type expected error message. What am I missing   Anyone know or have a link to an example I could look at   Thanks for any help. Additional in ...Show All

• KathrynE Query Results Truncated in SSMS

       I'm running a query in SSMS that returns a large result set.  The query runs fine without error.  However, in the results pane the query results are truncated.  I've tried adjusting every option I can find.       I think I'm running into a limit on the number of characters displayed in a column in the results pane.  I've already bumped up the amount to the max (8192) setting i ...Show All

• ramram49 Unhandled Exception in Management Studio

  At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when ...Show All

• Neil Waldie Problem adding Annotations to KPIs

  I'm trying to add an annotation to a Kpi object in AMO. I'm starting with just the simplest thing: kpi.Annotations.Add("AnnoName", "AnnoValue"); The KPI validates, and cube.Update doesn't report any errors. But when I try to read back the KPI later, the annotations collection is empty. I profiled the XML/A sent as part of the Update, and the KPI definition included the annotation there. But the annotation never seems to be sa ...Show All

• JimReid The subscription to publication is Invalid

  Hi, I have two SQL 2000 Server running on Windows 2003 Standard Edtion. I am using merge option to replicate database as Transactional option is excluding some tables. Both server are not in Active Directory and I am trying to replicate over the internet. I got following error message while using Merge option: Error Message: The subscription to publication 'XXX' is invalid. Error details: The subscription to publication 'XXX' is i ...Show All

• Kusok Searching for a technical documentation on SQL Server Express

  Hello, I seek a documentation on SQL Server Express to find some technical information such as Limits of the Database (Limits per Database, Maximum Number of Joined Tables, Maximum Logical Operators in WHERE clause, ...), Programming Features (Transactions, Transaction Isolation Levels, ...), Distributed Transactions , Performance of the Database. Thank you a lot for your help. Osman. If you have not already ...Show All

• Darkside deleting sql server 2005 deployed packages?

  Hi there This is probably a dead easy question. I have deployed 3 SSIS packages to sql server, but now i cannot find any option anywhere to delete them How do i delete SSIS packages from the SQL Server instance they were deployed to Thanx Oh, and, you're welcome for the post too Sean. :) Sean, Kirk has posted on this: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx It tells you all you need to know. -Jam ...Show All

• Rim van Wersch Previous(Expression, AggFunction, PreviousScope, AggScope) ??

  Hi all, We are trying to produce a report using a matrix that would show percentages to the column groups in the cells (ratio to parent along the columns): Colgroup = 1 Colgroup = 2 … Col1 Col2 Col3 Col4 … Rowgroup= 1 Row1 3 / (3+9) 9 / (3+9) 1 / (1+6) 6 ...Show All

• Patrick Carnahan - MSFT Custom Data Flow Transformation loosing CustomProperties

  I created a custom transform that has a custom interface and is a wizard that uses a web service. It creates custom properties and output columns on the fly. I set the dialog result to Ok and close at the end of the steps. The transform then has the custom fields and output columns I created in the wizard. I've verified this by right clicking on the transform and going to the advanced editor. If I then immediately run the package, the custom fi ...Show All

• cluelis ~* Total Pages mismatch *~

  Hi, The number of pages in the report viewer and the number of pages in print preview are different. how could the prob. be resolved... Thanks in advance. Cheers Chakri. Hi, thanks for ur reply. but still, the report viewer has 8 pages, but when i view in print preview the total pages are 11. if the user need first 5 pages tobe printed as per the view in report viewer, he may not get the desired records, as the ...Show All

• Henrik Bach The Poor VB6 guy - database help

  I have a production applicaton today ran by 120 businesses across the nation. Today our application is a VB6 front end with an Access 2000 backend. The problem. Access 2000 is suffering from corruption every once in a while. our users are running 1-8 computer systems at a time on the access database. We want to move to something that will allow our users to run 10 computers simultaneously if needed. Question.. What do we do for a ...Show All

• Shaik Pakeer Trigger question

  I would like to know how many records there are in the INSERTED & DELETED tables at once when a trigger fires. I'm looking at a trigger that checks for COUNT(*) in both tables (INSERTED & DELETED) and will perform a different T-SQL statements base on COUNT(*) being 1 or greater than 1. I always thought that triggers fired for every record in a INSERT, UPDATE, DELETE transaction. If so, there should not be more than one record in neith ...Show All

• Ido_ba Question Regarding Job Schedules

  Hi My instance of SQL Server 2005 is installed on a Win Server 2003 box. I am trying to schedule an SSIS job. I have created a proxy using my NTLogin as Credential. When I run the job, it returns with the following error: Message [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XXXXXXXX', error code 0x54b. [SQLSTATE 42000] (ConnIsLoginSysAdmin)   where XXXXXXXX is my Domain\NTLogin I access ...Show All