SQL 2005 to SQL 2000

[Dejan]

Can I convert, export or enything else to do to make my SQL database to keep alll Stored procedures, diagrams tables etc...?

 

[TechGnome]

Maybe if you provide a clearer picture of what you are trying to do.... there's a number of things that can be done..

=tg

 

[Paszt]

If I understand your question correctly, you are attempting to convert an SQL 2005 database to SQL 2000. Is that correct?

One option is to generate scripts using SQL Server Management Studio (an express version is also available).
The steps would be: generate the scripts (be sure to set the 'Script for Server Version' option to 'SQL Server 2000'); create a new SQL 2000 database; execute the scripts on the SQL 2000 database.