Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, T-SQL, Advanced Querying, Monitoring Rss

   Items 1 to 5 of 5   
 

Using Xp_sendmail With the Recipients Generated From a Query

Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.   Read more...
By Kunal Das 2005/02/18 (first published: 2001/07/16) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 23,400 reads

The SQL Server Black Box

Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.   Read more...
By Brian Knight 2003/04/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,279 reads

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.  Read more...
By Randy Dyess 2002/04/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 10,363 reads

Executing a script from SQL Server

Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.   Read more...
By Steve Jones 2001/10/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,371 reads

Using Xp_sendmail With the Recipients Generated From a Query

Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.   Read more...
By Kunal Das 2005/02/18 (first published: 2001/07/16) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 23,400 reads
   Items 1 to 5 of 5   
 
Tags
administration (2)    
configuring (1)    
security (1)