Answer Questions

• Z.z. Databound image in report header

  After finding out that SSRS doesn't directly support databound items in the header or footer, I found the workaround from Microsoft yesterday at http://msdn2.microsoft.com/en-us/library/ms159677.aspx . The problem is that their solution only works for the first page of the report, so it's basically useless! Because this is an image, it also means the workaround of using a parameter doesn't work, either. Does anybody have any advice Is there a ...Show All

• Louis Lafreniere Newbie: sql 2005 encryption --- or where do I put that key?

  I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up. ...Show All

• jchoquet RDA Push Command Failing ...

  Hi, I am using the Pull command to pull two fields, on is the primary ID (int) non identity and the other is Description which comes down as an ntext type. This works fine but if I change the description and use the push command I get the following error:- The Query processor could not produce a query from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. I am really st ...Show All

• Aleth Error 8152: "String or binary data would be truncated"

  I've been working with a sample database that the company is using for testing purposes. I (we) did not create the database - it was sent over to us by another company. I'm still a rank newbie at working with MS SQL Server, though I've worked with Access and MySQL in the past. There is one table that contains bank information. At the moment, it is filled with information on imaginary (fake) banks. I need to change one record so that it contains ...Show All

• Scott.Berry Error Saving Binary data to sql mobile

  I have been trying to place a binary byte array into the sql server mobile 2005 database and continually get an error "The Identifier cannot be an empty string." when attempting to save this sql to the database: "INSERT INTO KHZ_Company_Permissions ( PermissionID, CompanyID, StatusID, PluginTypeName, PermissionLevel, ChangeStamp, RecordState ) VALUES (1, 1, 1, 'Plugins.Approval.ApprovalList', 2, System.Byte[], 0)" the ...Show All

• Luis Simoes Indexed View - has no influence on performance

  hi, I am using SQL Servre 2000. i have made tests trying to improve performance by using Indexed View. i have a table T1, that has a datetime field F1. i have another table T2, that holds links between records in T1. T2 has 4 fields : Recid  - identity column recid1 int - identifies a row in T1 recid2 int - identifies another row in T1 LT int - link type i want to build a query that retrieves all the rows from T1 that has a cer ...Show All

• forum389 How to display result of SQL-script in TextBox

  I have a script. Something like that: ------------------------------------------------- declare @Count int set @Count = 0 set @Count = @Count + ( select count(*) from Table1 where [name] = @Name ) set @Count = @Count +5 print @Count -------------------------------------------------- @Name is recived from parent Report. I need to show the resulting value of @Count in a TextBox. Please, help. P.S. I use Visual Stu ...Show All

• gruflee Create Trace Wizard for Profiler?

  Is there such a thing I read about one in SQL Server 2005 New Features by Michael Otey, but cannot find it. to my knowledge the standard create trace series of dialogs or wizard is the only "wizard like entity", trace templates provide you with common groupings of events to monitor for as well aka for replaying or as a workload/input for DTA. ...Show All

• Pr0g Service Broker not working for Restored databases (SQL 2000 databases restored on 2005)

  I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased ...Show All

• Ken Cooper Need to display image but not print it...

  Hi everyone, I have a need to display an image on a report (a sort-of icon), but when the user goes to print it, I don't want the image to be included. I guess that is doesn't matter if it's not there for export either. currently using RS 2000, but if this can only be done in RS2005, please tell. many thanks, 99 I guess there can’t be made a difference between viewing and printing or a differenc ...Show All

• Albatetra Blank Error Messagebox Displayed at startup

  When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON.  Everything seems to be working after clicking OK though.  Anyone else experienced this.  Also...  Why is it that I can't repair the installation from Add and Uninstall   Do I have to uninstall it to repair it The SQL 2005 is the Developer Addition with a new install... Oddly enough, it has! I d ...Show All

• appferreira Want to create a bar graph with an attached data table

  In excel when you create a bar graph there is the option add an attached data table to the bottom of the chart.  How do I do that in reporting services You would need to add a table or a matrix report item below the chart and show the data there. -- Robert ...Show All

• Talbengal Missing ODBC Driver

  I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager. "A connection could not be established to SERVERNAME\INSTANCENAME . Reason : Data source name not found and no default driver specified. Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME ...Show All

• J. Schouten Poor performance import text file

  Hi, I'm very new at SSIS.  I've got a package to import a 1,000,000 row tab delimited text file into my SQL2005 database.  Using SSIS with a Text File source and OLE DB PROVIDER target it crawls.  I do have it skipping error rows but that is the only logic I am using.  No indexes on the table either.  This is pretty basic and it takes SSIS 1.5 hours, DTS blows this away...  Assuming this is not somethin ...Show All

• Daya Anand pass parameters to an ASP.NET application using VS 2005 and reporting services

    Does anyone know how to pass parameters to an ASP.NET application using VS 2005 and reporting services. I have a bar graph I want to display but I do not want the navigation, export, parameter toolbars. I have one parameter called companyId that i want to feed to the reporting services report and display on an asp.net page ...Show All