Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

add the internal email field to the view Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 4:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:38 PM
Points: 492, Visits: 1,885
How to add add the internal email field to the view on a database ?
Post #1521811
Posted Wednesday, December 11, 2013 5:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:29 PM
Points: 12,741, Visits: 31,053
ramyours2003 (12/11/2013)
How to add add the internal email field to the view on a database ?


i'm lost in the terminology here: what's "the internal email field"?
my first guess would be the email address for the current default profile in dbmail in the msdb database?

to grab that, the users calling the view would need access to the msdb database, so i don't think that's what you are after.




Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1521851
Posted Wednesday, December 11, 2013 8:44 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:38 PM
Points: 492, Visits: 1,885
Hi,

its not the db mail i wanted to add\update a value in view
Post #1521939
Posted Wednesday, December 11, 2013 8:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 11,949, Visits: 10,982
ramyours2003 (12/11/2013)
Hi,

its not the db mail i wanted to add\update a value in view



alter YourView as
select [OriginalColumns], YourNewColumn
from ...



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1521945
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse