Answer Questions

• progames25 Problem with multi-valued parameters since SP1

  Hi, after the installation of SP1 I have a problem with multi-valued report parameters. The option to select all values are gone. Is there a bug within SP1 Before the installtion of SP1 multi-valued report parameters works fine, the option to select all values was added automatically within the preview in Visual Studio 2005 and in published reports on the server. The server was migrated from SQL2000 SP4 to SQL2005. So long Lemmi Hello Robert.  This is really a bummer.  I have just converted over to RS 2005 (from 2000) and implemented multi-select parameters in 15+ reports.  The select all option was a great option.  Something my end users would really use and like.  ...Show All

• Humberto10k SSIS package designer lookup component GUI error?

  Has anybody seen this issue already If you try to "enable memory restriction" from the Lookup component GUI you need to input both 32 and 64 bit size of maximum memory. However when clicking "OK" on the editor you get a message like : TITLE: Microsoft Visual Studio ------------------------------ Error at Update Execution Logs [Lookup folder path 1 [4429]]: Failed to set property "MaxMemoryUsage64" on "component "Lookup folder path 1" (4429)". ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ You can only set the p ...Show All

• lenik Initializing a Merge Subscription Without a Snapshot - doesn't operate correctly

  Hi! I do the backup from the publisher, next I restore it at the subscriber using *pure* database. next I attempt to create subscription using this db. of course, I use SubscriptionSyncType .None for SyncType propery of the subscription. But, 1. nevertheless the merge agent downloads whole snapshot! both data (bcp files) and the schema. 2. I get the *strange* error. below thelines from the log: Applying the snapshot to the Subscriber A dynamic snapshot will be applied from 'C:\DOCUME~1\...\LOCALS~1\Temp\DB$MAIN_DB1_Main_testReplFromBackup\' Preparing table '__UserSyncOptions' for merge replication Applied script '__UserSyncOptions_2.cft' {call sp_MSsetconflicttable (N'__UserSyncOptions', N'MSmerge_con ...Show All

• bobchauvin Problem Upgrading from MS SQL 7.0 to MS SQL 2000 (upgrade option disabled)

  Ladies & Gentlemen, I realize this must be an unexpected question in this day and age of MS SQL 2005, however, at my company i need to upgrade from SQL 7.0 to SQL 2000 standard on a WIN2K machine. can anyone out there tell me why the option to upgrade ("Upgrade, remove, or add components to an existing installation of SQL Server") is disabled I'm reading that i should be able to upgrade without having to install a second instance. thank you thank you, i am trying to upgrade from Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) (standard edition) but my IT admin gave me SQL 2000 personal edition. I now have the SQL 2000 Standard edition and it is working. thanks again It depends of SQL 7.0 ...Show All

• Kevin Dente Urgent: SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana MoonRiver000 wrote: You meant " ltrim(rtrim( )) " since there is no "trim" . It doesn't help.. Any ideas There is too a TRIM() function in the derived column transformation. It's under "String Functions." When using 'Data Convertion' between 'Source table' and 'Destination table' by SSIS. Some data could not be transfered to 'Int' or char(1) from Varchar(200). In fact, 98% of them should be int or char(1) or null. I tried to 'redirect row' the rest 2% to a wrong table. However, all data went to the wrong table during 'Data Convertion' and nothing went to the destination t ...Show All

• xplosiv_1 Placing a sum in a table header column

  I have been requested to add the sum of an interger field to the table header. I have the sum in the footer (which is very easy to do), but I cannot get the sum to appear in the table header. I then set-up the stored procedure to run the sum, and place it into a dummy field. I still cannot add this field to the table header. Instead of printing the data for the dummy field (the correct total), it instead prints the actual field name on the report. Is there anyway to place a sum in a table header on a SQL Server Report Let me know. Thank you, T.J. You should be able to just copy the code that you're using in the sum field in your table footer into a textbox in the table header. Jarret ...Show All

• Juan64 commenting hyperlinks in query editor window

  Is there a character or character sequence to annotate hyperlinks in your query windows so that it will conform to valid TSQL code and simply ignore the hyperlink, yet still allow the hyperlink to function in the editor For example... Create Proc dbo.Hyperlink as begin --below link is the sql server homepage for MSFT http://www.microsoft.com/sql --commenting it out disables the link in the editor end first off this is for research and writing purposes and not real world, however this could be applicable to a real world requirement... If Management Studio's editors now support hyperlinks why should'nt I be able to embed URLs (and keeping them useable when opened in the editors aka not ...Show All

• llively Binary Data on Multiple Servers

  I'm using EncryptByKey to encrypt data in my SS2005 database. Since our server is really slow to access from home to work on, I used the Database Publishing Wizard and installed the db to work on at home. Then I created the certificate and symmetric key in my home db. When I pull info using the DecryptByKey on our database at work on Windows 2003 Server, no problem, the data is decrypted. However, the same data does not decrypt at home on my Windows XP computer. I'm using TripleDes on both machines for the symmetric key (AES won't work on XP). --To create my cert and key: USE My_DB; CREATE CERTIFICATE MyCert ENCRYPTION BY PASSWORD = 'some password' WITH SUBJECT = My Data', START_DATE = '01/01/2007', EXPIRY_DATE = '01/01/2099' ...Show All

• RainmanRam variable does not exist?

  I have a variable scoped to the package named "Filecount".  When I try to reference it in a precedence constraint expression (@Filecount > 0) I get "The variable 'Filecount' was not found in the variables collection.  The variable might not exist in the current scope."   Anybody know why   Thanks. Ok I'll take it back...@VariableName is a valid syntax. I just have been copying/pasting for too long the same syntax. Rafael Salas wrote: toneho wrote: I have a variable scoped to the package named "Filecount". When I try to reference it in a precedence constraint expression (@Filecount > 0) I get "The variable 'Filecount' was not found in ...Show All

• ParkerMelvin Package doesn't run anymore on SP2

  Hi all, I've installed SP2 on my server. If I run the package on the server, the package worked there before the installation of SP2. Now with SP2 it doesn't work anymore. In VS2005 on my computer the package works before and after the installation of SP2. He gives an error with the execution of a sql-task on an oracle server: Error :Executing the query "insert into cube_content values (trim( ), trim( ), trim( ), trim( ), trim( ), sysdate) failed with the following error: "ORA-01401: inserted value too large for column". Possible failure reasons: Problems with the query, "ResultSet property not set correctly, parameters not set correctly, or connection not established correctly. Anybody an idea Thanks ...Show All

• LeoFromCanada Query to get Linked List kind of data from the Table

  hi Experts, I have a Issue table which stores the below data for many issue. some issue are duplicate to other and they are stored in a field Duplicate_of ID Duplicate_of State 77637 65702 Duplicate 65702 42217 Duplicate 42217 - Verified i wanted to write a query or some stored procedure when passed 77637 should help me get 42217 . Hint : 77637 when passed has field Duplicate_of which point to 65702 and his state will be Duplicate , 65702 will be duplicate to 42217 and state will be duplicate and 44217 is not duplicate to anything and state will be other then Duplicate i appreciate if somebody can help me think in some line to ...Show All

• ved_30 msdb recovery on sql 2005

  Hi I have a backup of msdb on sql 2005 version 9.00.2047 I need to use this backup to restore msdb on the same machine. But the version has been upgraded to 9.00.2153 All of my attempts end up with the same messages "...cannot be restored because it was created by a different version of the server..." Thanks. You are going to have to find an install of version 9.00.2047, restore the msdb database, upgrade the instance to 9.00.2153, backup the msdb database again, and then use that backup to restore to the instance that you want. There is a reason that every hotfix and service pack has an explicit warning message that you must backup system databases immediately afte ...Show All

• DevDiver Credentials in Reporting Services??

  I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service. Is it possible Any help will be appreciated!!! TIA Hi, I am facing the same problem. I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource So what should be the Connection Methods in Shared DataSource Nilesh I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my ...Show All

• Ryan Paddy Simple Workgroup (Like Access) use of SQL Express ??

  Hi all, In the past if we wanted to provide an application with simple (multi-user) database facilities, we would use an Access mdb database which we could basically xcopy deploy to the client. Share the folder across the network and apart from the limitations of mdb databases it would work !!! With all the advancements in databases ! we have moved on to SQL Express - touted as the thing to use and the replacement for MSDE and MDB databases. But hang on a minute !! It doesn't work like that ! You can't deploy Express like we used to with MDB databases - the default Express database doesn't allow multi-access and if you can't xcopy deploy the Express database. The 'user Instance' thing is useless - basically every user gets their own ...Show All

• JStemper2 =Sum(ReportItems!FinalCost.Value, "group_1") in group footer problem

  Hi, Im currently writing a report in SSRS which requires to take data in the fields, manipulate and perform functions on it then display it within its own textbox. For example the field Cost is manipulated so that a column will show the cost depreciated after 5 years. Cost Final Cost 500 250 1000 634 700 500 Footer: Totals 1384 My problem is that within each group (as the data is grouped by its type) I need to have a sum of the Final Cost data. As this is NOT a field I cannot use =Sum(Fields!FinalCost.Value, "group_1") but rather I need to use =Sum(ReportItems!FinalCost.Value, "group_1"). I know that SSR ...Show All