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 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Forums
Controlling Intelligent Query Processing Features
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...
To use the same function to pass table name as a parameter
I have this function, but I wanted to pass a table so as to...
Create SQL Login to View only one database on server
Hi All, I have one task to create a login, and user need to...
Ask SSC