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)
410 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)
451 reads
Blogs
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Transforming rows into columns
Hi Everyone, I have a table with the structure as attached in the Table...
Reduce SQL Filestream limit
I want to save images into an sql database, and in my situation the...
Ask SSC