web analytics

Tagged: stored procedure

Remove a Stored Procedure in Production Environment 0

Remove a Stored Procedure in Production Environment

How to remove a Stored Procedure in SQL Server production environment? How can we be so sure that is not being used any more? You need to know every single path from where this...

Sorted timesheets in Import Timesheet – Project Server 2007 0

Sorted timesheets in Import Timesheet – Project Server 2007

By default when we see the dropdown list of timesheets in the Import Timesheet page, they are not really sorted. And it is quite difficult to select the appropriate timesheet you want to import...

Debugging Stored Procedures in SQL Serrver 2005 0

Debugging Stored Procedures in SQL Serrver 2005

Pre-requisites 1. Find the .exe file under the directory, C:\Program Files\Microsoft SQL Server\90\Shared\1033\rdbgsetup.exe or similar path where the SQL Server was installed. The file rdbgsetup.exe stands for ‘RemoteDeBuGsetup’. Look for the emphasis on letters....