Since your example works, then it must be that when you do a Print statement it is implicitly casting it to a varchar.  Does this sound right?

No it's not it...

Run this instead to see the difference between the printed value and the selected value

DECLARE @a as float(53)

SELECT @a = 367970.45

print @a

SELECT @a

Thanks for all the suggestions, I think Grasshoper's suggestion will be a possibility. 

1.  Local Temp table will not work because of concurrency issues.

2.  Always creating the "extra fields".  This would...

For Windows 2003 Microsoft only supports SQL 2000 SP2 and above.  Why not upgrade to SQL 2000 SP3a?

Either one of two things is happening:

1.  You still have a job or an application running that is attempting to login using the sa account, and fails.

2.  Someone is trying...

The 1067 error is a general error meaning that a service has failed to start.   I would check your event log to see if there is further information there, and...

F.Y.I.  UNC paths start with \\ rather than //

I may be mistaken, but I do not know of any easy way other than deleting the users that are in the database that were from the original server and...

I got a suggestion, quit your job as wanna-be DBA and go dig ditches for a living.

It still shows up in the right-click menu, however if one of those non-sysadmin users tried to stop/start the service.  They would receive an error message stating "Access Denied"!  This...

It still shows up in the right-click menu, however if one of those non-sysadmin users tried to stop/start the service.  They would receive an error message stating "Access Denied".

Thanks,

I agree that this contest is nothing more than brainless advertising for RedGate's product which sucks in the first place, due to the fact that it never includes constraints such...