This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Prerequisites

< BACK TO TO THE MAGIC OF SQL SCRIPTS SERIES LIST

To be able to implement most of solutions that I would like to offer, you would need the following:

(1)

Create auxiliary database in the same instance of SQL server where your production database sits. This will be completely separate database which will not interfere with any data in your production environment. We will use this as a holding place for all sorts of data, information, configuration, etc which we will need throughout these series. I am not a DB expert - please consult your DBA or Google how to create Database. All you need is just a database similar to the below. All default settings, nothing fancy.

01.PNG