Answer Questions

• BhuttCrackSpackle Why is sort so slow?

  I set up a sample sort data flow that is attempting to sort 11M records totalling about 3GB. It ran for four hours and then I killed it. How can it be so terrible Am I missing some hidden tuning parameter jamie, thanks for the clarification. what happens if a 32 bit package attempts to use more than 3 GB of memory And what columns are in the sort key What is the type of those columns -Jamie I will try that. DI ...Show All

• mdavison How to close all open "handles" to a SQL Server 2005 express DB?

  Hello all! I'm trying to create an application which makes a copy of the database file it is using on application start and can restore it at any time, if needed (little project about SQL injection, so I need the copy ;-) ). This works fine, but as soon as I make my first connection to the db (connection_object.open()) and close it again I can not access the file anymore, because it is "in use by another process". How can I release all ...Show All

• kitcad Lookup including looking up on null values possible?

  In order to insert datekey values in I lookup datekey in the datedimension table. I join on the 'Date' column that contains dates. The datedimension contains one record for 'unknown date' for which the value of the 'Date' column is null. The behavior that I desire from my lookup transformation is that for input records with a date the corresponding datekey from the datedimension is looked up and for records with date = null, the datekey for 'unk ...Show All

• Rolan_64 Display Row Data As Cols

  I have data in rows that I need to aggregate and display in a columnar fashion and I haven't been able to figure out how to do it. A simplified version of the data as it is stored in the table: Station Month Day Reading 1 1 1 100 1 1 2 200 1 1 3 300 1 2 1 400 1 2 2 500 And I would like to create a query that returns: Station Mo ...Show All

• Mike Kulikowski Stored proc concatenation problem

  I have a stored proc that looks like this CREATE PROCEDURE InvByRange03 InvNum int = NULL, AS DECLARE @vcWhere nvarchar(1000) DECLARE @vcSelect nvarchar(1000) SELECT @vcSelect='SELECT InvNum, Company, StatementDate, TotCharged, Paid FROM Invoices WHERE' Select @vcWhere='' IF Not @InvNum IS NULL SELECT @vcWhere=@vcWhere + AND InvNum = ' + @InvNum When I compile this sp it compiles alright, but then I execute it I get an error mes ...Show All

• mtbDad download source? - Mike Wachal - developing apps w/embedded databases

  Hello, I watched the ondemand video and I am still looking for the source that is referred to. I, of course, would like to download it and work with it. Please post where I can find it. Thanks. Thanks for watching the webcast! I'm a bad webcast host and I haven't posted the source yet. When I post it, it will be available on the SQL Express Blog and I'll post a notice in this forum that it's there ...Show All

• DucNgo RS2005 ReportViewer

  Is it possible to use the ReportViewer user control in an ASP.NET 1.1 Web App All the tutorials I have found integrates the reportviewer control from RS2000 and not RS2005. I don't think so. The Report Viewer Control is new to ASP.NET 2.0. ...Show All

• Leonardo Blanco Overloaded Stored Procedure

  Hi I want to create two stored procedures with the same name but accepting different params. Lets say Procedure A can accept param1, Procedure A can also accept param1,param2. Is there any way SQL Server supports overloaded procedures with different sigantures. Regards Imtiaz You can use a feature called numbered stored procedures. So you can create somesp;1 and somesp;2. But I would not recommend doing this si ...Show All

• killer_whale installing sql server mobile in an hp ipaq rx1955

  does anybody know how to install sql server mobile and the query analyzer in an hp ipaq rx1955   don't see the samsung processor in the processors list. thanks  This device runs Windows Mobile 5 and is ARM compatible.  The CABs you need are: Location: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i Files: sqlce30.dev.ENU.ppc.wce5.armv4i.CAB sqlce3 ...Show All

• DaveHFlynn Partially solved the problem {OLE DB error - TCP Provider: No connection could be made ...}

  All, -> SQL Server 2005 Standard set as a named instance, runs as a local system -> SQL Server protocol enabled: TCPIP (configured to listen on port 1433 with use of dynamic ports disabled) -> Remote connections through the SQL Server Surface Area Configuration. Server starts successfully. But, I received the following error on trying to process a cube from BI studio is - OLE DB error: OLE DB or ODBC error: Login timeout exp ...Show All

• jcollake Batch invocation of Drillthrough action

  Does anyone happen to have an example of a batch invocation of a drillthrough action Essentially, what I'd like the ability to do is use the results of the drillthrough to feed into another process (i.e., to use as input to an SSIS package or load into a relational table.) However, I've found no examples of what the action settings would need to be in the Application field, for example. Maybe drillthrough isn't the proper action to define it ( ...Show All

• mgoetzke Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express?

  Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express I DownLoad the tool named XM.exe,but It's only a Query tool and I have to do everything using scripts.I realy want to know Is there a tool that I can use to Create db and restore db and backup db and create table etc. like the Admination tools in SQL 2000 Thanks for u kindness. Tonny. You can use the tools that come with the June C ...Show All

• Rosen M Yukon SP performance issue

  Hi all, I'm using the next-to-latest Yukon Enterprise beta. I have an SP with a complex query and have discovered a strange performance issue. My query includes:   * 8 variables, 3 from the SP parms and 5 locally defined   * a .NET UDT I have a fairly simple schema: 9 tables of which four are accessed in the query. When I call the SP, it takes ~16s to execute. However, if I replace the parms with static values, it takes ~0.1s! What' ...Show All

• THE_BAT SQL reporting services 2005 with CLR

  Hi, I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR. The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message "An error occurred while retrieving the parameters in the query. The stored procedure 'mysp' doesn't exist.   Thanxs in advance       ...Show All

• KUCL Debugging via Test Script; HANGS..

  OS: Windows 2003 Standard, SP1 SQL: SQL Server 2005 Standard September CTP VS: Visual Studio 2005-RC -------- I have created three CLR based objects, two functions and one stored procedure. I can not debug these using a TEST SCRIPT, via Visual Studio 2005. (Note Studio and SQL are running from the same system, via the same account.  The Account is an ADMIN privledged user on the OS, and a SYSADMIN member on the database) When I execute the ...Show All