>>No, SQL Server 2005 manages SQL Server 2000 databases great, just don't forget to set your database compatibility to 80 (if I remember well).
>All code written in SQL Server 2000 T-SQL is SQL Server 2005 compatible.
>>
>Borislav
>Where do I set that compatibility? In VFP of SQL Server?
On SQL Server.
USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'YourDatabaseNameHere', @new_cmptlevel=80
GO
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
