Winiso can do that.... but I'm not sure it's impossible to burn an image of 750 mb.... I remember burning vcd of 800+ mb.

That would be something worth checking out.

Create table Activities

(

ActivityDate datetime (primary key clustered)

ActivityDescription varchar(100)

)

Then you can run this proc daily :

Delete from dbo.Activities where ActivityDate < DateAdd(M, -1, GetDate())

Is this simpler than your code?

Yup... but it's still one more tool in the box .

Like I said, but it's nice to know it's out there...

I don't know the yukon syntaxe... but basically it increments colid and reseeds to 1 everytime the id changes.

Maybe you could create a small app that connects with a special account that his in the db_ddladmin group, and that he could then call that proc (and only that...

check in the transfer options. I think you have a few options. You can either delete the data and reinsert, or append it... but I'm not sure what...

Thanx for sharing with us... too bad with can't be of more help.

Happy to hear we got through your programmers .

HTH.

What'S that supposed to mean Sharky??

menu_lvl2_id seems to be the primary key

menu_lvl2_item seems to be some book title or something like that.

I wouldn't expect him to want to update the whole table with the same...

Duplicate data or objects?

I'm no expert on this topic, but reading from the books online, I can't see anything about the recovery model..

Check this topic in the books online : CREATE DATABASE

Maybe that'll...

Now you're forcing me to post......

GO

Create proc dbo.MyProc @menu_lvl2_id as int, @menu_lvl2_item as varchar(50)

AS

SET NOCOUNT ON

UPDATE on_line_tutorial_menu_level2

SET menu_lvl2_item = @menu_lvl2_item

WHERE menu_lvl2_id = @menu_lvl2_id

SET NOCOUNT OFF

GO

EXEC dbo.MyProc 2, 'test'

Select * from...