DDL = Data definition language.

It looks something like this for a single table with everything scripted out :

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Order Details]') and...

This question is still not answered... and it really may simplify your work at this point!!!

You can delete it >> Edit post, then delete at the bottom right.

There's no need to resort to dynamic sql for this problem... but it might perform better (if all validations are done correctly)!

I'm not the expert on that matter.  I'll let someone else answer this one!

As the article states, it may.  But only to improve performance.  You'll have to test for your environement to see if lock escalations occur with a trace.  We can't do...

That would be a big oops... hope it'll be fixed in SP2.

Thanx for letting everyone know about this .

My version is compatible with 2000!!!!!!

Also this is what you are looking for :

/*

Ivica Masar

pso@vip.hr

*/

USE pubs

DECLARE @var1 VARCHAR(12)

DECLARE @var2 VARCHAR(30)

SET ROWCOUNT 17

SELECT @var1 = au_id, @var2 = au_lname FROM authors ORDER BY au_lname,...

Remove the w. in the 2 order by.

I can confirm the 6-7 but I don't have time to design all this.

Why are you not hireing a programmer to do this for you?

You can always copy all objects into a new acces mdb... That usually works.  I don't have anything automated however.

set rowcount @topnum

select...

set rowcount 0 --reset to unlimited

How do you think you got promoted to MVP???

Someone in high places is reading you .

I guess it deletes the corresponding rows in the dependancies table when you delete an object.  But the problem comes when you recreate objects, all dependancies are deleted, and only...