I guess I assumed that this was already being run from a Job. How is the proc being called? From a standalone app?

Did you ever consider just using Powershell with the Start-Job cmdlet? I expect that the use of Powershell would supplant the need for CLR procs when those procs are...

I'm still waiting for someone to fix this. The answer saying "ORDER By is required when using a TOP clause" is clearly wrong.

Yeah I don't understand it either but I've found that there is an identifier about 160 bytes before the data I want so I will read for it at the...

The sector size must be the difference, the new files all report the correct version. I looked through the 4k files and found that the offset is at 10412...

Well Lowell, sure enough your backups fail (i.e. return zero for version number), although backing up my database using your command works fine. I don't have a 4K sector...

Lowell, I'd like to find out more about why it failed on your backups since I tested it on several versions and different database names. Can you give me...

Also, if you would like to use this in PowerShell just execute the following to create a new object type

Add-Type -TypeDefinition @"

using System;

using System.IO;

public class GetSQLBackup

{

public...

I tested this against various database backups from SQL 2000, 2005, and 2008 and it worked as advertised. There were backups taken from different servers and with different...

there might be something in the header that might be causing that to shift position. In my case the database name being backed up was always the same. ...

OK, so one of my coworkers opened a backup file from a 2005 server and a 2008 in a HEX editor server and found where there was a difference in...

Yes there is. The system they are installing on may not yet have SQL Server installed on it. I will...

Half the fun of a new job is learning new things. Dive in and expand your horizons. Risk = reward. If you really think you'll fail, keep...

Just wanted to explain why you were getting what you were getting. CHARINDEX finds the STARTING position of the string you specify to be found (not the ending position)....

Here's a little follow up on the INSERT EXEC statement. Say you have a table defined as such

create table #ReportData (a int, b int, c...