Browse by Tags

The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

Published 6 May 8 10:7 AM | SSQA.net

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...

Filed under: sql server, ssms, kba, import, management studio, export, identity key

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

Published 18 November 7 3:15 PM | SSQA.net

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...

Filed under: sql server, error, kba, import, table, x64, wizard, export

Best practices for Data Importing using SQL Server native methods

Published 26 October 7 6:8 PM | SSQA.net

Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server...

Filed under: sql server, data, best practices, import, testing, source, export, live data

Export SQL Servers registration using Management Studio?

Published 3 October 7 4:5 AM | SSQA.net

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL...

Filed under: sql server, ssms, best practices, password, 2005, management studio, servers, export, registered