Thanx for all your replies but I think I wasn't too clear in my question.  I'm already well aware of the naming conventions and that this DB is breaking about...

Problem solved... I dropped the table and recreated it and it works like a charm again. Thanx for all your input.

I tried dropping the sp and recreating it like this but it still gives me the same error message.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

CREATE PROCEDURE [dbo].[DeleteADP] @PkADP as int

AS

SET NOCOUNT ON

if...

here's one function I like to use (works only with that have a Primary key):

CREATE FUNCTION [dbo].[CountALL] (@sTableName as varchar(255))

RETURNS int AS

BEGIN

--this is about...

This is just a hunche but have you tried :

select @query = N'SET ANSI_NULLS ON; GO; SET ANSI_WARNINGS ON; GO; select * from OPENROWSET(''MSDASQL'',''DRIVER={SQL Server};SERVER=127.0.0.1;UID=my_uname;PWD=my_pass'',''SELECT * FROM pubs.dbo.authors ORDER...

Yes everything works fine on the old server. the problem occurs only when I try running the queries on the new server when they have dates after the 12th...

I checked for the user who set the local setting and it's been set by the local admin. Collation type is the same on SERVEUR5 as SERVEUR4 (FRENCH_CI_AS)

Language is...