Is the server using Mixed Mode authentication or Windows Only? If it's set for Windows Only, then the SA login is disabled.

-SQLBill

Also, the SMALLDATETIME and DATETIME data types DO NOT store the date in any 'normal' format.

This is from the BOL:

Values with the datetime data type are stored internally...

Look at dependancies......did something get changed where SQLServerAgent is dependant upon Outlook services starting first?

Can you try setting Outlook's services to be dependant upon SQLServerAgent service (I think that will...

Did you right click on the job and select view job history? Then did you click on show job steps and find the step that failed?

That job has several...

What was step 1? What was step 2?

There could be lots of reasons for this to happen, we just don't have enough information from you.

In Enterprise Manager, right click on...

OSQL is via the command line. I suggest looking it up in the BOL and you will find the syntax and all the commands there.

BOL=Books OnLine=Microsoft SQL Server's HELP

Installed...

Who says it's for one row only? Have you tried it?

This:

UPDATE mytable SET mycolumn=STUFF(STUFF(STUFF(LEFT(mycolumn,23),11,1 ,' '),14,1,':'),17,1,':')

should update the whole column.

-SQLBill

Ah...like I said, MORE information. You need a query tool that will work with more than one type of database, specifically SQL Server and DB2.

I don't know of any and...

How about:

IF DB_NAME() 'Master'

That way, instead of testing if the database IS Master, you are testing to see if it is NOT Master.

-SQLBill

You can check for the DB_ID (refer to the BOL) and that might help.

BUT why don't you just write your code to include the proper database? There are two...

How much data can you afford to lose? If you can afford to lose several hours or days worth of data - then don't do transaction log backups.

Only transaction log...

First, you need to supply some more information.

How is this query tool going to be used? Will it be used by the DBA, developers, or users?

Why not Query Analyzer?

What does...

Yes and no. You really need a third-party software such as Lumigent's LogExplorer (and there are others). But I believe most of them need to be installed before you need...

No. You have to restore the whole database. You can restore the database to another instance or as another name and then import the table into the original database.

-SQLBill

TIMESTAMP has nothing to do with the date and/or time. It is a 'versioning' value used by Microsoft SQL Server.

SQL Server has no idea how to interpret this value: 2006-05-11-16.29.43.882000

The...