get users across all databases on the SQL Server instance
Quick way to get all users on all Databases
2009-08-05 (first published: 2008-06-06)
1,680 reads
Scripts
Report failed SSRS subscriptions
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2009-08-05 (first published: 2008-11-19)
1,308 reads
Search for a Column in all databases
This Script can be used for searching a column in SQL server 2005
2009-08-05 (first published: 2009-07-18)
1,009 reads
Search for a Table in all databases
This Script can be used for searching a Table in SQL server 2005
2009-08-04 (first published: 2009-07-18)
1,090 reads
Compare SQL code of 2 objects.
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2009-08-03 (first published: 2008-09-05)
1,116 reads
Loop Through every table in a DB
This Script has been build to list all the tables in a database without using a cursor.
2009-08-03 (first published: 2009-01-05)
2,092 reads
search every database on server from a single sp
i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2009-08-03 (first published: 2008-11-11)
1,001 reads
2009-08-03 (first published: 2008-02-29)
3,353 reads
Zip Backups and Copy to Secondary (free)
We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.
2009-08-03 (first published: 2009-06-05)
2,521 reads
A set based T-SQL Solution for Sudoku Puzzle
A set based T-SQL solution for Sudoku puzzle. This is an update to my previous post with some corrections and in-line comments.
2009-07-29 (first published: 2009-07-14)
1,331 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT KONTAK BCA KCP ABC Telp:08218154393
WA:08218154393 Jl. ABC No. 23-25, Braga, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40111
ALAMAT BCA KCP Sunda Mal Telp:08218154393
WA:08218154393 Jl. Sunda No.50-54, Kb. Pisang, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40112
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers