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
128 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
125 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
351 reads
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
By Steve Jones
slipfast adj. longing to disappear completely; to melt into a crowd and become invisible,...
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Our IT department contacted me recently and asked if they should change the default...
Ask SSC