There are scenarios in which an email address for a particular user profile is or has become empty. Like when someone leaves the company. For SharePoint alerts this will lead to undeliverable mails. As far as I know there is no simple way of identifying these alerts. My colleague Kees Pijnenburg has written a nice procedure for determining all subscriptions for a particular email address across make pleased databases which I wanted to share with you. Btw. I would never suggest to use speech to really modify SharePoint make pleased databases.
---- Determine if there are subscriptions for a particular-- email address in any of the make pleased databases--declare @mail as varchar(128)declare @cmd as varchar(2000)
set @mail = 'address@company.com'set @cmd = 'select ''?'' as DBName, ''ImmedSubscriptions'' as Source, count(*) as Frequencyfrom ?..ImmedSubscriptionswhere UserEmail = ''' + @mail + '''unionselect ''?'' as DBName, ''SchedSubscriptions'' as Source, count(*) as Frequencyfrom ?..SchedSubscriptionswhere UserEmail = ''' + @mail + ''''
exec sp_MSforeachdb @cmd
Check it out:Serve’s Sharepoint Blog
milwaukee 18 votl lithium battery kamasutra dotted condoms non prescription diovan heart palpatations h-pylori treatment and glucotrol name brand for paroxetine hcl tab cordarone x200 testosterone human growth hormone hgh hydrea heartbeat take clomid without a prescription scotish clothing fo the stuart calan doxepin for itching femara pre-pregnancy concomittant use of heparin and coumadin what do men use cleocin for flouroquinolone drugs doxycycline hydrea heartbeat cipro m51 advair diskus rnh 50 3.7v lithium battery discharge characteristic grug indocin order discount pravachol free shipping imuran and pancytopenia reaction zyrtec dark stools w augmentin
ticlopidine stent 200mg late thrombosis [url=http://yieldingkook40.pbworks.com/]edward cipro[/url] by guaifenesin with pseudoephedrine [url=http://wonderfuldairy5.pbworks.com/]cancer clomid[/url] stop taking singulair [url=http://wastefulreligio.pbworks.com/]leukeran pet medication[/url] incorporation ibuprofen and acetaminophen [url=http://quickupset55.pbworks.com/]lexapro and gabba[/url] lithium 3 pin pc mount [url=http://laboredalley10.pbworks.com/]brand amoxil without rx[/url] herbal testosterone blocker [url=http://jaggedfacsimile.pbworks.com/]side effects of biaxin with caffeine[/url] triamcinolone acetonide hemroids [url=http://jollyleash70.pbworks.com/]elavil and diabetic neuropathy[/url] detrol la and headaches [url=http://tenuousreceptac.pbworks.com/]buy colchicine generic[/url] blood tests with aggrenox [url=http://tightlatch42.pbworks.com/]hold hair loss cream online[/url] glucovance hair loss [url=http://nappyreasoning8.pbworks.com/]cheap acticin online prescription[/url]