Do you ever need to look for a given user's permissions for security reasons or move the permissions for that user from test environment to production? This is a script, which will generate print statements, which can be use to view/grant, the permissions of all dbo objects, which the given user has, which is not […]
2004-08-16 (first published: 2004-01-16)
636 reads
This script will help you locate columns that you provide in a comma delimited format. You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in.
2004-08-13 (first published: 2004-01-22)
157 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-08-12 (first published: 2004-02-10)
830 reads
The code in this procedure takes standard formula’s given by Microsoft and calculates approximate size of a table as per the fields & indexs on that table. The procdure can be quickly be used in a loop to work for entire database. Refer to article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp for the actual document containing the formula’s used.There are […]
2004-08-11 (first published: 2004-02-16)
2,979 reads
The purpose of this SP is to provide a method in T-SQL to launch another T-SQL thread without havingto wait for its completion. Uses fairly basic calls to create and execute SQL Jobs. Contains helpfull notes and documentation.
2004-08-10 (first published: 2004-02-17)
2,261 reads
Script to look at all articles in all publications in a DB to find replicated columns of certain data types. I used this to find BLOB columns that we wanted to remove from the articles.
2004-08-09 (first published: 2004-02-19)
486 reads
I am new to writing scripts so dont blast be to bad. This is a script to make all logins of a sql server readonly users to all user databases. Mainly after a restore from a different server. (for reporting maybe) Any methods to optimize this script are fine.
2004-08-06 (first published: 2004-04-14)
231 reads
This script will generate random Strong Passwords for all Standard SQL Logins for a specified SQL Server. It currently does ALL standard logins, including SA, so you would want to add to the WHERE clause in the SELECT_LOGINS constant if you want to limit the logins. The password generated will be 10 - 15 characters […]
2004-08-05 (first published: 2004-05-12)
306 reads
I use this VBScript to get a DDL copy of all objects in my DB, and check them into SourceSafe if they have changed. I run it via Scheduled Tasks every night. Make sure unauthorised users have no access to the script location, as you need to enter the VSS password in it.
2004-08-04 (first published: 2004-05-20)
500 reads
This script will run a DTS package from any registered SQL Server instance and display the standard package execution progress dialog while the package is running.To specify the SQL Server instance and package to run, amend the parameters for the ExecuteDTS function in the "Main Program" section of the script.The script is written using SQL […]
2004-08-03 (first published: 2004-05-25)
1,091 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers