Find DataBase Backup Modes
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
415 reads
Find the database by table name
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
462 reads
Blogs
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
What I Love About My Job
In June this year I took redundancy from the company I’d worked at for...
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Forums
Backing Up Master
Comments posted to this topic are about the item Backing Up Master
Window Function Basics - PARTITION BY
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Focus on Growth in Your Career
Comments posted to this topic are about the item Focus on Growth in Your...
Ask SSC