Answer Questions

• DotNetDahlya Query Error

  Hi all, I'm a new guy trying to tutor myself on MRS and I'm using SQL05DEV on my desktop. I managed to finally get connected to AdventureWorks db, but when I run this query: SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName FROM HumanResources.Employee E INNER JOIN Person.Contact C ON E.ContactID = C.ContactID INNER JOIN Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID ===================================================== I get this error: TITLE: Microsoft Report Designer ------------------------------ An error occurred while executing the query. Invalid object name 'HumanResources.Employee'. ------------------------------ ADDITIONAL INFORMATION: Invalid object name ...Show All

• Carel Greaves ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. Ah, there is no ODBC driver for the SQLCe engine that I know of. It uses an OLE DB interface... hth I would guess that the reason he wanted an ODBC adapter was because he wanted the database to be accessible from some tool that supports ODBC, but not OLEDB. I'm actually surprised that there isn't some sort of generic ODBC-from-OLEDB adapter, so that if you have a DataSource accessible via OLEDB, you can turn it into an ODBC DataSource. IIRC there was a OLEDB to ODBC bridge at some point that worked with ADO classic... Here is a code example under OLEDB http://blogs.msdn.com/sqlserver ...Show All

• Shaantu "ConstraintException" error while filling dataset?

  Hi,   I always get a "ConstraintException" error when trying, at beginning of application, to run following statement (within "Form1_Load" routine called by "this->Load" EventHandler): " this ->TauxTaxeTableAdapter->FillByPays( this ->TauxTaxeDataSet->TauxTaxe,Cur_GrdView_SlPays);"    Also curiously if, while application is still running, I invoke again that same statement by means of a pushbutton clickevent,  everything is running smootly without error...  Looks to me that it is bugging only when running the first time...   Within Dataset, I tried to see what constraint could give me such trouble.  Here is the only constraint I could find: "th ...Show All

• fruce i really need some help!!!!!!!

  well......im from peru....i dont speak english too well.......but...i have the SQL express edition....but when i open it....i gotta to connect to a server.....but i dont have any server.....what do i should put to in "server name" and "authentication"...to star to use the SQL express edition.... well..if there are some grammathical mistakes....sorry...im learnin` english please answer me is an emergency!!!! Jaime well if you can tell me what do i should put in "server name" and "authentication"......i`ll fell better ahmedilyas ...im 17...........im learnin SQL in my university....i dont understand what u said.......but-......how do i know the type of authentication i set up ....can u ...Show All

• pavel989 Generate Detail Line even when no rows returned

  Is there a way to generate a detail line on a report even if the SQL Query returns no rows ...Show All

• Karlo Forcing Function recompilation in SQL 2000

  A stored procedure in the cache is automatically recompiled when a table it refers to has a table structure change. User defined functions are not. Here's a simplified code sample: set nocount on go create table tmpTest (a int, b int, c int) insert into tmpTest (a, b, c) values (1, 2, 3) insert into tmpTest (a, b, c) values (2, 3, 4) go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fTest]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[fTest] GO CREATE FUNCTION dbo.fTest (@a int) RETURNS TABLE AS RETURN (SELECT * from tmpTest where a = @a) GO select * from fTest(1) CREATE TABLE dbo.Tmp_tmpTest ( a int NULL, b int NULL, d int NULL, c int NULL ) ON [PRIMARY] IF EXISTS(SELECT * FROM dbo. ...Show All

• Aleniko29139 Built in limit or setting that limits the number of rows from an OLE DB Source Table in a Data Flow Task?

  I have a table that I'm loading as part of a control flow that in turn is copied to a target table by using a data flow task. I am doing this because a different set of fields may be used from the source entry to create the target entry based on a field in the source table. That same field may indicate that multiple entries need to be created in the target table from one source table entry for which I use a multi-cast transformation. The problem I'm having is that no matter how many entries there are in the source table, the OLE DB Source during execution only shows 7,532 entries being taken from the source table. If there are less than 7,532 entries in the source table, everything processes fine. More than 7,532 and the data flow task ...Show All

• John Oriente VS2005 as manager for SSEv

  I have installed SSEv runtime and VS2005 SP1 but I can't make a connection to SQL Everywhere in Server Explorer. When I Add Connection I don't see Everwhere or Mobile in the list of Data Sources. Is there any way to make this work Is there a different client for creating databases You will need to add VS Tool for SQL Server Everywhere(SSEv) to get the integrated dev environment for SSEv. You can get the Beta of the VS Tool from http://www.microsoft.com/downloads/details.aspx FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en Thanks Sachin You might have to choose Other Database in the list of databases displayed initially, upon choosing the 'Other' You can find the SQL Mobile or SQL Server Ev. ...Show All

