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)
412 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)
459 reads
Blogs
Daily Coping 21 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a...
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Forums
Managed Instance, cross-database queries. What are the hidden requirements?
Have a managed instance with 2 databases. In theory I should be able to...
Need the (default) port to connect - why is this not implicit.
So I have 2 instances (1 x 12, 1 x 19). Both have the...
Extract data from XML field
Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an...
Ask SSC