October 23, 2009 at 11:34 am
Hi
We have an stored procedures , which runs masking of data. In that s tored procedures the masking information comes to a mail to myself and my dba. and the out put is all clumsy.
so my dba wants the output to be in a batch file
and output should come out like
start masking
table
-------------------
data
----------------------
second table
Can anyone please help how to write a batch file to get an email in this manner .
October 23, 2009 at 12:07 pm
I'm not sure what you're asking for. What precisely do you mean by "masking"? (Sorry, it brings up images of paiting rooms for me.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 23, 2009 at 12:45 pm
>>Can anyone please help how to write a batch file to get an email in this manner .
You can use SQLCMD from a batch file (.bat) which will then run a script (.sql) to generate your masking email.
http://www.sqlservercentral.com/articles/SS2K5+-+Tools/introductiontosqlcmd/2224/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply