Query Analyzer to SQL Server 2005
[704 byte] By [bass_player] at [2007-12-17] 
SQL Server 2000 Query Analyzer is not forward compatible and does not understand the packet format that SQL Server 2005 uses. SQL Server 2005 Managment Studio does understand the SQL Server 2000 protocol, so it is backwards compatible.
StevenTwitchell at 2007-9-8 >
Query Analyzer from SQL Server 2000 to a SQL Server 2005 machine works fine for me. Check and see what client connection you are using (I use TCP/IP).
brucef at 2007-9-8 >
SQL Server Hot Topic
- Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files
- Failed to generate a user instance of SQL Server due to failure in retrieving the user's local
- Could not load file or assembly 'System.Data.SqlServerCe'...
- Bug? No WSDL information fo a WEBMETHOD that points to a table-value function
- Accessing AS400 Data
- inserted/deleted tables
- strange refresh of the parameter area
- Bug, Can not create varchar(max) columns with SMO
SQL Server New Topic
- Report External/Embedded Image Gotchas
- Asset Tracking Database
- Calculated Members - DSV and Cube structure
- "one or more accessor flags were invalid"
- Problem opening imported some of the excel files.
- RTD with Excel Limitations
- Help - Implementing Reporting Services 2005
- "Invalid Pointer" when run DTS package
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc