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 Week Reading (2019-07-21)
By Kamil
Another week passed. Look what did I find during that time. Press British Airways...
The Data platform has evolved – so too must the DBA.
By HamishWatson
This blog post is around the changing landscape of both SQL Server and the...
What does the Machine Learning process look like?
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
Forums
Trying to group 2 rows into a single line
Hi all, i am stuck trying to group 2 lines into 1. Hope someone...
SSMS via Citrix could not query An Microsoft Access Database despite of RDP
Hi dears, I will explain the case: I have an MS Access Database on...
Unable to group 2 records into a single line result
Hi all, i am stuck trying to group 2 lines into 1. Hope someone...
Ask SSC