In this question it didn't matter, but in future can questions specify the format for dates. As different countries define date formats differently, and the American date format dates may...

NGSSoftware have a couple of good papers on sql injection which are worth a read, espically if you are putting a database on the web.

http://www.nextgenss.com/papers.html

I create all new sql 2000 servers as a 'domain user' which would fall into Category 3. So far I have only got a couple, but have had no problems,...

Also you need to stop and restart sql server after changing the audit status.

The alert works fine for me (scripted below, excluding notifications).

IF (SELECT COUNT(*) FROM msdb.dbo.sysalerts WHERE name...

You could create a new step in the job, which you send the other steps to on failure.

In that step you could use the xp_sendmail stored proc and send the...

I have found that tcp-ip has less connection issues, espically now with ms03-031 restricting named-pipe access (Q823492)

SQL does have an internal routine which it uses for encrypting and comparing login passwords.

You can see how it works by viewing the sp_password master stored procedure.

Note: There...

You could look at a 3rd party tool for encrypting the field eg http://www.xpcrypt.com/

Have you checked task manager on the server to make sure it is sql server using the cpu, rather than some other process.

You can use the 'SET IDENTITY_INSERT' command to allow you to insert values into the identity column

i.e.

SET IDENTITY_INSERT <table> ON

SET IDENTITY_INSERT <table> OFF

and the DBCC CHECKIDENT command to reseed the...

If you are running SQL 2000 sp2 or below, you can give the TargetServerRole (MSDB database).

In sp3/3a this all changed. I'm currently looking into this hence don't have an answer...

I have seem this once before, and I seem to remember that doing an autofix on those accounts (sp_change_users_login) sorted them out.

Try running the stored procedure

sp_change_users_login 'report'

in the database,...

Have you looked at the query plan in QA? (I presume you have developer edition of SQL)

Can you pin tables in memory in MSDE? May be worth checking

When you run the package manually (via EM) are you running it on the server itself or from a client pc?

DTS is a client application hence if you are running...

One other considerations is the HR software itself, is that secure?

I looked at a HR system this year which had an intranet frontend, where you could inject sql using the...