Since most DBA tools worth their salt seperate Sprocs, Views, Functions, and Tables there's no need to prefix them.

I name tables plurally "Users"/"Customers" and name Sprocs using German syntax: Noun-Verb ("UserGet", "CustomersList", "AccountDelete")

I don't know why Verb-Noun is so popular when it's better to use Noun-Verb.

EDIT: And as Sven pointed out, often you're limited to one database so I prefix my tables and sprocs with some sort of application-specific identifier.