The postings on this site are my own and do not represent my Employer's positions, advice or strategies.


  Monday, December 09, 2019


bob tech
Contact Bob
VW Buses
Cook Book


Aaron first Bday

  bob Links
Visual Basic and Win...
For when the lepers she nursed implored her for beer and there was none to be had, she changed the water which was used for the bath into an excellent beer, by the sheer strength of her blessing, and dealt it out to the thirsty in plenty. - From the Life os St. Brigid
Wider View Insert

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
     Jobs SQL Agent
     User Management
     System Databases
     Temp Tables
     Find the physical se...
     Enable xp_cmdshell
     Intermittent Connect...
     Connection String Pr...
     Login Error ( State)...
     Turn Default Tracing...
     Re-index fails when ...
     Tracing of Errors
     Extra carriage Retur...
     Query to find Object...
     Named Instance Port ...
     Adding Domain Login ...
     Rename Logical File ...
     Error 3624 Delete st...
     SQL DMO Error 21776
     SQL Server Service m...
     Trace Flags for Dead...
     Change Server Name
     Alternate to Count(*...
Windows OS

Insert Category

Will be added as a sub-category of, SQL Server
Change Server Name
select * from sysservers sp_dropserver 'KBARTLETTXP' Go sp_addserver 'RHORKAYXP','local' go -- SYSJOBS,;EN-US;q281642 /* If this is a SQL2000, you need to change the originating_server column in msdb..sysjobs table.Details here: PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming Windows Server */ select * from msdb..sysjobs update msdb..sysjobs set originating_server = 'rhorkayxp' where originating_server = 'kbartlettxp'