SQL Server Storage Engine & Tools (SSQA.net)

News

Technical & Business training in UK

Navigation

MSDN Blog

Browse by Tags

SQL Server Migration Assistant - what are the conversion rules between Oracle and SQL Server during the migration?

This was the big question posed by the users when a migration project is initiated at one of client's place. SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other Read More...

Posted: Tuesday, September 09, 2008 12:46 AM by SQL Master | 2 Comments

Filed under: sql server, ssma, data, oracle, migration, stored procedure, object, views, rules, tables

SQL Server 2005 debug a stored procedure, how-to?

If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger Read More...

Posted: Monday, February 11, 2008 2:38 AM by SQL Master | 2 Comments

Filed under: sql server, visual studio, 2005, 2000, connect, stored procedure, debug

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual Read More...

Posted: Wednesday, January 16, 2008 12:40 AM by SQL Master | 2 Comments

Filed under: stored procedure, linked server, Microsoft, sql server, kba, error, error log, 2005, 2000, aspfaq, issues