Answer Questions

• Steven Barden exposing proprietary data to SSIS (Newbie alert)

  Hi all, I've exposed my data (that exists in a proprietary format) with the ADO.NET provider interfaces (IDbConnection, IDataReader, IDbDataAdapter and IDbCommand). I can't seem to find any examples of how to get Integrated Services to hookup to this .NET code in my class library. Is it possible My goal is for this provider to be both a destination and a source and for others to be able use IS to manipulate the data however they want. Som ...Show All

• Zeon219 WHERE includes all letters

  Hi I would like to perform a procedure which takes a string of numbers and searches for strings in a table which include all the given numbers in any particular order. problem is i can only return strings which include 'any' of the letters in the search string and not 'all'. this is how i perform it so far: @IncludeNumbers VARCHAR(50) AS BEGIN SELECT Phone AS [Telephone Number] FROM tbl_Person AS p WHERE (p.Phone LIKE '%[' + @Incl ...Show All

• dinsdale Cannot connect to Database in Server Management Studio

  I currently can't connecto to my database in SQL Server 2005 (enterprise) from the SQL Server Management Studio itself! as soon as I try to use any functions, I get cryptic errors found below.  I am about to pull my hair out.  Everything was working fine for around 4 days and now everything just blows up.  I've tried using both sql authentification and also windows: Errors I'm getting (print screens): http: / / ww ...Show All

• saspsnvg111381 How to restore SQL 2000 DB to SQL 2005

  Hi, All I am trying to restore SQL 2000 DB into SQL 2005 Database. I backup the database from SQL 2000. From Management Suit, I try to restore database but I can not see network drive from there even though SQL serveris running under network account. I could see network drive from SQL 2000 or at least I can type path to find backup file. However I can not do this.. My Q is: 1. How can I restore this SQL 2000 db to SQL 2005 using network path 2. ...Show All

• JoeyNguyen Raising errors in Validate() method

  Hi, I am building a custom component. In the Validate() method I am checking for various things. Here's a section of my code: if (ComponentMetaData.InputCollection[0].InputColumnCollection.Count != 1) { return DTSValidationStatus .VS_ISBROKEN; throw new Exception ( "You need to select one and only one column" ); } The problem I'm finding is that my Exception never gets thrown so I never see the e ...Show All

• GaryBROE Sorting records in a Group By

  Hi, I've a problem with the following stored procedure Select . It does compile and run, but doesn't return the sorted result I wanted, which was to have the records from tblPieces (alias Pcs) sorted by (in order) Pcs.fkBatchId, Pcs.fkProfileCode, Pcs.Colour. What happens instead, I think, is that the correct records are selected, but in the record creation order. CREATE PROCEDURE dbo.LoadOneBatch ( @BatchId int, -- the pkBatchId of the b ...Show All

• JackyLi Parameter Validation for Floats

  Why is the validatation of parameters of type float not working properly. I keep getting the error: An error occured during local report processing. The value provided for the report paramter 'EstimatedAmount" is not valid for its type. Should a javascript alert popup occur if you put an alpha character into a parameter that is set to an int or float Hi Do you know how to validate input parameters in RS2005 I have two da ...Show All

• drb How to export report to HTML format?

  Hi, all here, Would anyone here please guide me how can I export report created on SQL Server 2005 reporting services to HTML format Thanks a lot. With best regards, Select the Webarchive export mode from the parameter pane in the report manager. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• gabylevy Can report services use Request.QueryString("varName") for record selection?

  I know the parameters are available, but let's say if I've got a variable in a request.QueryString() function I want to use from a page which links to the report, is it possible for the record selection to be filtered by the Request.QueryString() variable You need to pass the page parameters into as report parameter name / value pairs. We do not provide you the raw page querystring in the report (as the&n ...Show All

• Greg Brown Cached Report and Windows Authentication

  I want to use cached reports with Reporting Services 2005. But when I edit the execution properties of a report, an error message answser that I can't use cache because it has a connexion to Analysis Services with Windows Authentication. I understand why I can't do that, but I still want to do so, because the reports take too much time to load. How can I do that Thanks. You can configure the datasource in the report to run using st ...Show All

• JaredJ Unable to read local eventlog (the parameter is incorrect)

  In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: RESYSHADOW Description: Unable to read local even ...Show All

• pedron How to avoid user delete column

  Dear all I would like to ask one sql question , it's that possible to use statement delete my columns select * from tablename where columna = '--delete from tablename ' ALTER TABLE <table_name> DROP COLUMN <column_name> See also: http://msdn2.microsoft.com/en-US/library/ms190273(SQL.90).aspx That article has an explicit example for this: B. Dropping a column The following example modifies a table to remo ...Show All

• Marcelo Battagliese Bug?-when using nested subreports in combination with list

  Someone please help me with a workaround on this issue: I have created three reports: (ReportA, ReportB and ReportC). ReportA includes a subreport (ReportB). ReportB consists of one list. The list is bound to a dataset. The list consists of one subreport (ReportC). ReportC is an empty report.  What is the problem: When running Report A,The report generation fails when the dataset that is used in ReportB returns zero rows and  ...Show All

• RBIagric SP datetime Parameter problems

  DROP TABLE TestTable CREATE TABLE TestTable (  StID tinyint NOT NULL ,  StDate datetime NULL ,  Amt float NOT NULL CONSTRAINT [DF_TestTable_Amt] DEFAULT (0),  CONSTRAINT [PK_TestTable] PRIMARY KEY  CLUSTERED  (   [StID]  )  ON [PRIMARY] ) ON [PRIMARY] GO /* And After i'll create insert SP useing 'CREATE STORED PROCEDURE WIZARD' Sp name:'insert_TestTable_1' And Pass Some Parameter values */ ...Show All

• Aluri Non-release version (600) is not supported by this version of SQL Server

  I downloaded the 101 Samples installation (i.e. 101SamplesCS.msi) from Microsoft's website, which contains SQL Server database files. While working with the databases in the "Data Access" samples from the 101 Samples projects, I get the following error: "Database <mdf_name> cannot be upgraded because its non-release version (600) is not supported by this version of SQL Server. You cannot open a database that is incompa ...Show All