Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Comprehensive Backup Script Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 12:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:40 AM
Points: 1,568, Visits: 666
Comments posted to this topic are about the item Comprehensive Backup Script


Post #449212
Posted Wednesday, September 9, 2009 8:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:23 AM
Points: 162, Visits: 376
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
Post #785010
Posted Saturday, November 21, 2009 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 12, 2011 6:57 AM
Points: 2, Visits: 51
A well crafted masterpiece, however I need a similar for use with linked servers, would be highly obliged to get help.
Post #822935
Posted Wednesday, December 21, 2011 10:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 29, 2013 8:34 PM
Points: 110, Visits: 120
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.
Post #1225543
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse