Search Results: System Stored Procedure

• 
  SSIS 2008 Logging and Package Configuration Objects FAQ

  SSIS 2008 Logging to SQL Server 1. Can I change the dbo.sp_ssis_addlogentry system stored procedure to non-system stored procedure and if so how is this done? Yes – you must drop and recreate the procedure (and don’t run [sp_MS_marksystemobject] N’[dbo].[

  Author:  JoeSalvatore     Date: 2/25/2011     Section: Blog

  tags : 2005, 2008, 2008 R2, Business Intelligen, SQL Server Versions, SSIS Integration Services, SQL Server
• 
  Temp table scoping issue

  A customer approached me with a strange problem. They were using one of the system stored procedures, s p_help_log_shipping_monitor , to make sure that log shipping was up to date before running a report against the secondary database. The system stored p

  Author:  KathiK     Date: 6/22/2012     Section: Blog
• 
  Temp table scope

  A customer approached me with a strange problem. They were using one of the system stored procedures, sp_help_log_shipping_monitor , to make sure that log shipping was up to date before running a report against the secondary database. The system stored pr

  Author:  KathiKellenberger     Date: 6/15/2012     Section: Blog
• 
  Retrieve Space Used Details for Table

  Every once in a while, you may have a need to determine how much space is being used by a table in your database. In this quick blog, I am going to show you how to get the some details on a particular table using the system stored procedure sp_spaceused.

  Author:  briankmcdonald     Date: 7/7/2010     Section: Blog

  tags : SQL Server, sp_SpaceUsed
• 
  Top 10 Most Useful SQL Server DMVs -- Greg Robidoux

  I hve attended the idera sponsored webinar on 'Top 10 Most Useful SQL Server DMVs' by greg Robidoux Here are my learnings of that webcast What are DMVs Dynamic Management Views are views and functions introduced in sql server 2005 for monitoring and tunin

  Author:  indupriya     Date: 5/12/2010     Section: Blog

  tags : SQL SERVER DMVs
• 
  Query to Find a List of Jobs Running on your Server

  Usually I decide what to blog about by running across something cool or challenging during work. But every once in a while I like to share something that I've received a number of questions about in a short period of time. Ya never know who else out there

  Author:  kylewalker     Date: 4/19/2011     Section: Blog

  tags : System Stored Procedure, Running Jobs
• 
  Useful queries #2: Change a SQL Server instance name

  Have you ever needed to change a SQL Server instance name? You can easily do so with a couple of system stored procedures included with SQL Server. Step 1: Drop the server?s name sp_dropserver 'old_name' Step 2: Add new server?s name sp_addserver 'new_nam

  Author:  JoseChinchilla_SQLJoe     Date: 10/11/2011     Section: Blog