Answer Questions

• mike22 how to conditionally get the data

  Hi, In Reporting Service, how to conditionally get the data Let's say, I don't want the line when the Status field is "inactive" and Eff_Date<"1/1/2006" I conditionally hided the Visibility of this line. But when i tried to get the subtotal, this line's Quantity info still was included into the subtotal. I tried to use the Filter box of the dataset to do it, but don't know how. Can anybody please help me out ...Show All

• MpRoC Detaching a Database using SQL-SMO

  Hi, Please let me know how I go about detaching a database in SQL 2005 usng SQL-DMO. I think even before detaching a database we have to clear the connections. If the solution is provided it will be of great help as it is very critical. Regards Kris Once inititated you can use the: SomeServer = new Server(); --Has to be modified here SomeServer.DetachDatabase( "MyDatabaseName" , false ...Show All

• Vetric TableCollection does not contain any table?

  Hi All, I have the following C# code to get the table scripts, and it does not work.  I debugged the code and learned that it does not find any table in the smoDatabase.Tables collection, so the foreach() loop exits immediately. Can someone shed a light Thanks in advance public Sample() {       Server smoServer = new Server('MYSQLSERVER');       Database smoDatabase = n ...Show All

• pc_83 Normalisation issue

  UserInfo | m Staff_User w | Staff_AppDb>------Staff------------------------<Staff_Server W W | | AppDb --------------< AppDb_Server >----- ----Server | | | | M ...Show All

• eddieg Drop a Role in Report Sever

  I create a new Role "TestRole"under Security/ Roles in the Report Server. I i want to drop this Role, i get the Error that the Role does not exist But the Role exist !! Anyone can help For UI operations, please post to SQL Server Tools General . Thanks Laurentiu ...Show All

• Andy Simonds Maximum SQL Query lenght

  Hi all! Does anybody know what is subject Thanks! This is batch size from ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm ...Show All

• James M - new user Using sql:relationship to populate key columns ...

  Hi ... I would like to using the sql:relationship annotion to populate key column in a table with the key data in the xml. In the xml the key data is in a different element that the other data. Below is the xml and schema and the error I get ... Is there a sql tool that will generate the schema file given the xml data and the target table I am using the bulk load to do this. Thanks, Chris \\\\\\\\\\\\\\\\\\\\\\\ ...Show All

• Bob Drury Are there no "Computed" column types? For storing expressions (results of other fields)

  I just read something interesting here: http://www.informit.com/library/content.asp b=STY_Sql_Server_7&seqNum=101 A column type that helds an expression, and in queries returns the results. That sounds excelent in my database, to save some code in my client applications. E.g adding price totals, and taxes of an order. I can't find any info about this in later versions of SQL server. Is this not possible anymore ...Show All

• kainjow Job generates login error

  I have a package which will run in Management Studio.  The package is saved in MSDB.  When I try to set up a job, the step errors out with what appears to be a login error.  I am specifying windows authentication in the job and also used that when creating the package. the package was recreated - I changed the encription option to 'Rely on server . . .' and changed the source path from X:\Directory\FileName to \\HostServerN ...Show All

• RGrizzzz Trying to move a package to a new server

  Got a multi package project that is working well on one machine, Now I want to move it to another (both running the June CTP) I copied all the files but when I open it I get: Error 8 Error loading NPRImport.dtsx: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic er ...Show All

• Carlos Mar&amp;#237;n Fuzzy Lookup componant eating all available virtual memory

  Hey, I have a large set of data that I need to match against another large set of data.  The reference table has 9.8mill rows and my input has 14.6mill rows.  I started with a new project.  I added my connection, then a task to clear the result table, then my data flow, then my OLE source, then my Fuzzy Lookup task, then my SQL Server Destination.  I set the connection of my OLE source and set the query to pull the dat ...Show All

• AndrewvdMerwe Problem installing some components SQL 2005

  Hi, I'm having trouble installing SQL2005 completely. I get a message: " A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component." It concerns "Integration services", "Notification services" and "Workstation Components, Books Online and Development Tools" What should I do Regards, Ronald Here is the ...Show All

• Cowski Removing a paramater gives an error

  Removing a parameter on a Reporting services report based on a 2005 AS cube results in an error: [rsParameterReference] The Value expression for the query parameter ‘KalenderHierarchieJaarMaand’ refers to a non-existing report parameter ‘KalenderHierarchieJaarMaand’. On the dataset, the parameter still exists. The error still occors after removing the parameter overhere too. Steps to reproduce: Build a raport based on a ...Show All

• Yeti32 Bug or Feature?

    When upgrading a database from MSDE to Visual Studio 2005 Express, I've noticed that the system tables in the MSDB database don't get upgraded.  For example, the SYSSCHEDULES table doesn't get added.  Is this by design or a bug -Doug Given that there is no SQL Agent support in Express this may well be by design Hi Doug, This has been addressed in SP1, which you can get from http ...Show All

• remy_tache SQL Server engine vs. Analysis Services: are they different engines?

  We currently run monthly computations using a SQL Server database and SELECT, and store the results in SQL Server. Before publishing the results, they are validated by a 3rd party, who recomputes the values based on the raw input data, using a program, and compares the results. We are considering bringing the validation step in-house. The requirement is that we recompute the validation numbers using a "different way", and we are ...Show All