Sounds like a good opportunity for cross training and having a backup

Generally a server will go down more often than an individual database.  I guess the question boils down to:  IF one DB goes down AND it is required to work...

Why does the T-Log backup fail? 

Why can't you just restart the T-Log backup instead of destructively destroying data?

research sp_changeobjectowner and sp_change_users_login 'Auto_Fix'

SELECT ISNULL(Field1, '') + ISNULL(Field2, '') + ISNULL(Field3, '') ??

Generally DB specific SP's live in the DB they are for.  Common SP's can live in master or a COMMON user DB.  Regardless of where you put them NEVER (did...

How 'bout something like this in a BAT file

SET ChangeRecord=Maintenance

SET LOGDIR="C:\Logs\%ChangeRecord%"

IF NOT EXIST %LOGDIR% MKDIR %LOGDIR%

SET LOG=%LOGDIR%\%ChangeRecord%_runsql.log

SET PREFIX=%LOGDIR%\maint.

SET SRVNAME=MyServerName

SET DB=YourDB

ECHO. > %LOG%

osql  -S%SRVNAME% -E -n   -d%DB% -i "C:\Stored Procedures\Disable_FK.sql" -o...

Another way is C:\Progra~1.  Problem is when passed to a command prompt it doesn't know what to do with spaces.  Chris's solution works as well because the " around the...

I would also check the variables, etc.. that are used to create the export file and ensure that they are not set to be 255 (believe me, I've done it...

I guess first question is what do you mean by "Not working"?  If for some reason the DB goes offline?  Hard drive fills?  DB closes???

What information is contained in the...

If that is the case then

INSERT INTO tblPID

SELECT PID, PID_Date

  FROM LinkedServer.Database (Catalog?).Owner.Table L1

    INNER JOIN tblPID T1 ON L1.PID = T1.PID

NOTE:  This is only sample code...

Frank,

I have not done it but YES (scarily enough), I read it in BOL...

What BRAND of CPU are you looking at getting?  IF INTEL 64 BIT O/S with 64 BIT INTEL and 32 BIT SQL will run poorly.  IF AMD 64 BIT then...

INSERT INTO tblPID

SELECT PID, PID_Date

  FROM LinkedServer.Database (Catalog?).Owner.Table

???

AFAIK there are none.  BOL may be able to tell you differently though