Add this procedure to the master database, it can then be executed from any DB to fix orphaned users (very useful when moving back to development). Using sp_msforeachdb with the proc allows you to resolve orphaned users in all databases in a single command: SP_MSFOREACHDB "USE ?; EXEC SP_AUTOFIX_USERS;"
2004-12-15 (first published: 2004-11-12)
2,962 reads
This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]
2004-12-13 (first published: 2004-11-17)
245 reads
This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences
2004-12-10 (first published: 2004-08-18)
700 reads
Simple script (alterable as needed) to verify existence of a file and execute a job if the return result = 1 (true)
2004-12-08 (first published: 2004-10-29)
157 reads
Updated Where_Am_I script to add database. This way you can park it in your master db and call it anytime you need it for another project/db.
2004-12-07 (first published: 2004-10-29)
183 reads
Is quite a joke, but useful, I guess, and, of course, improvable. It need to use two random number generator (inclued) published some weeks ago here.Some fieldtype needs to be generating-improved (e.g. images) ... I wait suggestions and improvements
2004-12-06 (first published: 2004-10-28)
363 reads
This script will update statistics on all user databases. The script can be created as a job from SQL Server Agent.
2004-12-03 (first published: 2004-10-27)
687 reads
This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]
2004-12-02 (first published: 2004-10-21)
284 reads
The following functions returns the number of years, months and days between two dates. The first returns a table format, and the second returns 1 value at a time
2004-12-01 (first published: 2004-10-13)
236 reads
Drops all the foreign keys in a database. This is useful when rebuilding data warehouses.
2004-11-30 (first published: 2004-10-13)
1,540 reads
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers