Answer Questions

• Morpheus72 Installed, but can't ping 1433

  Any and all help is appreciated as project deadline is approaching... Background: - Two servers, 1 running WinXP with all updates and 1 running Win2K3 Standard with all updates. - Both have SQL Express 2005 June CTP installed - Both have Visual Studio 2005 Express installed. - Installation finished w/o any errors. - Services are running (browser and database) - TCP/IP and named pipes are enabled Issue: Can't ping 127.0.0.1:1433. OSQ ...Show All

• Mynor Ivan Muralles MSFT Help with SSIS error

  I execute my package to transfer a full database SQL 2000 to SQL 2005, and the transfer fails with this error: TITLE: Microsoft.SqlServer.DtsTransferProvider ------------------------------ ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Arithmetic overflow error converting numer ...Show All

• ShiroAmada using exists with group by

  I have found that when I want to restrict a query using exists, if I group by in the exists, it either doesn't return anything or gets too many. Here is an example using northwind. If you run the exist query, there are 4 rows out of 6 total. Using the exists, none are returned. I found that some queries like this select the exists select without the aggregate, so I get all 6 instead of the 4 desired. SELECT Orders . ShipRegion , Orders ...Show All

• wojtek suwala Trouble with XML Bulkloading from a stream

  Hi, I am having trouble bulkloading xml into SQL from a stream.  I am able to bulkload the XML from a file, but I want to load it into an XMLDocument first and then bulkload it.  I understand that the bulkload execute command is overloaded to do this but no matter what I try I get an 'Error opening the data file.' exception. I am using SQLXML 3.0 and C#.  Does anyone have any ideas Thanks. Yes, that helped. Thanks Bertan. ...Show All

• VegasKristy INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstr ...Show All

• swirl80 Upgrading from 'SQL Server Express 2005' to 'SQL Server Express 2005 with Advance Services'

  Currently I have following things installed on my Computer 1. SQL Server Express 2005 2. SQL Server Management Studio Express 2005 CTP I need to install following things A. Microsoft SQL Server 2005 Express Edition with Advanced Services B. Microsoft SQL Server 2005 Express Edition Toolkit Do I need to uninstall any any of 1 or 2 What should be my path to upgrade these software. ...Show All

• JLL05 Windows XP SP2 (32-bit), Athlon 64 X2, SQL Server 2005

  I upgraded from a P4HT processor/mobo to an AMD Athlon 64 X2 platform and now, I cannot install SQL Server 2005 on this new build. Does SQL Server 2005 install to this setup Getting Windowx XP 64-bit IS NOT an option given how little hardware and software support currently exists. The Evaluation Edition is an Eval of SQL Server 2005 Enterprise Edition. When you install Enterprise Edition on a client OS (ie. ...Show All

• You must enter a user name before continuing. SQL2K5 SP1-CTP fails while upgrading "Database Services"

  Hello. I'm a little confused what went wrong on the SP1-CTP upgrade. Now, all three times I installed SP1-CTP, it failed to upgrade the "Database Services," but possibly for varying reasons Attempt 1: Received message about Pending Reboots, message about Full Text .dlls being locked. Stopped Full Text service, selected "Try Again," received "Failed" for "Database Services" component; successful for all other components. Rebooted. ...Show All

• SimonH Re : Enabling / Disabling Data Flow Tasks

  Hello, I have created around 10 seperate packages for our application data load. Now I am planning to create a master package (or a wrapper package) which will execute all the 10 packages (thru execute package task). Then I have a job which executes the master package at a given date and time. Question : How can I enable / disable execution of each package within the master package depending upon a flag variable. The reason why I need ...Show All

• Elfmanne xml database

  Hi! Here is the problem! By a web service, I export table's data in XML file and XML Schema. After, I download this files localy (on PC or PPC) and I need to have all my relation and data structure. So, I need to take this XML files and create .mdb or .cdb with all data relation, field type and length, not null, pk and fk. I need to to that 'cuz I'll query this database with another program. - I export my query and s ...Show All

• Eugene Tan positioning of report parameters when diaplayed in report manager

  hi all i have a report with set of parametrers. by default when we create parameters they r displayed adjacent to each other. is there any way by which we can specify position of parameter to be displayed in parameter area for eg:- suppose i have two parameters say age & name then i want to display them one below the other. is this possible if yes how plz help me. waiting for reply. ...Show All

• barrysolomon1 Execute SSIS package on vb.net

  Hi All, I would like to write a small application for execute a SSIS package manually, but i got a error message as following: Coding: Dim oPkg As DTS.Package2 oPkg = New DTS.Package2 'Error Message Here oPkg.LoadFromSQLServer("SQL2005", "sa", "abc", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, Nothing, Nothing, Nothing, "AccessImport") oPkg.Execute() oPkg.UnInitialize() oPkg = Nothing E ...Show All

• NetMage Stored Procedure being saved in System Stored Procedures

  We recently upgraded to SQL Server 2005. We had several stored procedures in the master database and, rather than completely rewriting a lot of code, we just recreated these stored procedures in the new master database. For some reason, some of these stored procedures are getting stored as "System Stored Procedures" rather than just as "Stored Procedures". Queries to sys.Objects and sys.Procedures shows that these procs a ...Show All

• zfmicrosoft Provider for OleDb\Microsoft OLE DB Provider for Visual FoxPro

  I am using OleDb\Microsoft OLE DB Rpovider for Visual FoxPro for my Data Source Connection and it includes the deleted records from the Visual FoxPro database, how can it have it ignore the deleted records HELP!   Thanx Moshe I'm having the same problem but as a workaround in the Data access mode: you can enter a SQL command instead of a table name and do a select *. This filtered out ...Show All

• PG1 is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), ...Show All