I'm busy with a schoolproject and this is what I want to do:

I want to call for a stored procedure, say: MakeTable(year as int)
This procedure has to create some tables which have the year in it.
For Example 'Order_2005'
And off course I want it to do in 2006 as 'Order_2006'

How can this be done ????

You can use dynamic queries to execute..,

declare @test varchar(440)
SET @test = 'create table Test_table_t (a1 int)'
EXEC(@TEST)

@test is a string which can be used to append 'Order' + '2005' run the SQL

Om Prakash