/*top 25 customers*/

select sales.customerid as customerid,sales.sale As TOTAL,1 AS semirank,customers.customername as customername

from dbo.sales sales

inner join

 (

  select TOP 25 customerid,sum(sale) as Z/*needed for union?*/

  from sales

  group by customerid

  order by sum(sale) desc

) thebestcustomers

ON...

What hardware difference is there between the  integration-test and production/development server?

Are you restoring through the enterprise manager or query analyzer or ...?

Sql dmo errors can spring up when the servicepack level of the client tools mismatches the server servicepack level.

Have you checked that collation compatible option is on for the linked server?

The following links have a colorlistbox using a subform to implement the coloring

http://www.candace-tripp.com/pages/access_downloads.aspx

http://www.candace-tripp.com/download/colorlistbox.zip

Otherwise I would think it was a custom control.

I don't have experience with MSOLAP but

http://support.microsoft.com/default.aspx?scid=kb;en-us;218592

To query a local or a remote OLAP server database from SQL Server, you have to install the MSOLAP OLE DB provider on...

and the question is?

from http://www.databasejournal.com/features/mssql/article.php/3085211

History

Linked servers are a superset of "remote servers." Remote servers allowed the running of stored procedures on distributed SQL Server machines. SQL 2000 BOL states, "Support for remote...

Glad you got it sorted out

like alternating colors or just the textfield above in the combobox?

Access2000 and higher implement conditional formatting:

http://support.microsoft.com/?kbid=304104

Can you give an example of your connectionstring?

I've gotten different sortorders with

SELECT TOP 10 

 CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion

 ,S.fecha_creacion AS B

 ,ID

FROM dbo.test  S

ORDER BY B DESC

ID 1 on top

SELECT TOP 10 

 CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion

 ,S.fecha_creacion AS B

 ,ID

FROM dbo.test  S

ORDER BY fecha_creacion...

Aren't DSN's for ODBC-sources only?

You can use DSN-less connections however

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21009195.html

Interesting issue

SELECT TOP 10
S.id_solicitud, 
CONVERT(NCHAR(10), S.fecha_creacion, 120) AS fecha_creacion, 
S.nombre, 
S.clave_material,
IsNull(CONVERT(NCHAR(10), S.fecha_ini_pruebas, 120), 'N/A') AS fecha_ini_pruebas,
IsNull(CONVERT(NCHAR(10), S.fecha_fin_pruebas, 120), 'N/A') AS fecha_fin_pruebas,
IsNull(CONVERT(NCHAR(10), S.fecha_emision_reporte, 120), 'N/A') AS fecha_emision_reporte
FROM
dbo.tblSolsInstrum_Solicitudes S
WHERE
id_usuario = 'car6527'
ORDER BY
fecha_creacion...

The log continues to grow if there are any lasting open transactions.

Perhaps the SET implicit transaction option was modified?

Have you contacted the vendor on what settings were modified?