without redesigning your db structure to 3nf I would change the product_id and product_ref_id to binary values, it will allow you do bitwise comparisons:

Your product_ids will be:

0x0000  Clothes

0x0001  Pants

0x0002  Shirts

0x0004 ...

The error you are getting is because there is statement using an equal operator with a subquery like:

select * from myTable where id = (Select id from myOtherTable)

the statement "select...

I interpret the interviewer's question in two possible ways...  w/o being in front of the interviewer I can't ask clarifying questions so this is what I would assume he/she was...

This posted script from iecdba should do the trick...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=422

From the server, are there any differences in how you've set up the ODBC data source... 

Check to see that TCP/IP is enabled for the named instance, it should be...

Sluggish?  It sounds like your vendor may be giving you the good ol run around. What led your vendor to this conclusion? 

What's the problem you are...

What version of MDAC are the client machines running.  If you don't have the MDAC Component Checker, download it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=SSP4SMB

Here are some troubleshooting steps for the error you...

If you can connect locally by creating an ODBC Data source that points to the local machine, then it looks on the surface like network. 

If you are connecting using...

What method of connection are you using...  ADO, ODBC, etc...

Is port 1433 TCP and/or port 1434 UDP blocked by firewalls?

Jason

Yes, when creating the trigger use FOR INSERT,UPDATE.  If different logic is dependant upon what type of statement is executed, INSERT vs UPDATE, use the below T-SQL to execute statement...

You need to put the results of xp_getfiledetails into a temp table and then set your variable to the creation date (see below)

DECLARE @dtDate DATETIME

IF EXISTS(Select * from tempdb.dbo.sysobjects where...

The error tells me that in the database aks_le2 there is not an object named artigos or the aks_le2 database doesn't exists on the same instance of SQL Server.

Most likely...

Use this:

EXEC master.dbo.xp_getfiledetails '[Path\Filename]'

It returns

Alternate Name

Size       

Creation Date

Creation Time

Last Written Date

Last Written Time

Last Accessed Date

Last Accessed Time

Attributes 

Jason

I took out the cast function just to make it neater since you don't have to covert a varchar to a varchar, then added single quotes so that the print...

When you say BCP I am assuming that you mean the BCP.exe command line utility.  You won't be able to specify a sheet using BCP.exe, however if you use DTS...