UNION and UNION ALL are ANSI SQL UNION does an implict Distinct to remove the duplicates while UNION ALL leaves the duplicates in.  I think you can use the convert...

I think it is SQL Server Agent dependent try the links below for permission configuration.  And I would also check the network configuration to add the Novel protocols SPX/IPX.  Hope this...

Try the code below to use Excel as linked server or import the data to a temp table before moving it to the destination table.   One of the above should...

I am not sure about your needs  but to run DTS package through a stored proc you either use DTSRUN.exe or XP_CMDSHELL which is SQL Server Agent dependent. Try the...

What you are getting is called character conversion, your other options are to save the file as Unicode in notepad and Excel and insert it into SQL Server.  I am...

Try these links for localization in .NET because most  .NET application localization is in XML.  Hope this helps.

http://openmymind.net/localization/index.html

http://openmymind.net/index.aspx?documentId=4

http://www.microsoft.com/downloads/details.aspx?FamilyID=6b6fb09f-f25c-48e9-9e26-b55144600da1&DisplayLang=en

Kind regards,

Gift Peddie

The current database use is you start with relational Algebra and clean the data through ETL(extraction transformation and loading) to move the data to relational Calculus, UDM(unified Dimension Modeling) is...

Try this link for UDM(unified Dimension Modeling), it is new, striping relational Algebra and moving to relational Caculus in one step.  It is part of SQL Server 2005.  Hope this...

In SQL Server 2000 you don't need that, because you can add the collation to your create database and Table statement.  Rebuild was a requirement for SQL Server 7.0.  Hope this...

Business Object 11 can be used by an executive but SQL Server Analysis Service require development skills.  BI have not been a boon because relational calculus is not what most...

I have two links that will take you in the right direction because your error means the Listener is not running on your connection.  Hope this helps.

http://www.experts-exchange.com/Databases/Oracle/Q_21450200.html

http://ora-12541.ora-code.com/

Kind regards,

Gift...

I have three links that deals with your error message.  Hope this helps.

http://support.microsoft.com/kb/q275883/

http://www.forum4designers.com/archive25-2005-1-179722.html

http://www.w3schools.com/xml/xml_encoding.asp

Kind regards,

Gift Peddie

I am not sure but if encoding in your code is causing the error you can encode at the top and you can also encode by saving the file as...

Try this link for a three part visual tutorial on the reporting services.  Hope this helps.

http://www.15seconds.com/issue/041013.htm

Kind regards,

Gift Peddie

Try this link for some options using OpenXML with Text datatype and others.  Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

Kind regards,

Gift Peddie