In a previous article I described how to use a certificate to sign a stored procedure. Part of that article showed how to copy the certificate between databases by using a backup/restore method. This article shows another method – scripting. Continue reading
Tag Archives: CERTENCODED
How to Script a Certificate
29 May
- Comments 1 Comment
- Categories Certificates, impersonation, Security, SQL
Recent Posts
Archives
- August 2019
- July 2019
- June 2019
- April 2019
- March 2019
- November 2018
- May 2018
- April 2018
- March 2018
- February 2018
- January 2018
- December 2017
- November 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- January 2017
- December 2016
- September 2016
- July 2016
- December 2015
- November 2015
- September 2015
- August 2015
- July 2015
- May 2015
- April 2015
- March 2015
- February 2015
- November 2014
- October 2014
- August 2014
- February 2014
- December 2013
- November 2013
- October 2013
- September 2013
Categories
- @@IDENTITY
- Availability Groups
- Backups
- Certificates
- Column set
- Compress
- Constraints
- CSV
- Data Masking
- Data Structure
- DBCC
- Distributor
- Editing
- Error Log
- Errors
- Extended Events
- Heaps
- impersonation
- Indexing
- Installation
- Instant File Initialization
- Introduction
- Isolation Levels
- JSON
- LDAP
- MERGE
- Monitoring
- NOCHECK
- NOLOCK
- Optimiser
- OUTPUT
- Package Errors
- Parameters
- Partitioned Views
- Partitioning
- Pivot
- Publisher
- Replication
- Replication
- Row_Number
- Security
- SESSION_CONTEXT
- SHRINKFILE
- Slowly Changing Dimensions
- Snapshot Backup
- Sparse Columns
- SQL
- SSIS
- SSISDB
- SSMS
- STUFF
- TABLESAMPLE
- Training
- Transactions
- Uncategorized
- UnPivot
- Versioning
- Views
- XML
- ZappySys
Recent Comments