Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag relationship Rss

   Items 1 to 4 of 4   
 

Find all Job Relationships with SSIS Config files

Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.  Read more...
By Ray Sotkiewicz 2013/12/05 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,603 reads

Relationship between users and Databases

Show the users inside the databases  Read more...
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,214 reads

Find all Job Relationships with SSIS Config files

Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.  Read more...
By Ray Sotkiewicz 2013/12/05 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,603 reads

Truncate Referenced Table

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,251 reads
   Items 1 to 4 of 4   
 
Tags
databases (1)    
delete (1)    
foreign keys (fk) (1)    
integration services (ssis) (1)    
jobs (1)    
metadata (1)    
msdb (1)    
referenced tables (1)    
truncate table (1)    
user (1)