Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.

Money

RE: How to install service pack on sql server with multi-instances

There are different service packs for SQL (Standard and EE editions)  than MSDE - you may need to download the MSDE SP3a and apply that.

RE: Very Large Transaction Logs

Thank you all for the input so far.You all right about the transaction logs and ArcServe.  I went into the ArcServe event log for the backups and found that unlike SQL, only the database is backed up.  While it does perform a proper Checkpoint, the log is not truncated and the actual Transaction Log device is […]

RE: Changing the SA Password in the MSDE

Thanks, that works a treat, what happens if the user has forgotten the current password, i was told they have to uninstall MSDE and reinstall it, is this correct. Thanks Steve

RE: Processor Performance issue. could it be virus

Any errors in SQL Server errorlog? Check serevr's application and system log too.

RE: Anyone uses C2 auditing on SQL Server?

We use C2 because we are required by the government to do so. From what I undertand, C2 audits all events. The events are written to 2000MB rollover files located in mssql\data. One disadvantage is that if SQL Server cannot write to the audit file used in C2, then SQL Server will automatically shut down! […]

RE: can't copy Log file

Hi Mark, I have literally just found the answer.(midnight here in sunny Glasgow)I was trying to copy on to a cd ROM that didn't have enough space for the massive LDF file... aaah my shame.To be fair, the error message was I was getting was hardly the most informative. aah well, it's a lesson learned.cheers […]

RE: Using "Like" or Wildcard

Yes that is what I want. In my world: A list of all active courses in department 10 only. There are 10 departments which have courses listed in the database. Each department has a unique identifer for their courses. Each department have active and inactive courses listed. Thanks for your words of kindness...