SELECT REPLACE( SomeColumn, SPACE(1), '' ) FROM SomeTable

Check which step is failing in job history..

I forgot which forum i'm in....

Just convert the table variable into temporary table....

Needed a lot of formatting...(I just can't read the messed stuff)

And also the left join you've used is actually would turn into an inner join

because of where filter...which this...

1. SELECT FULLTEXTSERVICEPROPERTY('ResourceUsage')

2. Yes

You could use sp_executesql procedure....

DECLARE @TotalRows INT

DECLARE @SQL NVARCHAR(1000)

SET @SQL = 'SELECT @TotalRows = COUNT( * ) FROM sysobjects'

EXECUTE SP_EXECUTESQL @SQL, N'@TotalRows INT OUTPUT',@TotalRows = @TotalRows OUTPUT

SELECT @TotalRows

or you...

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

SELECT * FROM sysobjects WHERE type = 'U'

What method you have used to import data from excel?

If you've used DTS/SSIS package, right click on the package and go to schedule package then set a desired schedule for...

Is this job a recurring one?

Is the schedule of job enabled?

Do you find any relevant information in job history or error log?

SELECTo.name, o.type_desc, p.name, t.name, p.max_length, p.precision, p.scale,

p.is_output, p.is_cursor_ref, p.has_default_value, p.is_xml_document, p.default_value

FROMsys.all_objects o

inner join sys.all_parameters p on o.object_id = p.object_id

inner join sys.types t on p.user_type_id = t.user_type_id

order by o.type_desc, o.name,...

Check whether this job has a schedule and also enabled.

There wouldn't be any option for database mail as it is not a service. In fact, it is designed on a queued architecture which uses service broker technologies.

Whenever...

DECLARE @fX FLOAT, @fY FLOAT, @fM FLOAT

DECLARE @rX REAL, @rY REAL, @rM REAL

SELECT @fX = 2.77555756156289E-17, @fY = 15, @fM = 1.85037170770859E-18

SELECT @rX = 2.77555756156289E-17, @rY = 15, @rM =...

I was just trying your example, here is what i found.

VB : 5.23853e-032

SQL (with real) : 0

SQL (with float) : 5.23853e-032

This says, that somehow the real data type is not...

Without using command line utilities, it would be almost impossible to achieve what you want.

One thing you can do is to write to text file for each record...