How about simply modifying sp_password? You could insert logic to keep track of when a login's password was changed in a separate table. Then have a job run nightly that...

You'll just want ActivePerl. Here is a short "Getting Started" guide I put together:

http://www.truthsolutions.com/perl/getting_started.htm

As far as the DTS package, when ActivePerl is installed, you'll see an option for "PerlScript Language"...

You might take a look at either HFNetChk or the Microsoft Baseline Security Analyzer, both available from Microsoft's Security site at http://www.microsoft.com/security/ and they should give you the info you...

The reason I use Perl is because the Win32::EventLog wraps the Windows API calls for the Event Log. It was the simplest solution for me. Here's an example of a...

If you have PerlScript installed, you can use the Win32::EventLog package to interrogate the event log. PerScript is considered an ActiveX script like VBScript and JScript. PerlScript is part of...

MKS Toolkit is a Unix sub-kernel which installs on your system, much the same way as Microsoft's Interix. I don't believe MKS Toolkit has any native interfaces with SQL Server....

Here are the requirements for the various services should you choose to use non-administrator level accounts for them:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If you are just interested in catching the error itself (no details other than error 8152 has happened), you can setup an alert for error #8152 using SQL Server Agent....

You'll probably want to look at making the Oracle database a linked server. If you have SQL code that can run entirely on the Oracle side, take a look at...

I think the combination of a link as suggested by Antares and leaving the time at 5 days would work. Crticial threads should be seen by the first mechanism and...

I would shrink the time interval. If someone has a serious issue, 5 days may be a long time to wait. What about either 24 or 48 hours?

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Based on the level of some masters degrees with respect to Information Systems, I don't value this degree very highly, either. It really depends on the school. Certainly the degree...

Simple way to prove your argument:

(1) on a client, configure an alias using Client Network Utility to a known server. Ensure the netlib is TCP/IP. Choose a name like OnlyViaTCP,...

Who controls the database server?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Or if you are a brave soul you can query against sysprocesses, though sp_who is what Microsoft will recommend since sp_who should return the same results, regardless if Microsoft makes...