Activity overview
Latest activity by johnsongb
Error Opening Report Server from Registered Servers
If I select a "Reporting Services" Server from "Registered Servers", I immediately get a SQL Discover error dialog. No matter which option I select after that, SQLMS closes. I am unable to manage...
That command does the same thing: exec master..sqlbackup '-sql "RESTORE HEADERONLY FROM DISK = [file.sqb]"'
It still returns two record sets vs the tsql command which returns one table with one row.
SQL Backup v5.0.0.2770
Reading file header of "\\amedwsapgr04\BITS\OPMPAC\OPMReporting\FULL_SQL2005_OPMReporting_20070501_221757.sqb"
Backup name : Database (OPMReporting), 5/1/2007 10:17:57 PM
name value
exitcode 0
sqlerrorcode 0
filename001 \\amedwsapgr04\BITS\OPMPAC\OPMReporting\FULL_SQL2005_OPMReporting_20070501_221757.sqb / comments
That command does the same thing:exec master..sqlbackup '-sql "RESTORE HEADERONLY FROM DISK = [file.sqb]"'
It still returns two record sets vs the tsql command which returns one table with one row...
RESTORE SQBHEADERONLY returns multiple record sets
This is going to be kind of a long explanation. This is for anyone that might have used the tsql command "RESTORE HeaderONLY" with some automated scripting. The "RESTORE SQBHEADERONLY" does not r...
Custom Filter
I would like to be able to apply a custom filter when comparing databases. I frequently rename objects that I "think" I can get rid of. For example, tbTableName would be renamed zz_pendingdelete_...