This scripts helps to power you with the disk space monitoring for the Mount points.

Hope this helps

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2010-05-27 (first published: 2009-04-17)

4,015 reads

Automated Script to Partition Tables

This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2009-06-10 (first published: 2009-05-22)

2,399 reads

Blogs

As part of my running the SQL Saturday charitable foundation, I get sponsorship money...

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Comments posted to this topic are about the item Displaying Money

Comments posted to this topic are about the item The Slow Growing Problems

Comments posted to this topic are about the item Calculating the Harmonic Mean in...

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros