I came across a situation where I needed to fix a vendors permissions issue. It required changing permissions on 338 views and tables, and leaving only 5 intact. Below is the Script I used to perform this task.
2003-02-10
147 reads
One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server. The initial transfer of users and passwords was performed by the sp_help_revlogin script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. The difficulty with this script was once the users are in place, you cant sync changed […]
2003-01-08
156 reads
This script is designed to backup the database, and copy it over the network to our backup server. The requirement for this particular database is 7 days of data kept on the LAN. The share on the backup server is mapped to the Y:\ drive. The datename function is used over the datepart function for […]
2002-12-08
368 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
Comments posted to this topic are about the item Fundamentals of Data Engineering: Plan...
Comments posted to this topic are about the item 25 Years of SQL Server...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers