This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,788 reads
2008-01-24
1,232 reads
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,015 reads
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-01-18 (first published: 2007-09-25)
2,687 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,078 reads
Sometimes you are given a list of values in a stored procedure that you want to use in an "IN" clause. This is a common in Reporting Services multi value parameters.
2008-01-15 (first published: 2007-11-15)
992 reads
2008-01-14
977 reads
Two queries below show one of many ways how You can generate a sequence of numbers.
2008-01-14
916 reads
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,370 reads
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,301 reads
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item The Last Good DBCC Run
Hi everyone I have a SP that finds the average based on 3 tables. ...
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers