Amit Kumar

In: Computers and Technology

Submitted By aklazy
Words 876
Pages 4
HOMEWORK
CAP613T: DATABASE ADMINISTRATION

Q1. Profiles and accounts are managed in SQL Server 2008 using various stored procedures. Create profile and its accounts and manage them using those stored procedures and give the screen shots with results.
Ans.
sysmail_add_profile_sp
[pic]

sysmail_add_account_sp
[pic]

sysmail_add_profileaccount_sp
[pic]

sysmail_update_profile_sp
[pic]

sysmail_update_account_sp
[pic]

sysmail_update_profileaccount_sp
[pic]

Q2. Create Event Notification for updation and deletion of table.
Ans. Creating Event Notification for updation:

CREATE EVENT NOTIFICATION NotifyUpdateEvents
ON DATABASE
FOR UPDATE_TABLE
TO SERVICE '//AdventureWorks/EventNotificationService' , 'current database'
GO

Creating Event Notification for deletion:

CREATE EVENT NOTIFICATION NotifyDeleteEvents
ON DATABASE
FOR DELETE_TABLE
TO SERVICE '//AdventureWorks/EventNotificationService' , 'current database'
GO

Q3 “A common configuration is to use the same account for both SQL Server Service and SQL Server Agent Service” comment. Are there some extra conditions or rights in windows operating system for the accounts used by SQL Server Agent, if yes. Discuss them?
Ans.
• Adjust memory quotas for a process: This privilege determines who can change the maximum memory that can be consumed by a process. This privilege is useful for system tuning, but it can be misused, for example, in a denial-of-service attack.

• Act as part of the operating system: This user right allows a process to impersonate any user without authentication. The process can therefore gain access to the same local resources as that user. Processes that require this privilege should use the LocalSystem account, which already includes this privilege, rather than using a separate user account with this…...

Similar Documents

Amit

...VODAFONE Vodafone is a world leading mobile telecommunications company. Vodafone provides a wide range of communication services, including voice calls, SMS text messaging, MMS picture and video messaging, internet access and other data services. The group has 221 million direct customers including private consumers and corporate customers in diverse markets around the world. Governance Overall responsibility for corporate responsibility (CR)/sustainability lies with Vodafone’s Group Executive Committee (ExCo). The ExCo is chaired by the Chief Executive Officer (CEO) and consists of two CEOs from Vodafone’s operating business units – Europe and Emerging Markets (Asia-Pacific, America, Eastern Europe and Africa), as well as the Group Corporate Affairs Director, CFO, Chief Technology Director, Group Strategy and New Business Director, Group General Counsel and Corporate Secretary, Chief Executive of Global Business Development, Chief Marketing Officer and Group HR Director. CR performance is regularly discussed at ExCo and once a year at Vodafone's main Board. The Group Corporate Affairs Director is the ExCo member with responsibility for CR, and Vodafone’s Group Corporate Responsibility Director reports to the Group Corporate Affairs Director, as well as leading the Group CR team. The Group CR team works with local operating companies and Group operational functions to develop policies on CR issues. Additional Group resources are also dedicated to key issues, such as radio......

Words: 3973 - Pages: 16

Given by Borun Kumar

...An Overview on Multinational Corporations      INTRODUCTION Multinational corporations (MNCs) are firms that engage in some form of international business. Their managers conduct international financial management which involves international investing and financing decisions that are intended to maximize the value of the MNC. Management is motivated to achieve a number of goals and objectives, some of which conflict with each other. However, the commonly accepted objective of an MNC is to maximize stockholder wealth on a global basis, as reflected by stock price.  Managers of an MNC may make decisions that conflict with the firm’s goal to maximize shareholder wealth. This conflict of goals between firm’s managers and shareholders’ is often referred to as the agency problem. For the firm to achieve its goals, it needs to put in place mechanism for control of agency problem. MNCs are recognized as the main actors of e international business, international business financing and global economies. According to Goshen and Bartlett, MNC is a firm that has substantial direct investment in foreign countries that it actively manages.2 the value of their sales in host countries overpasses the value of trade (imports and exports) in today’s World economy. Multinational companies attracted scientific and public attention from the moment of their appearance, and especially from the beginning of their intensive growth (during the 1960s). There are many interesting and important......

