Just guessing here, but I think if you had query governor enabled, you could take the value used for query governor and filter the events you listed on the 'duration'...

yes.

Users are not added to application roles.

http://msdn.microsoft.com/en-us/library/ms190998.aspx

It's a little unclear, without more information.

For example:

- Do you already know ahead of time what value phone will be updated to? If not, how is this determined?

- Are...

Also, I don't think you need:

where TABLE_NAME in (SELECT TABLE_NAME FROM Information_schema.TABLES)

You also need to make sure of two things:

1) You will need another statement FETCH NEXT FROM vend_cursor INTO @table_name, @column_name after your update statement and before the END statement....

Thanks, that'll help out

If I could take a stab here, I don't think he/she is saying that script they posted is broken - I went through a similar undertaking recently, and script will...

The proc is part of the dbo schema, so I think the owner is dbo, and dbo is associated with sa. That fact didn't make any difference though, because...

That was very helpful, thanks!! BOL to the rescue, again.

Ok, so it's TRUNCATE specifically, I was just generalizing with delete. So, for any SP to use TRUNCATE, if it isn't being executed by db_owner or ddladmin, would have...

ALZDBA (5/6/2008)

---

If this is a "single user" database, you can also use the db option "auto close". This way you will free up system resources, the db is still available...

Backup and restore should work fine.

For a case such as this, yes, it would be just login/logout. Again, I can't use it in this case, because I need this info by the end of...

Sorry about the wrong forum, almost all my work involves 2k5, so I'm used to going straight there.

Thanks for the info, though. Unfortunately going forward doesn't really help me...