Answer Questions

• Lucky2000 Is it possible to create a UDF from a .NET 2.0 assembly that uses dllimport to call unmanaged code?

  I have been reading up on everything I can find on this subject and I am not clear if this is allowed within the SQL Server 2005 CLR. My function calls work within a Windows form project, but don't run when invoked from a SQL function. I don't get any errors or warnings when creating the assembly and functions within SQL Server, but when running via a select statement, the spid just hangs and I have to stop & restart the service to kill the ...Show All

• NickWebb order of packages within a project

  Is there a way to reorder the packages within a project For example, if a parject contains three packages (p1, p2, and p3) and I decide that p3 really logically belongs first (gets executed in that order, maybe), then is there a way to move p3 so that it is at the top of the listing of packages for the project I like to keep things neat. Yes, order is stored in the .dtproj file... Thanks! What is the be ...Show All

• zhangchenxu How to design this cube?

  Hi, I have a question on designing the fact table. There are 2 tables in my database: OrderHeader,OrderDetail. And the OrderDetail table has different lines for different product. If the OrderDetail table is the fact table, how can I get the measure on how many orders we have I cannot simply use count(orderno) as the measure because the field,orderno, is duplicate in the OrderDetail table, and analysis services don't support "count di ...Show All

• Kbathgate ERROR: SQL Server does not exist or access denied

  I am really new to SQL and am having trouble getting to first base. I installed SQL Express on a 700Mhz Pentium III with 256Mb of RAM system running Windows XP pro. The installation went smoothly except for a warning that my system did not meet the minimum requirements. I can open the configuration tools, but am clueless about their meaning. When I open Visual Studio and view the Server Explorer , I see my system GYPSY listed under the servers, ...Show All

• cpvgd How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. What's wrong with this It will return all the data you could hope for. Do you want to generate new IDs, unique to the query and not in the DB Please tell m ...Show All

• Brian Dreeszen Text Qualifier {"} Not Working

  I have installed Standard SQL 2005. I have a problem to import text file in db because of text qualifier {"} not working. Does anyone have the same problem Is it a problem in my installation Thanks for ant comments. Jian Actually I tried to upgrade dts package from 2000 to 2005 standard sql server. The text file contains delimiter (,) and text gualifier{"}. I don't know why the text qualifier does not work. Than ...Show All

• CraigHunterFXA Can Data Extension built with VS2005 work with RS2000 ?

    For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#. Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work. Is this a valid / supported configuration If it is, what steps, modification to the various configuration files would I need to make to  get it to ...Show All

• smarlowe SSIS: encryption not supported on the client

  Using SQL Server Business Intelligence Development Studio, when I try to create a new OLEDB connection manager and I try to connect to the SQL 2005 DB, I get an error message saying that "Client is unable to establish connection Encryption not supported on the client" This is ONLY in SQL Server Business Intelligence Development Studio! If I connect to the same server using SQL Server Management Studio and using server type Integration ...Show All

• abo_selaiman Report and Images on Interanet

  Hi - I wonder if anyone has tried to display images from a intranet site when I try to do it the images doesn't get render and ends up as [x]. And the same report executed in VS gives me the following error: The value expression for the image ‘image1’ contains a URL reference, which is not supported. Any ideas IS it looking for a .com ... Limitation The URL is constructed as follow: http://servername/folder/imagefile Thanks   ...Show All

• DaVince Replication Error: 4138

  If our subcribers try to synchronize the following error occurs. The Upload of the data works but the download failes. Error messages: The merge process was unable to perform data validation on article 'tbl_xTableFieldValue'. Check for SQL Server errors in the Windows application event log or retry at a later time. (Source: MSSQL_REPL, Error number: MSSQL_REPL2147766343) Get help: http://help/MSSQL_REPL2147766343 Conflicting locking hints are sp ...Show All

• zian SSIS Runtime Object could not be created error:

  I am using SQL Server 2005 Version 9.00.1399.06 (Intel X86). Whether I try to start a new Integration Services project in Visual Studio or try to import data into a database I receive the following error: SSIS Runtime Object could not be created. Verify the DTS.dll is available and registered. The wizard can not continue and will terminate. Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to in ...Show All

• LEBRUN Thomas Save TextBox to Database as new row?

  (VB 2005 Express) I have a textbox linked to a DataTable (database). I want to save its text into the database as a new row. What is the VB code The following is not working. Me.Validate() Me. my DataTableBindingSource.EndEdit() Me. my DataTableTableAdapter.Update(Me.myDatabaseDataSet. my DataTable) Thanks for any help. There's a great learning resource here. Over 16 hours of video for free from Microsof ...Show All

• Madman Nested DTS packages not firing progress events when executed via .NET interop

  Hello, I'm writing a windows service in .NET 2.0 (C#) that executes and logs the results of various types of ETL jobs (SQL Server 2000 DTS & Data Junction currently).  This works fine on individual packages, but when I execute a package that executes other packages via the Execute Package Task then only the Package Start, Finish and Error events fire.  I thought that perhaps this was by design, but when I execute this package ...Show All

• Delphi Skyline ~* Data Loading in Reports *~

  Hi, I have a report with atleast 1000 pages. my question is, when the user requests for the report, will all the 1000 pages load at one time or will they be loaded when user clicks the "next page" link... are there any ways to improve the performance... Thanks in advance .. Cheers Chakri. Hi, Thanks Mr.BenniG. I have one more query. The number of pages in the report viewer and the number of pages in ...Show All

• earth_n_straw SQL Server 2005 Enterprise - x64 Edition - CoCreateInstance() failure

  SQL Server 2005 Enterprise Edition Windows Server 2003 Enterprise x64 Edition + SP1 My application does this: --------------------------------------------------------------------------- CoCreateInstance( CLSID_SQLDMOApplication, NULL, CLSCTX_INPROC_SERVER, IID_ISQLDMOApplication, ( LPVOID * ) & mpDmoApplication ); ------------------------------------------------------------------------- ...Show All