Words: 8380 - Pages: 34

Amit

...1/11/13 MAT Registration Form Feb.-2013 M A T R E G IS T R A T IO N F O R M ( F e b - 2 0 1 3 ) * R e gist ra t ion/F orm No. *624480* C hoice of Te st Ta king * O pt ion * Te st C e nt re C it y Offline (Pa pe r Ba s e d T e s t ) C hoice I. 406-MA DHYA PR A DESH: INDO R E C hoice II. 404-MA DHYA PR A DESH: BHO PA L Per s onal Par t icular s * Na me of C a ndida t e * Da t e of Birt h * Na t iona lit y A ddre ss f or * C ommunica t ion Mr. A MIT KUMA R J ESA NI 14-J un-1992 India n SA TYA M TR A DER S KILA C HO WK * C it y Ema il-ID C ont a ct No. DA TIA * Pin C ode A MIT. J ESA NI92@GMA IL. C O M 07522233535 Mobile No. 475661 9926296737 * Ge nde r * C a t e gory Ma le GEN Qualificat ions & Exper ience Det ails * St a t us of De gre e * Pe rce nt a ge a t 10+2 * St re a m/Discipline in De gre e Ha v e y ou e a rlie r a ppe a re d in A PPEA R ING 75 C O MMER C E GMA T : * Pe rce nt a ge a t De gre e Ex pe rie nce in Mont hs C A T : Ye s XA T : Ye s Mode of Pay ment Tra nsa ct ion No. /R e ce ipt * No. De cla ra t ion - - > Cr edit / Debit Car d 2000106705 301204416724 * Pa y me nt Da t e 11-1-2013 I he re by a f f irm t ha t t he pa rt icula rs f ille d by me in t his f orm a re t rue a nd corre ct . I ha v e re a d a nd unde rst ood t he t e rms a nd condit ions of t he t e st a nd a gre e t o a bide by t hose . R e gist ra t ion/F orm No. 624480 Pla ce Da t e Signa t ure of A pplica nt (To be signe d prior t o de spa t ch) Kindly s a v e...

Words: 1068 - Pages: 5

Rajnandan Kumar

...The Dashman Company Case: Summary The Dashman Company was a large decentralized concern making many types of equipment for the armed forces of the United States. Late in 1940 the company faced increasing difficulty in securing certain essential raw materials. So Mr. Manson, the company’s president, appointed an experienced purchasing executive, Mr. Post as vice president in charge of purchasing to improve the situation. But there seems to be no improvement Situation: In this case Mr. Post has recently been hired as the VP of the purchasing department. Post decides to centralize a part of the system by announcing through letters to the purchase executives that all the purchases made over $10000 should be cleared with the head office and that he is notified about contracts that are being negotiated at least 1 week in advance. The plant managers express support and co-ordination but the head office doesn’t receive any notice from any plant in this period. Problems: The people in the organization have taken the letter very casually as they feel that it is useless to follow what the letter instructs them to and there could be ‘n’ numbers of reasons for this. 1. The centralization announced just 3 weeks before the peak buying season. 2. Mr. Post not being taken seriously as a result the heads of purchases of the units were not in effect made a part of the decision making process which could have reduced the......

Words: 672 - Pages: 3

C Curriculum Vitae | [Pic] | Sujan Kumar Sahu Mobile: - 7504720050 E-Mail Id: - Sujansahu92@Gmail.Com ----------------------------------------------------------------------------------------------------------------------

