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 Rss

<< Newer    Items 21 to 29 of 29   
 

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,368 reads

Push FTP with SQL Server

DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.   Read more...
By Steve Jones 2005/07/01 (first published: 2001/11/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 36,515 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,377 reads

DBCC SQLPERF (Logspace) Reporting Internals

This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.   Read more...
By Additional Articles 2001/09/17 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,553 reads

Using Java to Encrypt Passwords

Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.   Read more...
By Les Smith 2001/07/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 13,398 reads

Encrypting Data With the Encrypt Function

One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.   Read more...
By Brian Knight 2006/05/29 (first published: 2001/07/17) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,997 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,406 reads

Undocumented T-SQL Tricks With Logs

An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.   Read more...
By Brian Knight 2001/06/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,401 reads

Quickly Enabling and Disabling Constraints and Triggers

In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.   Read more...
By Brian Knight 2001/05/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,052 reads
<< Newer    Items 21 to 29 of 29   
 
Tags
administration (13)    
counter (4)    
development (4)    
monitoring (4)    
nums (4)    
performance tuning (4)    
security (4)    
sqlinsider scripts (4)    
table of numbers (4)    
tally (4)    
arrays (3)    
delimited strings (3)    
parse (3)    
sql server 2005 (3)    
string manipulation (3)    
stored procedures (2)    
backup / restore (1)    
configuring (1)    
dts (1)    
miscellaneous (1)    
sql server 6.5 (1)    
strategies (1)    
system development life cycle (1)    
table (1)    
triggers (1)