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: | Category: sql server objects
Rating:  Rate this |   Briefcase | 6,275 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: | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,468 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: | Category: objects
Rating: |  Discuss |   Briefcase | 1,547 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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,355 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: | Category: deploying
Rating: |  Discuss |   Briefcase | 755 reads

Temporary objects

By bitbucket-25253 2009/12/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,859 reads
   Items 1 to 6 of 6   
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)