...CURRICULUM VITAE | [pic] | Sujan Kumar Sahu Mobile: - 7504720050 E-mail id: - sujansahu92@gmail.com -------------------------------------------------------------------------------------------------------------------------- Career Objective: - To work in a cooperative environment which offer me the opportunity to use my technical skill for better development of my company and myself in the IT sector. Educational Qualification:-   Technical Skills:- Elementary knowledge over C and C++ Digital Electronics circuit Summer Training:- Organization – Central Tool Room and Training Centre, BBSR Duration – 01.08.2011 to 30.08.2011 Description – Very Large Scale Integrations Design (VLSI) Projects Undergone:- Title of the project –Home Automation Using GSM and RFID Duration – 01.02.2013 to 15.05.2013 Team Size – 6 members Description - The main aim of the project is to control the home appliances which are o operated with GSM module. Additional Qualification/Achievements:- • Completed spoken English course in VETA • Won second prize at Block level quiz competition • Awarded for school scholarship in NRTS Exam Personal Information:- • Father’s Name : Mr. Pranabandhu Sahu • Mother’s Name : Mrs. Shantilata Sahu • Date of Birth : 26th March,1992 • Gender : Male • Language skills ...

Words: 284 - Pages: 2

Commissioner of Wealth Tax, Meerut vs. Sharvan Kumar Swarup & Sons

...Commissioner Of Wealth Tax, ... vs Sharvan Kumar Swarup & Sons on 22 September, 1994 Supreme Court of India Supreme Court of India Commissioner Of Wealth Tax, ... vs Sharvan Kumar Swarup & Sons on 22 September, 1994 Equivalent citations: 1995 ECR 425 SC, 1994 210 ITR 886 SC Author: V . M.N. Bench: M Venkatachaliah, S Agrawal JUDGMENT M.N. Venkatachaliah, CJ. 1. In these appeals and special leave petitions brought up by the Revenue the short but interesting question that arises is whether Rule 1BB of the Wealth Tax Rules, 1957 is a provision which affects and alters the substantive rights or is merely procedural. The further sequential and cognate question is whether the Rule is attracted to all proceedings pending at its enactment. The said Rule 1BB concerns the mode of valuation of house-property wholly or mainly used for residential purposes, for the purposes of ascertaining the net wealth under the Wealth Tax Act. 1957. 2. Section 3 of the Wealth Tax Act is the charging section. It seeks to bring to charge for every assessment year the net wealth on the corresponding valuation date of every individual, Hindu undivided family and company. The expression "net wealth" is defined in Section 2(m) of the Act. Section 2(q) defines the "valuation date". Section 4 enumerates the assets to be included in computing 'net-wealth'. Sections 5 and 6 exempts certain assets in India and outside from being included in computing the net wealth. 3. Section 7 - and this provision is of......

Words: 3413 - Pages: 14

Mr Nilesh Kumar

...1 72-9990302 16/12/2013 16/12/2013 727230262/240913 7,763.82 2 72-9990303 16/12/2013 16/12/2013 727230364/261013 7,763.82 3 72-9990304 16/12/2013 16/12/2013 727230090/140813 17,446.15 4 72-9990305 16/12/2013 16/12/2013 N/A 7,461.29 5 72-9990306 16/12/2013 16/12/2013 727230262/240913 7,461.29 6 72-9990307 16/12/2013 16/12/2013 727230262/240913 7,461.29 7 72-9990308 16/12/2013 16/12/2013 727230262/240913 7,461.29 8 72-9990309 16/12/2013 16/12/2013 727230262/240913 7,461.29 9 72-9990310 16/12/2013 16/12/2013 727230262/240913 7,461.29 10 72-9990311 16/12/2013 16/12/2013 727230262/240913 7,461.29 11 72-9990312 16/12/2013 16/12/2013 727230090/140813 9,206.10 12 72-9990313 16/12/2013 16/12/2013 727230090/140813 9,206.10 13 72-9990314 16/12/2013 16/12/2013 727230364/261013 14,979.35 14 72-9990315 16/12/2013 16/12/2013 727230364/261013 14,979.35 15 72-9990316 16/12/2013 16/12/2013 727230090/140813 14,979.35 16 72-9990317 16/12/2013 16/12/2013 727230189/090913 7,708.49 17 72-9990321 16/12/2013 16/12/2013 727230364/261013 6,165.23 18 72-9990322 16/12/2013 16/12/2013 727230364/261013 6,165.23 19 72-9990323 16/12/2013 16/12/2013 727230364/261013 6,165.23 20 72-9990324 16/12/2013 16/12/2013 727230364/261013 6,165.23 21 72-9990325 16/12/2013 16/12/2013 727230364/261013 6,165.23 22 72-9990326 16/12/2013 16/12/2013 727230364/261013 6,165.23 23 72-9990327 16/12/2013 16/12/2013 727230364/261013 6,165.23 24 72-9990328 16/12/2013 16/12/2013......

Words: 1187 - Pages: 5

Pramod Kumar

...Strategic Alliances: Collaboration with Your Competitors--and Win1 Collaboration is a strategic alliance typically between two firms with the goal of providing mutual benefit for each firm. Collaborating with your competitors is like a double-edged sword. Sharing between firms is a smart strategy as long as the relationship is give-and-take and is one that will benefit both parties without compromising each of the firm’s competitive position in the industry. Firms must be careful in what information is shared across this delicate communication trail. To borrow a line from the Godfather, "keep your friends close, but your enemies closer". This article's discussion of competitive collaboration lends itself to the idea that learning and studying your enemy pays. Although are infinite possibilities arising from collaborations, be wary of the risk of sharing knowledge with the enemy when it is core to your firm's competitive competencies. Types of competitive collaboration 1. Joint Ventures 2. Outsourcing agreements 3. Product Licensing 4. Cooperative research The study of 15 mergers of three major types: four intra-European alliances, two EuropeanJapanese alliances, and seven U.S.-Japanese alliances found that collaboration is something often used by successful businesses. Alliances between Asian companies and Western rivals seem to work against the Western partner. Collaboration is competition in a different form. Companies have to enter collaborations knowing that competition......

Words: 1921 - Pages: 8

Rohit Kumar

...Union Budget 2014-15 10th July, 2014 Union Budget 2014-15 Budget 2014-15 Holistic Plan of Action In comparison to the less than ordinary and unimaginative budgetary proposals of yester years, Modi’s maiden budget comes as a welcome change from the norm. The proposals and reforms suggested in the Union Budget 2014-15 are ground breaking, specific with a good measure of thought & common sense and vastly catered for holistic growth of the economy. The challenging circumstances of a slowing economy, soaring energy prices, inflation, fiscal and current account deficits do not provide adequate leeway to maneuver and hit the path of high growth. Yet the Budget provides a comprehensive plan and directional footprint towards overcoming these hurdles to sustainable growth of 7-8% over the next few years along with providing macro economic stability, lowered inflation, realistic fiscal health targeting and a manageable current account deficit. Country is in no mood to suffer unemployment & apathetic governance 10th July, 2014 Union Budget 2014-15 Budget 2014-15 Holistic Plan of Action The Finance Minister while presenting the budget takes cognizance of the fact that decisive action to fuel growth without populism is the need of the hour. And that resources for developmental expenditure cannot be raised at the cost of burdening the future generations with the legacy of debt. He goes on to emphasize the need to mobilize resources through both tax and non-tax...

Words: 6597 - Pages: 27

Amit Kumar

...BRIC Spotlight Report ____________________________________________________________ _________________ Automobiles Sector in India: Fast Growth October 2010  Fast Facts India is the second fastest growing automobile market in the world after China. Passenger vehicle production during the period April 2010 to August 2010 increased by nearly a third from a year ago. For the year ending March 2011, passenger vehicle output is expected to exceed 2.5 million. India is emerging as a major production base for small cars, with output expected to reach 3 million units by 2016. The country is building a reputation in designing and manufacturing low cost cars. Production of trucks and buses increased by nearly 66% between April 2010 and Aug 2010. An expanding highway network and overall economic growth is pushing up demand. India is the second largest market for motorcycles worldwide. Output of over 4.5 million units was registered during April 2010 – Aug 2010, marking growth of over 27%. The auto parts industry is also scaling up, as global car manufacturers are increasing their component sourcing from India, due to cost and engineering competencies. Competition is intense as most global firms have entered the market. O nly three decades back, Indian car buyers had just two models to choose from. Both were local reproductions of European models that had disappeared from the western markets soon after World War II. Irrespective of market demand, manufacturing capacity......

Words: 3497 - Pages: 14

Amit

...Finance case study annuity etc.? i just started to learn finance. so, i need the model answer so that i can refer to it. here is the case Paul Murray* Paul Murray would soon graduate from business school with his MBA. He had accepted a fine job offer. Paul’s wife, Nancy, was an attorney with a local firm specializing in corporate law. Paul and Nancy were expecting their first child a few months after Paul’s graduation. With the experience of paying for their own graduate educations fresh in their minds, Paul and Nancy recognized that they would have to plan early to accumulate enough money to send their child through four years of college. Paul wanted to accumulate a fund equal to four times the first year’s tuition, room, and board by the time his child entered college. Paul and Nancy assumed that these fees might increase, perhaps annually, through the four years of college. However, if they invested the funds appropriately, the investments would yield enough to cover the increase in fees through the four years of college. Ideally, Paul and Nancy wanted their child to be able to choose among an array of public or private colleges with good academic reputations. A recent newspaper article had indicated that the average tuition, room, and board at private four-year institutions was about $15,000 per year. They felt that if their child were entering college this coming fall, $18,000 per year for tuition, room, and board would provide the range of choice they......

Words: 423 - Pages: 2

Bsl Kumar Nopal Case

...it got to the destination, it was damaged(in transit). Shared imaging filed its claim for insurance with St. Paul guardian, who brought this action against neuromed for damages. Neuromed argues case should be dismissed bcs it it not liable under german laws. Analysis: the US court, interpreting the german law, held that a delivery term in a sales contract(CIF) should be defined according to Incoterms, unless it is said otherwise. Under the CISG, merchants impliedly agree to trade usages of which they should hsve know. Incoterms have become trade usage, applicable to this contract. The risk of loss passed to the buyer at the port of shipment. Kumar v. Nopal Kumar sold tvs to Nava under CIF terms. Kumar delivered the trailer with the goods to its freight forwarder maduro. Trailer was stolen . kumar failed to obtain the insurance. Kumar claims risk passed to Nava. Analysis: under CIF terms, if the seller fails to obtain marine cargo insurance on behalf of the buyer, the risk of loss remains with the seller, who becomes a self-insurer of the property. CASE: El Al Israel Airlines v. Tseng Tseng had a ticket to fly with El Al from NY to Tel Aviv. She was questioned by a guard who took her for further inspection. She argues that she suffer assault and false imprisonment under NY law. Issue: in case the convention doesn’t allow recoveries, is the passenger able to maintain action for damages under a different source of law? Analysis: under the Warsaw Convention, a passenger......

Words: 737 - Pages: 3

Amit

...The kabiliwala The cabuliwallah is from Kabul. His real name is Abdur Rahman. He works as a peddler in India. He goes to Kabul once a year to visit his wife and little daughter. In the course of selling goods, once he reaches to the house of writer, Rabindranath Tagore. Then his five years daughter, Mini calls him ‘Cabuliwallah! A Cabuliwallah’. When Cabuliwallah goes to visit Mini she is afraid because he is wearing loose solid clothes and a tall turban. He looks gigantic. When the writer knows that Mini is afraid, he introduces her with him. The Cabuliwallah gives her some nuts and raisins. Mini becomes happy from next day, the Cabuliwallah often visits her and he gives her something to eat. They crack looks and laugh and enjoy. They also feel comfortable in the company each other. The writer likes their friendship. But Mini’s mother doesn’t like it. She thinks that the peddler like Cabuliwallah can be child lifter. However, Mini and the Cabuliwallah becomes intimate friend. The Cabuliwallah sells seasonal goods. Once he sells a Rampuri shawl to a customer on credit. He asks him for the money many times but he doesn’t pay. At last he denies buying the shawl. The Cabuliwallah becomes very angry and stabs the customer. Then he is arrested by police and taken him to the jail. He is jailed for eight years. When he is freed from jail at first he goes to visit Mini surprisingly. It is the wedding day and he isn’t allowed to visit her. When he shows the finger of a piece of......

