sqlcmd Archives - Page 4 of 4 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName

May 4, 2007

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security, sqlcmd

Msg 7311 comes up when a 64-bit SQL Server 2005 runs distributed queries against a linked 32-bit SQL Server 2000 or 7.0. Running instcat.sql with osql fixes it.

SQL SERVER – Fix: HResult 0x274D, SQLCMD Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired

April 4, 2007

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server, SQL Server Security, sqlcmd

SQLCMD error HResult 0x274D, Microsoft SQL Native Client: Login timeout expired? TCP/IP is off by default in SQL Server 2005; enable it in Configuration Manager.