Forum Posts

Visitors Online

Admin database 1.3 RC2 is available

http://www.sqlslayer.com/wp/admin-database/

Added LRTRIM/RTRIM to several of the who columns (who procs and view).
Added exclusion for QueueReader job steps in JobLogging.

Admin database 1.3 RC1 is available

http://www.sqlslayer.com/wp/admin-database/

Resolved issue with SQLServerStartupNotification blowing up when additional startup procedures existed.
Enhanced maintenance procedures for more selective maintenance.
Added JobOperators procedure.

Scripting out agent jobs that call DTS packages in SSMS 2008

Experienced a rather odd problem today … I scripted out multiple jobs from a SQL2000 environment using SSMS 2008 that call DTS packages. The command line for the jobs looked like DTSRUN /S “Server\Instance” /N “PackageName” /E. When I ran the jobs, they continually returned:
DTSRun: Loading…
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL [...]

“RowGUID is neither a DataColumn nor a DataRelation for table summary. (System.Data)”

We had merge replication in SQL Server 2005 set up that was working fine, except when trying to view conflicts, the Conflict Viewer would give this error: “RowGUID is neither a DataColumn nor a DataRelation for table summary. (System.Data)”.

The source of this it turns out was actually a period in the Publication name, as we [...]

Admin database 1.2 RC3 is available

http://www.sqlslayer.com/wp/admin-database/

Removed model database from BackupDB

We are finalizing a new version of the admin update utility which will better support specific versions of SQL (ie two part OBJECT_ID was not supported until 2005 SP2), as well as better support 2008. Once we have updated the configuration, we are planning to release an official release of the [...]