Search Results

Search found 2 results on 1 pages for 'locksfree'.

Page 1/1 | 1 

• What is the fastest method to create a new database from a template ?

  - by Locksfree

  We are creating databases on demand and the databases can be created from different templates. All templates have the same structure but different data. The data contained by the templates is small. What is the fastest way to create a copy of the database: Backup/Restore Using T-SQL ? Using SMO ? Create a new database from a scripted version of the template and then fill in the little data required ? Other ?

  Read the article

• How to determine whether a database has been changed or not ?

  - by Locksfree

  I have a need to determine if a database on a MS SQL Server has changed between two distinct moments. The change can be structural or data-related and the check should be generic (i.e. independant of the structure of the database). Preferably, I'd like the check to be T-SQL based or with SMOs, not file based. I checked on MSDN but I haven't found anything relevant so far.

  Read the article

1