SQL LEARNERS

Saturday, 4 February 2012

SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
Posted by v.vinoth at 02:03 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Configure Database Mail

To KILL All the process in the current databases


ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE mydb SET MULTI_USER
GO
Posted by v.vinoth at 01:58 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Process
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Followers

Blog Archive

  • ►  2013 (1)
    • ►  February (1)
  • ▼  2012 (13)
    • ►  September (1)
    • ►  August (2)
    • ►  July (3)
    • ►  June (2)
    • ►  May (2)
    • ►  April (1)
    • ▼  February (2)
      • SQL SERVER – 2008 – Configure Database Mail – Send...
      • To KILL All the process in the current databases
  • ►  2011 (13)
    • ►  December (2)
    • ►  November (8)
    • ►  October (3)

About Me

v.vinoth
View my complete profile

My Blog List

  • Dot Net Sample Codings
    How to pass parameter to partial view and capture the value(s) in partial view
    8 years ago
  • SQL TRACKER
    find out the continuous date or single date using sql server
    12 years ago
  • RamuGblogs
    Search content in which SP
    13 years ago
Travel theme. Powered by Blogger.