It seems a bit awkward, but.. should this script only gather the data from all tables then, so that each table's data is saved as a plain ascii file?

This is pretty...

You should never use RETURN for other stuff than return (ie status) codes. If you decide to use return for returning stuff like rowcount, you no longer have the ability to...

I don't think there's any difference between TOP and SET ROWCOUNT in functionality.

If both are used, then ROWCOUNT overrides TOP if it's smaller.

Also, MS recommends TOP over ROWCOUNT to be...

Well, there are backups and there are backups.

Normally a 'backup' is the entire database, which also ensures you that all stuff inside stick together in a correct way. Won't a...

Remi,

he wants delete.. not drop

Though the idea is valid for deletes too

/Kenneth

The deleted and inserted tables are copies of the table the trigger is placed on that is accessible only from within a trigger. You use them just like any other...

Yes you can, you can give a pre-command and post-command and also a where clause to sp_MSforeachtable.

But... be aware that this proc is nothing else than a shorthand shortcut for...

I think you need to explain a little more about what you are trying to do. Could you give a very simple example describing the things you are wondering about?

/Kenneth

It's pretty much a case of eating the cake and still keeping it - can't have both..

If you want to limit the rows returned, then TOP or SET ROWCOUNT n...

Sometimes when you have 'creative' SQL and you find a 'feature' (ie a bug) that causes the server to AV, this message may pop up. Check the serverlogs for any...

You can only restore a database when there is noone in it, it must be empty from *all* users, including your own connection that does the restore.

Make sure that no...

Haven't actually tested it when there also is a ordered subquery in the select list, but the problem is just what the message says... You need to say 'TOP'.

April 25, 2006 at 5:34 am