Impossible de démarrer le débogage T-SQL Impossible d'attacher au processus SQL Server

Problème : Le débogage à disntance du  T-Sql depuis SSMS SQL 2008 échoue avec l’un des messages d’erreurs ci-dessous : Impossible d’attacher au processus SQL Server sur «MyInstance». Le serveur RPC est indisponible OUImpossible de démarrer le débogage T-SQL. Impossible d’attacher au processus SQL Server sur «MyInstance». Vous ne pouvez pas vous connecter à distance SQL Server Management…

0

Unable to start T-SQL Debugging. Could not attach to SQL Server process

Problem: Remote T-Sql debugger from SSMS SQL 2008 fails  with one of the following issue: Could not attach to SQL Server process on ‘MyInstance’.The RPC server is unavailableORUnable to start T-SQL debugging. Could not attach to SQL Server process on ‘MyInstance’. So, you are not able to remotely connect in SQL Server Management Studio to…

0

Last stored procedures updated with SQL Server Management Studio 2008

Last stored procedures updated with SQL Server Management Studio 2008 I would like to share with you a new feature that I found out by using SQL Server Management Studio 2008. With SQL Server 2005, I used to run the query below to get the list of the stored procedure whom modified by the developper…

4

SQL Server Management Studio spends over 10 seconds to load

Problem descriptionSQL Server Management Studio spends over 10 seconds to load.CauseIn general, this behavior is due to 2 things:1. The host computer not has access. By default “SQL Server Management Studio” is configured to use online help resources. 2. The host computer not has access. SSMS tries to go on internet to check for server…

1

Migration SQL Server 2000 to SQL Server 2008

The purpose of this post is to explain the minimum required for the migration of Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You can use the same principles to migrate a Microsoft SQL Server 2005 to Microsoft SQL Server 2008. 1. SQL server 2008 upgrade advisor1.1. Before migratingMicrosoft provides a tool called “Microsoft…

6

SSMS 2005 on IA64 shuts down suddenly after clicking on "New Query"

SQL Server Management Studio 2005 on IA64 shuts down Problem descriptionSQL Server Management Studio 2005 on IA64 crashs when you click on “New Query” button. It shuts down Management Studio automatically. This issue arrive when you are on Windows 20003 IA64 and SQL Server 2005 IA 64Another symptom is that when you attach the debugger…

0