Browse Site by Tags - MSMVPS.COM

You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications You may receive an error message when you try to export...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 11-18-2007
Filed under: sql server, error, kba, import, table, x64, wizard, export

FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 11-16-2007
Filed under: sql server, replication, kba, table, 2005, compact edition, synchronization

FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you try to edit a SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
Filed under: sql server, data, ssms, kba, table, string, binary, truncated

FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-27-2007
Filed under: sql server, server, query, kba, table, linked, alias