What do you define as confidential information?

Things like Red-Gate SQL Compare can read a diff backup to get the schema, unsure on Data Compare

http://documentation.red-gate.com/display/SC11/Working+with+backups

SQL Compare can retrieve the schema from...

Whoops, oversight on my part I do appologise.

http://technologycraftsmen.net/blog/2010/10/19/alphanumeric-sorting-in-mssql/ has a function which will do it

SELECT activityName

FROM #Activities

ORDER BY

master.[dbo].[fn_CreateAlphanumericSortValue] (activityName,1)

!!WINNING!! (in my best Charlie Sheen impression)

one armed

Something like this?

SELECT activityName

FROM #Activities

ORDER BY

Case When IsNumeric(activityName) = 1 then Right(Replicate('0',21) + activityName, 20)

When IsNumeric(activityName) = 0 then...

1. has a database about 100gigs ish, but the transaction log file are about 5-10kb, I want to log ship from prime location to secondary, will I run into issues...

villain

otomatopeia

What does the Windows event log say?

Why not use logshipping and set the restore job to run once a day?

Ed Wagner (9/22/2015)

Cane

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-7-detecting-primary-replica-ownership

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-8-dynamic-detection-gotcha-1

These two links helps me out in scheduled jobs to ensure they only run on the primary

Ed Wagner (9/22/2015)

tootsie

If you want to save it as REAL you will have to live with 1E+09 as REAL is actually FLOAT(24) and anything 24 or under is only a 7 digit...

Ed Wagner (9/21/2015)

MMA