It looks like this method isn't going to work for me. I was having such a difficult time recovering the PL/SQL from the object variable that I switched methods...

Steve, The PL/SQL I need to use to open the recordset is stored in varchar(max). That is the object text I'm having trouble recovering. Whatever method I use,...

Look at the Idera SQL Compliance tool.

https://www.idera.com/productssolutions/sqlserver/sqlcompliancemanager

😉

I agree wholeheartedly. NoSQL stands for "Not Only SQL". It complements RDBMS platforms, not replaces them. Database engineers need to know NoSQL capabilities and weaknesses, as well as...

I feel the same way about MongoDB as I do Microsoft Access. It's a great tool for the job it was designed for. The problem comes when people...

Thanks for the article. This is something I've been meaning to do for awhile, but have been too wrapped up in other work. Now if someone could show me...

Actually, one of the native Job Types is an Operating System Command (CmdExec), which can be used in any step of a job. I've used xp_cmdShell many times in...

Users of the Import/Export wizard would be well advised to look at another tool that always ships with SQL Server... BCP. The (B)ulk (C)opy (P)rogram is a command-line program...

Steve, Most people measure the value of their careers by their successes, but I am of the camp that measures (in part) the value of their career by my failures......

Nadrek, suffice it to say that I have good business reasons to recover the original password. I've been a SQL DBA for 15 years and a IT pro for...

I'm frustrated trying to recover a sa password from a legacy database that no one knows. I've tried using Hashcat and oclHashcat following this article and the HashcatGUI. ...

Steve,

Yep, that about sums it up. I've known since Oli North was busted by emails he thought he deleted that anything that is ever online for a single moment...

Steve,

As a young man I tried several martial arts, Karate, Tai-Kwon-Do, Jui-Jit-Su and Judo. It was when I went back to college after a stint in the service (USCG)...

I agree that the second method is better than the first, but the duration of each method can only be measured correctly if you clear the procedure cache for the...

@ those who question why to do this. It's very simple, if you don't see the need to do it, don't do it. Questioning why someone else...