Bump! To see if anyone else has any idea?

The output would be downloaded to the server inside the firewall.  Not to a table but to a file on the server inside the firewall.

Here's the script:

CREATE proc sp_AuditLogs as

set...

We do something similar to monitor login failures:

We have a database with a stored procedure. This looks specificly in the active error log file on each server for the text...

Yes, it would be helpful to understand all the variables and sections, so that it could be adapted to local use.  Thanks very much, though.  It works as promised, but...

And as long as there's no unicode characters, you can change the datatype without fear of losing data.

For Index Defrag:

CREATE PROC usp_DBCCIndexDefrag

AS

SET NOCOUNT ON

/* Declare Variables                   */

DECLARE @v_table sysname,

        @v_Index INT,

        @v_SQL   NVARCHAR(2000)

/* Declare the Table Cursor            */

DECLARE c_Tables CURSOR

   FAST_FORWARD FOR

 SELECT name

   FROM sysobjects obj (NOLOCK)

 ...

Try this stored procedure:

CREATE PROC usp_DBCCReindex

AS

/* Declare Variables                   */

DECLARE @v_table sysname,

        @v_SQL   NVARCHAR(2000)

/* Declare the Table Cursor (Identity) */

DECLARE c_Tables CURSOR

   FAST_FORWARD FOR

 SELECT name

   FROM sysobjects obj (NOLOCK)

  WHERE type...

try using != or <>.

There are styles for the convert function that show the date for different formats:

Otherwise, you could adapt this (which I use to convert 120101 to time 12:01:01)

(convert(datetime,(Left(dbo.tblTemp.ScanTime,2)+ ':' + Substring(dbo.tblTemp.ScanTime,3,2)...

Pretty easy to DTS the data into your SQL Server and link to it through Access (ODBC).

If you're wanting to delete dupes you could use a correlated subquery such as:

DELETE FROM dbo.tblScanDetail

WHERE

 EXISTS

 (

 SELECT 

  ID, column1, column2, column3, column4

 FROM

  tbltable tbltableInner

 WHERE

  tbltable.column1  = tbltableInner.column1

  tbltable.column2  = tbltableInner.column2

  AND tbltable.column3...

If you have no backup, you're dead in the water on item 1.  On item 2, if the database has mdf and ldf files, copy them to the new computer and...

A DBA tale

Bob walked into his new office with overwhelming confidence as the exiting DBA finished packing his belongings. As Bob walked into the room, the DBA stopped a moment,...

The first thing a good dba should do, coming into an existing environment, is to put together a backup scheme.  Typically, a full backup once a week, and transaction logs...

I would have to agree that it's best not to allow developer DBA's access to the production server, however, many shops are too small to have this restriction.  How about...