Words: 971 - Pages: 4

Kumar

...Promoting Evidence-Based Education: The Role of Practitioners Round table presented at the British Educational Research Association Conference, Cardiff University, 7-10 September 2000 Robert Coe, Carol Fitz-Gibbon and Peter Tymms Curriculum, Evaluation and Management Centre, Durham University Mountjoy Research Centre 4, Stockton Road, Durham DH1 3UZ Tel: 0191 374 4504; Fax: 0191 374 1900; Email: r.j.coe@dur.ac.uk http://www.cem.dur.ac.uk/ebeuk Abstract A number of recent initiatives from Durham University’s Curriculum, Evaluation and Management Centre have sought to involve teachers in creating, accessing and applying evidence about what works in their practice. The ‘gold-standard’ of evidence in this context is taken to be multiple replications of small scale, randomised controlled trials of feasible interventions in real-life settings. The aims, form and progress of these initiatives will be reported, and a number of questions will be raised: What do we mean by ‘Evidence-Based Education’? How can it best be promoted? What kinds of research can teachers do? How good can it be? Can it genuinely contribute to knowledge? Is it a distraction or enhancement of teachers’ core role? How do traditional models of Action Research fit with this approach? Is there an existing body of knowledge that can inform practice? How can teachers gain access to it? Under what conditions might such knowledge have an impact on......

Words: 4725 - Pages: 19

Pintu Kumar Maji

...CURRICULUM VITAE Dr. Pintu Kumar Maji Post-Doctoral Fellow, ICSSR, New Delhi, India Assistant Professor and Head Department of Education, Sarsuna College (Affiliated to University of Calcutta) 4/HB/A, Ho-Chi-Minh Sarani, Sarsuna Upanagari, Kolkata – 700 061, West Bengal, India Guest Faculty Department of Education, Rabindra Bharati University, Kolkata-700 050 E-mail: pkm.edu@rediffmail.com Phone: +91 9836622451(M), +91 033-2452-3699/4104 (Office) Fax: 033-2473-7365 Website: http://orcid.org/0000-0003-2041-2603, http://www.hindawi.com/50378302/ www.sarsunacollege.ac.in ======================================================================= PERSONAL DETAILS Date and Place of Birth : 4th March, 1980 Kuldanga, Panchla, Howrah, West Bengal-711302, India Nationality : Indian Cast : General Permanent address : Vill. & P.O.-Kuldanga, Via-Andul, Mouri, P.S.-Panchla, Dist.-Howrah, Pin-711302, West Bengal, India Corresponding Address : Dr. Pintu Kumar Maji, C/O- Sri Lakshmi Kanta Maji, Vill &P.O.-Kuldanga, Via-Andul, Mouri, P.S.-Panchla, Dist.-Howrah, Pin-711302, West Bengal, India ACADEMIC QUALIFICATION 2013 Doctor of Philosophy (Ph. D.). Major: Education. Title: “A Study of the Locus of Control, Ecological Value and Environment Related Behaviour amongst Visually Impaired Students in West Bengal”. Area: Environmental Education and Special Education. Department of Education, University of Calcutta, West Bengal, India 2007 Master of Philosophy (M.......

Words: 4650 - Pages: 19

Lindsay Wagner | Bez skazy / Nip/Tuck | Linen Cloth