• Soe Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. The error you mention in the sys.transmission_queue indicates that there is no route for the service named 'tcp://TCA02SQL603:4037'. Perhaps you used the route address instead of the service name BEGIN DIALOG takes in th ...Show All

• Ashis_dasgupta2001 SQL Server 2005 Service Pack 1 public (NON-CTP) is available

  SQL Server Service 2005 Pack 1 is available here . The list of new features and fixed was published here on KB Article 916940 . Keep in mind to read the readme file first in order to avoid problems during the update or unexpected bahaviour. Have Fun ! -Jens Suessmeyer. Hi, TBD sounds like (T)o(B)e(D)one, which should be fixed now :-) -Jens Suessmeyer. You can submit your bugs at http://connect.microsoft.com/default.aspx , it's where the bugs supposed to be posted. Definitely true. The rule of thumb I use is that if you don't get a response here in the forums to a bug posting in a day or two (certainly after bumping it ...Show All

• BI NeuMan Merge Replication using Web Sync - Proxy Auto config problem

  Hi I am trying to setup merge replication using web sync. I keep on getting the message: The Proxy Auto-configuration URL was not found. Yes I have read all the postings telling me to check my internet explorer settings concerning proxy server and auto-detection - I am not using a proxy - auto detection is unchecked. Does anyone have another clue Thanks Alex 2006-08-16 15:31:09.375 Connecting to Subscriber 'CRAW' 2006-08-16 15:31:09.437 Connecting to Subscriber 'CRAW' 2006-08-16 15:31:09.453 The upload message to be sent to Publisher 'CRAW' is being generated 2006-08-16 15:31:09.453 The merge process is using Exchange ID '20E2BF4F-8812-431F-8BF8-94A44B80C16E' for this web synchronization session. 2006-08-16 15:31:09.500 The ...Show All

• iamAlan Remark some task or data transformation component

  How could I remark my script component, It is isolated, I just wanna check something without losing the long script written inside. Thanks, Fahad I hope you're doing something other than trimming fields in the script component. That is what the derived column transformation is for. However, just cut the script component and paste it into either a new, temporary data flow, or in a new package altogether. You can comment out the code, but then you'll probably have to adjust the input/output columns. This was my assumption. I am looking for a better way Can you be more specific as to what you are trying to accomplish Thanks. Fahad349 wrote: This was my assumption. I am looking for a better way Well, tha ...Show All

• dmadrian Move data to DB2 on AS400 with SSIS

  Anyone writing data to DB2 on an AS400 with SSIS I cannot get the OLEDB destination configured correctly. I can set the destination up with a SELECT sql query, and preview the resultset. **BUMP** I still need help with turning off Commitment control on IBMDA400 connection. Thanks Ryan. I got the data into the AS400. I'd post the exact settings if anyone wants them, but right now I'm off to start my consulting business setting up SSIS-AS400 connections. Thanks again! --BJ What is the error Also, you can't use an out-of-the-box solution against an ODBC destination. You are correct in using the OLEDB for DB2 driver. I use it ...Show All

• BJHop Could not create Maintenance Plan

  Hello, if I try to create a Maintenance Plan from my local workstation I get the following Error Message: TITLE: Microsoft SQL Server Management Studio ------------------------------ The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/ LinkID=57083 . (ObjectExplorer) For help, click: http://go.microsoft.com/fwlink/ LinkID=57083 On my loca ...Show All

• Yaakov Ellis Stored procedure syntax problem

  I get a syntax error from the following: CREATE PROCEDURE dbo.IsFirmNickNameUnique @NickName varchar(12), @Found bit output AS IF ((SELECT COUNT(*) FROM Firm WHERE Firm.NickName = @NickName) = 0) BEGIN @Found = 0 END ELSE BEGIN @Found = 1 END RETURN CREATE PROCEDURE dbo . IsFirmNickNameUnique @NickName varchar ( 12 ), @Found bit output AS IF NOT EXISTS( SELECT * FROM Firm WHERE Firm . NickName = @NickName ) SET @Found = 0 ELSE SET @Found = 1 ...Show All