Post reply

Comprehensive Backup Script

  • January 30, 2008 at 12:47 am

    #186078

    Comments posted to this topic are about the item Comprehensive Backup Script

  • September 9, 2009 at 8:27 am

    #1051156

    In file cleanup job on sqlserver 2005, I get the following error

    Executed as user: NT AUTHORITY\SYSTEM. Conversion failed when converting datetime from character string. [SQLSTATE 22007] (Error 241).

    Any help appreciated

    Howard

  • November 21, 2009 at 1:35 pm

    #1082682

    A well crafted masterpiece, however I need a similar for use with linked servers, would be highly obliged to get help.

  • December 21, 2011 at 10:15 pm

    #1424565

    Hope that the naming convention when creating stored procedure must not be sp_ it should usp_ or whatsoever, but not sp_. What is the implications? It might have a performance degradation due to systems stored procedures name will start also sp_. SQL server will try to look first on the systems stored procedure first before users created procedure. But maybe the stored procedure that you created has some reasons why you do it that way. 🙂

  • May 11, 2016 at 11:44 am

    #1878343

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply