So what are you trying to accomplish with this?  Maybe we could point you in another direction if we had more details!

So what were you trying to accomplish with this code... and how can we help you with that?

Ya and judging by the lack of responses from other DBAS, I think it's right on the money.

If you even encounter problems with performances on that table or any other. ...

Yup, thanx for the info .

Check out the soundex and difference functions.  They were designed for such cases.

Why not do a backup of the db and restore on the other server?

What do you need to accomplish exactly?

You might want to put this in a view or procedure... cause I rarely saw a huge advantage or using a function like this (only assuming what you want to...

This would normally be handled client side but what the heck :

DECLARE @n AS Decimal(18,2)

SET @n = 150

SELECT RIGHT(REPLICATE('0', 13) + CONVERT(VARCHAR(15), @n), 13)

Diagrams don't enforce referential integrity.  Primary and foreign keys do that.

If you need a list of triggers, you can run this :

SELECT Object_name(parent_obj) AS TblName, Name AS TrName FROM...

yup.

Must have been fixed with a Service pack... can't say I installed of 'em on my dev machine !

On a dev box, it should be a big problem to repair.

You are develloping on a developpement box right???

SELECT * FROM master..syslogins WHERE sysadmin = 1

Check out the third line >> SysAdmin = 0

Maybe not, but then again, who here holds such critical information??

Something like this :

CREATE FUNCTION [dbo].[fnvwTempsTechniciens] (@DateDebut AS datetime, @DateFin AS datetime, @Technicien AS VARCHAR(50))  

RETURNS TABLE

       RETURN  (

                       SELECT  

                                         T.NoTech

                                       , TTR.Technicien1

                                       , BT.[Date]