• I feel that using forms of hungarian notation is generally a mistake.  As has been previously stated, when changes occur the prefixes are generally not changed or require mass search and replaces. 

    Secondly, using any type of SQL tool, all the type of objects are grouped together by type anyway, all the stored procedures are together, the views etc.  By prefacing all your stored procedures with sp it just add noise to the left when looking for a procedure in these lists.

    Thirdly, based on the context of an object it is usually obvious what it is:

    exec Customer  --a sproc

    select * from Customer -- a view or table

    select * from dbo.Customer() -- a function