January 14, 2005
java ssl certificate import
using the keytool command, i made a certificate request. there were some interesting quirks importing the certificate, of course not well documented.
the first note, is to always always always specify the keystore in all the commands, otherwise the command just references the keystore (or just creates a new keystore) in the users home directory (windows or unix).
read more...January 11, 2005
DTS & sql agent ownership problem
i'm having trouble with a sql job calling a dts package. the dts package runs fine, but does not run when executed from a job (my domain account is set as owner of the job, and i'm a system admin as well - but the sql server agent is a local account not a domain account)
ordinarily that would be fine - i'm the owner of the job so when the agent executes the job it should use the security context of my account. however i believe there is an additional twist to that, related to DTS packages. here's the catch . . .
read more...DTS returns success even when step fails
I have a DTS package that calls another DTS package. For the first time, I noticed behavior where the subordinate package fails, but the calling package did not error and stop processing (all using the 'continue on success' workflow properties).
unlike other packages that do this properly without issue, i went ahead checked the "fail package on first error" property under error handling on the subordinate package - then the calling package stopped on that step as desired.
my theory is that the type of error causing the subordinate package to stop was not reported as an error in the same manner to the calling package - that's a feature or bug i'm not sure ?!
read more...January 10, 2005
sql server error 7405
BUG: Can't Use SQL Enterprise Manager to Create Stored Procedures Containing Linked Server Objects
Applies to: Microsoft SQL Server 2000 Standard Edition
Article ID : 296769
Last Review : October 3, 2003
Revision : 1.0
This article was previously published under MSKB: Q296769