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

Content with tag objects Rss

   Items 1 to 6 of 6   
 

How to find user who ran DROP or DELETE statements on your SQL Server Objects

Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.   Read more...
By Additional Articles 2013/12/12 | Source: MSSQLTips.com | Category: sql server objects
Rating:  Rate this |   Briefcase | 6,180 reads

Finding Objects on Your SQL Instance

Find objects in any database on your SQL instance.  Read more...
By Paul Andrew 2013/07/30 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,445 reads

Query all objects created or modified after specified date

This script will query across all databases, returning a result of objects recently created or modified.  Read more...
By Eric Russell 2012/12/21 | Source: SQLServerCentral.com | Category: objects
Rating: |  Discuss |   Briefcase | 1,472 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2012/10/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,112 reads

Validate Deployed Databases by Version

Save all object definitions to a single stored procedure for easy validation  Read more...
By William Talada 2010/01/14 | Source: SQLServerCentral.com | Category: deploying
Rating: |  Discuss |   Briefcase | 751 reads

Temporary objects

By bitbucket-25253 2009/12/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,846 reads
   Items 1 to 6 of 6   
 
Tags
delete (1)    
deploying (1)    
deployment (1)    
drop (1)    
dynamic sql (1)    
modified (1)    
powershell (1)    
search (1)    
sql server objects (1)    
stairway series (1)    
troubleshooting (1)    
t-sql (1)    
versioning (1)