SELECT    convert(char,datew,103)

FROM         Table1

order by datew desc

This will give you the desired result.

Just a shot in the dark....Do you use SET NOCOUNT ON in your SP?

Have you tried to set the Reporting options in the Database Maintenance Plan. Here you will get detailed error messages.

HI,

I have had this problem before and my findings were that it occurs when your database maintenance plan is trying to create a transactionlog backup of a database which is...

Please send me the code where the user sets the date. What is the datatype in SQL Server?

I don't think I can help u but what is the data type of the column where the date is stored.

What is the Regional short date format on the server hosting...

What data type are you using to store the unicode nchar, nvarchar, or ntext?

Give me a sample of one of the entries... 

declare @num int,

@charstr char(6)

set @num = 748

set @charstr ='000' + convert(char,@num)

print @charstr

If there is a possibility of a large number use the len function to determine if you will cut...

The best practice is LOG and DATA files different drives and NOT on C:\

You can use the DTS Analysis Services processing task.

Oh and don't try and find it on your client Machine unless Analysis Services is loaded. Go to the server that has...

There are  PWDENCRYPT and PWDCOMPARE functions...

Declare @pswrd varbinary(255),

@Authorized int

select @pswrd = PWDENCRYPT('Hello')

SELECT @Authorized = PWDCOMPARE ('Hello',(@pswrd ),0)

if @Authorized = 0 print 'Get Lost!!@#'

if @Authorized = 1 print...

HI,

With a problem like this I have found that the best way to debug this type of problerm is ...

Do not execute the procedure from asp. Response write your entire execution...

Hi,

Is your database option set to AUTO SHRINK.

I think that you have an OLEDB problem. As far as I remember the Microsoft OLEDB driver does not support Oracle 8 CLOB data types.

Try searching on OLEDB supported...

Hi,

Have you tried SQL Profiler to trace this query. You can catch all the info needed if it runs.