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)
455 reads
Blogs
Daily Coping 1 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
PASS Virtual Summit 2020 Conference Sessions
By kleegeek
Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...
Running Express Edition in a Container–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Internal Query Processor Error: The query processor could not produce a query pl
Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...
How to extract string between variable characters?
Hi All, I've got a nasty column that I need to get the name...
Making 1 row from 2
I'm struggling a bit here. It seems easy, but I 'm not getting it....
Ask SSC