SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2008, SQL Server 2000 Rss

   Items 1 to 6 of 6   

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.  Read more...
By Gene Hunter 2012/01/18 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 1,970 reads

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...
By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,695 reads

SSIS Package to Script All SQL Server Jobs to Individual Files

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...
Rating: |  Discuss |   Briefcase | 10,297 reads

Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:  Read more...
By Additional Articles 2010/02/26 | Source: SQLCAT | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,373 reads

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...
By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 7,553 reads

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,292 reads
   Items 1 to 6 of 6   
sql server 2005 (5)    
blogs (3)    
database security (3)    
security (3)    
sql server (3)    
agent jobs (2)    
64-bit (1)    
conferences/user groups (1)    
integration services (ssis) (1)    
presenting (1)    
professional development (1)    
professional organization for sql server (1)    
replication (1)    
smo (1)    
sql agent (1)    
sql server 2008 r2 (1)    
sql server architecture (1)    
sql university (1)    
tools (1)    
training (1)    
windows security (1)