I think it's something in the character representation of the password that causes QA to throw a column when in GRID mode.  When in column-aligned (CTRL-T) mode it lines up ok. ...

Allen,

Use varchar(nn) rather than char(nn) to reduce those gaps to 1 character.

To eliminate the "(10 row(s) affected)" message SET NOCOUNT ON.

To eliminate the colum headers:

a) from Query Analyzer uncheck the...

What happens if you run the stored proc (not the sql therein) manually a couple of times?

What happens if you invoke the scheduled job manually a couple of times?

Boy did MS bury that little gem in the rear-end of their documentation.  Makes me wonder if a 16-CPU computer with HTT will perform better than a 24-CPU with HTT...

Thanks from me too rootman.

.... then I think you're (or he's) stuck when it come to viewing the jobs through EM, because a lot of the SPs relied upon by EM actually check the...

If he is the owner of the jobs (as shown on each job's General tab) he should be able to see them thru Enterprise Manager.

Yes you can have AWE enabled without the /3GB switch.  The AWE setting is ignored (assumed OFF) if there's less than 3gb physical memory. 

However, with your 4gb and AWE enabled...

This is just an informational message meaning that the MSDTC service is

unavailable at the time when SQL Server is started. It won't result in any

problems with subsequent distributed transactions provided...

The trouble is that sev 15 errors are not event logged by default.  So setting up the alert for sev 15 doesn't achieve anything because the trigger for alerts is...

'tis hard to remember my SQL stuff.    However, I do recall being able to do a:

DBCC checktable('syslogs')

...when in the database in question, to correct...

The reserved and data figures are derived from data in the sysindexes table.  These are inconsistent.  Nothing to worry about though - it happens all the time - even in...

GaryA,

Look in the column "message" for job step 0.  It should contain something like:

The Job was invoked by Schedule nn

(if invoked by SQLAgent's schedule)

or

The Job was invoked by User xxxxxxxx

(if...

It could be that you've registered the same instance twice under EM with 2 different names.  When you think you're looking at server_TEST attributes it's really that of server_DEV.  If this is...

I'm working on the theory that it is SQL Agent initiating the jobs, based on the statement "Only deleting the schedule stops them". 

If the jobs were being initiated by some...