I have run this in all versions of SQL Server from 2000 to 2008 R2 and get the same answer - 10 '*'s.

select STR('8E10') -- returns '**********'

select len(STR('8E10')) -- returns...

I agree! If you want the max number of logical cores, state that specifically in the question.

This is the biggest reason I don't bother answering these questions. Unclear, unspecific, vague...

I haven't completely determined what this thing does yet? I do know it is supposed to call an FTP client on the server and send a file to another server.

All...

Just got same error in 2005 SSIS. The error occurred in ActiveX Script Task. This isn't my dtsx but I have to fix it. Any help is appreciated.

varchar PK's!?! If we could only carry guns in the office.