Answer Questions

• Jon Braganza Including Sql Express DB with Winforms Application

  We are thinking of using a Sql Server Express database ( .mdb .mdf) as a data resource in a Windows Forms application that we will be distributing to clients. When the application is built, the mdb file is copied to the bin directory. In order for clients to access this database, will they need to have an instance of the SQLEXPRESS server installed on their computer Or since the .mdb .mdf file is being accessed from a .Net 2.0 application, there is no need to install a separate db component If I do have to separately install the db component on the client end, is this the way to go about it This Or is there a different/better way When you do distribute you can package up the SQL Engine (SQL ...Show All

• Andreas Jaeger SQL Server 2005 schema

  A database was created in SQL 2000. We are going to move to sql 2005. So I attached a database to SQL 2005 and now I have a problem with name resolution. When I worked with SQL 2000 I did not put my schema's name before table name (select * from table1). The schema's name is my user name (IQA) and by default the schema name is a name of user who loged in. (in 2000) Here is a problem with SQL 2005. The schema's name is still IQA. But I need to do select * from IQA.table1. I created IQA login and IQA user is an onwer my IQA schema but I still can not do a select without schema name. I need to resolve this because VB.Net code has all select statement without schema's name. Need help!!! Apparent ...Show All

• Phil Gould Convert row data into Column [Didnt get the exact result......]

  Hi members I got the result set as shown below (By executing another query i got this). Month Status Count ===== ====== ===== April I 129 April O 4689 April S 6 July I 131 July O 4838 July S 8 June I 131 June O 4837 June S 8 May I 131 May O 4761 May S 7 But, I need the same result set as below Month I O S ===== = = = April 129 4689 6 July 131 4838 8 June 131 4837 8 May 131 4761 7 Can anyone provide me the tips/solution. If you're using SQL Server 2005 you can use the PIVOT command, but you still have to specify the columns to be listed in the IN clause. What you then could do is to query for a table as the following Month January February March (...) ================== ...Show All

• RobertMC Standard Edition 20 x slower than Developer edition?

  Have created a database on 2 separate machines, the developer edition server performs a test insert of 100000 records in 33 seconds, the standard edition server performs the same operation in 10 minutes 50 seconds. Have checked the properties of both sql server registration and database and the only significant differences are in the SS2005 developer edition and SS2005 standard editions. The databases the tests were performed on were direct restores of the same database. The slower server has 4 processors, 2 on developer. As a control, I have performed the same test on another server with Developer edition and this took 50 secs. I am being told that the difference in the test figures are down to the developer edition being fundamenta ...Show All

• Corinna Vinschen get rid of an anonymous subscription

  Hi all I've got the following situation: setup up an merge publication (distributor and publisher at the same server) setup an anonymous subscription deleted the subscription In the replication monitor, I still see the deleted subscription. Why And how do I get rid of it Thanks a lot for any informations and greetz Aline I've done both by now (dropping via UI and with sp_dropmergepullsubscription). And still have it on the replication monitor, even after a restart of the replication monitor. The "select * from sysmergesubscriptions" on the publication database doesn't show any dropped subscriptions. The problem on the productive system is even more complex. A ...Show All

• Cathie 64 Sql Server 2000 Desktop Engine Installation

  I have SQL Server 2000 installed on my laptop and am trying to install an instance of MSDE. I keep getting the error message: "The installation of SQL Server 2000 Desktop Engine has failed. Please see the Getting Started manual for further instructions." I have done this installation before on other machines. Something must be corrupt on my machine ( ). The error message is not very enlightening. Any ideas I tried kb 816499 and related 299351. Neither helped. One point: I previously tried to move applications from an older machine using PC Relocator which might have moved some files related to MSDE that I cannot see. There is no evidence of MSDE in Add/Remove Programs or Program Files or Enterprise Manager, but somethi ...Show All

• Ovod "where" statement in list

  I have one dataset and two lists with one table in each list. the two tables should get their data from the same dataset. but the tables need different "where" statements. in the dataset I only can define one "where" statment. it is possible to displace the "where" statment into the two lists they should access to the dataset with their own "where" statement. Check the following: make sure the parameter in not multivalue make sure you access the .Value property and not the .Label (which is a string) Depending on the complexity of your where clause you could remove the where clause to retrieve the data for both lists in one dataset and then use the filter tab of the table to make it display just the data you want ...Show All

• Thomas Andersson Problem with package.Execute passing variables

  I am having a problem with passing variables into my SSIS package from C#. The variable names match ("Variable1, ...), however they do not seem to be assigned the proper values once the package is executed. The package does run and returns a FALURE notice saying there is a problem with my expressions. When I added a new data flow, derived all the variables into columns and wrote their values to a flat file I noticed that the values still contain my default values from the SSIS package itself as though nothing was passed in from C#. I am hoping that it is a simple configuration/user error. Any ideas ---- C# ---- Reference to Microsoft.SQLServer.ManagedDTS using Microsoft.SqlServer.Dts.Runtime; Application ...Show All

• Biju S Melayil Error: Value does not fall within the expected range. Error in buffer.DirectRow Method

  Hi I am trying to make a custom task. The custom task has one input, which i map to externalmetadata column in the task and one output. When i run the task it fails with this error ( I am putting the whole SSIS message) SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Destination [1855]: The processing of file "C:\ole d ...Show All

• ClydeD Stumped

  This one has the expert in SQL Express stumped and he suggested I try posting here. My problem is that I am trying to load SQL Express and can not do so. Mike Wachal - MSFT wrote: mnn2501 wrote: I am having a similar problem, I first used the uninstall program which failed, then went to add remove programs finding nothing, then went to windows explorer and deleted what looked to be obvious choices. I still can't get sql express to install - any idea's Here are the logs: Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00 The Product Name ...Show All

• Edward Pereira Non significant '0' removed from alphanumeric code

  Hi all, I have a problem with alphanumeric codes in SSIS. I have a sql table with a varchar column which contains codes like '080101000', in my SSIS dataflow I have a lookup against this table and the column whith the code is used as output column for my lookup transformation. In the advance editor the output column datatype is DT_WSTR, but when the code contains only numbers like the code '080101000' the first '0' is removed! It's like the code is at some point transformed to numeric and then inserted in the output column as a string. This in nonsense!! Does anyone have an idea how to avoid this Sebastion, Did you get this resolved Did you try using data viewers across the Data flow t ...Show All

• Visual Basic Expert Trouble with Oracle 9.2 coexisting with SQL Server 9 and Visual Studio 8

  Hi, I installed Oracle 9.2 after installing SQL Server 9 (2005) and Visual Studio 8 (2005). After creating databases and setting up networks (configure listener, configure client, restart listener), but everytime I connect explicitly to Oracle virtual-engine (so called Oracle-service) Visual Studio raises exceptions, and the listener is stopped. Why this happens I have reinstalled Oracle, restart the OS, recreate the database, reconfigure Oracle networks (with the same value) 3 times but the problem remains. Thank you, Bernaridho ...Show All

• Adam Machanic Moving SQL servers from an NT4 domain to a Windows 2003 domain

  I am in the process of decommissioning an NT4 domain and will therefore need to move all the SQL server instances (6.5, 7 and 2000) into an existing Win 2003 domain.  Are there any whitepapers detailing the appropriate testing to carry out in advance of such a project All I can find are some articles about moving SQL clusters into a Win 2003 domain.  Any advice or suggestions of resources to look at would be greatly appreciated. ...Show All

• Jan-Dirk Output 10 rows

  Hi! I am a newbie, need to make a report with only 10 rows, and not the whole result. How do I actually specify the output as 10 rows Thank you so much in advance! Further to this, to create a sequence of numbers just use the RowNumber function. =CStr(RowNumber(Nothing)) + " " + Fields!Album.Value curiousss wrote: Moreover I wonder how to define sales per age-groups I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this You can use a nested IIF within the group criteria to do this. =IIF(Age < 16, "<16",IIF(Age <21,"16-20),IIF(Age<31,"21-30",">30"))) Note matching ...Show All

• iconjunky What is the best model for calling Stored Procedures from ASP?

  Puzzled... I noticed that COUNT stored procedures which worked in SQL 2000 are no longer working and causing errors while perfectly executing in SQL  Mgmt Studio query window. Set objCmd = Server.CreateObject("ADODB.Command") Set objCmd.ActiveConnection = Cnn objCmd.CommandText = "{ = CALL dbo.CountSomething ('" & myID & "')}" objCmd.CommandType = adCmdText objCmd(0).Direction = adParamReturnValue ' causes "Invalid parameter number" error objCmd.Execute MyCount =  objCmd(0) The procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[CountSomething] (@member int) AS DECLARE @Count Int SELECT @Count = COUNT(members.id) FROM members WHERE members.Something= @member RETURN @Count I use AD ...Show All