SQL Utility Archives - Page 17 of 17 - SQL Authority with Pinal Dave

SQL SERVER – Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17

March 16, 2007

SQL Error Messages, SQL Server Security, SQL Utility

A Sqllib error with hr = 0x80004005 and Native Error 17 says SQL Server does not exist or access denied. The simple fix is to enable TCP-IP in Configuration Manager.

SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005

February 26, 2007

Pinal Dave

SQL Tips and Tricks

SQL Download, SQL Error Messages, SQL Server Agent, SQL Utility

A TechNet article I liked on what’s new in SQL Server Agent for SQL Server 2005: security, proxy accounts, shared schedules, WMI alerts and Database Mail.

Red threads running from a pin in a small table out to cards pinned around it, with a magnifying glass over one thread.

SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure

December 10, 2006

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL Utility

Two quick queries on syscomments to find every stored procedure related to table names you search for, since sp_help and sp_depends are not always accurate.