Try a capital -P for the password argument.

select convert(decimal(10,3),convert(int, (0.4799608993157 * 1000))) / 1000

I think this is only as good as the last statistics update.  It's not updated with every table insert or delete (thank goodness! Imagine the contention.). 

Stored procedures or other SQL which uses temporary tables may need to specify the collation on the 'create' for the temporary table if specific collation behavior is desired, since tempdb...

How are you getting the data into the SQL Server?  If the mainframe data can be extracted in clear text (not packed decimal or zoned decimal) then a utility like...

In the days when a CEO's compensation was tied directly to the success of the company they led, I would agree that they were taking a great risk and should...

Tables in a relational database don't have any inherent order.  If you want the rows back in a particular order, you need to provide a column with data in it...

Run this

select 'revoke execute on ' + name + ' from public' from sysobjects where type = 'p'

in the database to generate the 'revoke' commands, then run the generated commands

Check sp_dboption.  If either 'merge publish' or 'published' are turned on, turn them off and give it another try.

I'm a little confused as to what 'merge them' means in this context.  Could you post an example of the output you want to see? Do you want both values...

What are you trying to accomplish with this?  Relational tables typically don't have an 'internal order'.  You have to use the 'order by' clause when you retrieve the data to...

I've heard some horror stories of anti-virus software continuously trying to scan the database filegroups because they were constantly changing.  I'm sure there are filters you can use to prevent...

Hmmm.

It's not a hex thing

select isnumeric('0A830') yields 0, so does

select isnumeric('0F830')

and

select isnumeric('1D830')

And this

select convert(int,'0D830')

 just croaks as you would expect it to.

But this

select convert(float,'0D830')

returns 0

According to BOL, ISNUMERIC returns 1...

If you use the '-w' switch on the OSQL command line, you can make the output column wide enough to avoid the wraparound.

I've use DBArtisan from Embarcadero at the last two places I've worked.  It's a very nice tool for a heterogeneous database environment since it supports MS and Oracle and Sybase...