Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag objects Rss

   Items 1 to 7 of 7   

Script All Server Level Objects to Recreate SQL Server

Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.   Read more...
By Additional Articles 2015/06/19 | Source: | Category: objects
Rating: (not yet rated)  Rate this |   Briefcase | 3,197 reads

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,510 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,490 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,569 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 | 9,755 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 | 758 reads

Temporary objects

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