Dynamically script Create Database For Attach For All Databases
Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor
2010-05-20 (first published: 2009-05-07)
3,850 reads
- Interests: Those that are of like precious faith, SQL Server
Monitor Object Changes
Based on post http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=4349 I decided to write this script which will check for object changes in all databases and send an email listing the objects changed to the Operator associated with the job. This by no means offsets the need to restrict change access to objects in production, but in those cases when you […]
2002-05-23
1,537 reads
Monitor File Growth - Set Based sp_MSforeachdb
This is a script, similar to some you have seen in the past, that will monitor file growth on all databases for the given server. This script is not a fancy solution that has a tons of bells and whistles but, it is efficient. The script is a concantanation of the create table / populate […]
2001-12-21
3,367 reads
Blogs
Using T-SQL Snapshot Backup - Are Snapshots Backups?
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...
Developer Q&A: Dika Fei of Jelly Pixel Studio
By Rob Sewell
"Let me know where you get your magic pixie dust from!"
A New Word: Flashover
By Steve Jones
flashover – n. the moment a conversation becomes alive and real, when a spark...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Call Dates Effective Range
Hi Everyone, I have the data in the below form : Desired output: Here...
Question of the Day
Synapse Analytics History III
What was the originally name of the appliance that eventually became Azure Synapse Analyics?
See possible answers