Anybody else have any ideas before I post on the MSDN forums?

Jeff thanks for the link but I am using DECIMAL which is one of the recommendations.

So are we saying that the STR function doesn't work and therefore should be avoided?

I...

Phil,

Thanks for that.

I forgot to mention that the variable is declared as DECIMAL(28,15) so I am surprised it causes a rounding issue.

I've never come across this issue before and would...

Thanks Phil.

When I got the email saying I had a reply I thought somebody may have the answer

I've always used sp_OAMethod and sp_OAGetProperty and there are plenty of examples via Google.

You can get total space and free space this way.

I have a non-senior DBA to do my restores for me

It's all built in:-

CREATE DATABASE AUDIT SPECIFICATION PCI_Txn_Database_Spec

FOR SERVER AUDIT PCI_Audit

ADD (DATABASE_OBJECT_PERMISSION_CHANGE_GROUP),

ADD (SELECT ON dbo.Customer BY dbo),

ADD (INSERT ON dbo.Customer BY dbo),

ADD...

For licensing of CPU's / Version read http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx and then click the quick reference guide PDF link.

To quote "Per Processor License costs are the same regardless of number...

Use Hyperbac here and works a treat as we are always having to refresh multiple virtual environments from production.

I've used SSIS to create text files and then SFTP them to the destination and restore if there is no chance of any connection between the domains / networks. Or...

I've always used:-

-- Capture the entire script start time (survives batch's / go's)

DECLARE @starttime datetime

DECLARE @binvar binary(128)

SET @starttime = getdate()

SELECT @binvar = CONVERT(binary(128), @starttime)

SET CONTEXT_INFO @binvar

-- Then to get it...

Ealing in West London to the City - 11 miles and takes 55 minutes as it's by tube - madness as people who live 50 miles away get to...

You could use a script task in SSIS and bind to a job that runs every 5 minutes.

Really surprised that more cores reduce backup time as usually you are bound by I/O performance, even with an EVA with 100+ disks, if you have large databases.

We use...

It would be so great if you could restore a database to its minimum database and log (and be able to set to simple before the restore) size - would...