I created this script to simplify the process of restricting access to high risk extended stored procedures. It will find any user or role which has execute permissions on any of the stored procedures in the "#High_Risk_Stored_Procs" temp table and will generate the relevant revoke statements to remove those permissions.The current list of stored procedures […]
2006-11-27 (first published: 2006-11-07)
671 reads
Ever needed to drop all connections to a database? Here is an easy way to do it.
2006-11-24 (first published: 2006-11-08)
599 reads
sort employee birthday by on coming order. If the person's birthday is yesterday, s/he should be in the bottom.
2006-11-23 (first published: 2004-12-29)
119 reads
Create SQL Function To Format To Currency(for more scripts goto http://www.siccolo.com/articles.html)
2006-11-21
854 reads
As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.
2006-11-21 (first published: 2006-01-30)
142 reads
In The Netherlands we use bankaccountnumbers that need to comply to a test call 'elfproef'. This test evaluates the sum of each number multiplied by the position the number appears in the accountnumber. If the modulos of the sum divided by 11 is zero then the accountnumber is valid. The length of a bankaccountnumber in […]
2006-11-20 (first published: 2004-12-14)
625 reads
This is a re-written function that the idea got from yesterday's script. This function used a recursive call to simplify the script.
2006-11-17 (first published: 2004-09-20)
224 reads
Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]
2006-11-16 (first published: 2004-09-30)
119 reads
In our environment, we needed to create and drop replication over and over in our test environment and I got realy tired of having to manualy go to each table with an identity column to set its ranges. This sproc will create or drop the publications and/or subscriptions for all or some of the objects […]
2006-11-15 (first published: 2001-09-05)
758 reads
2006-11-14 (first published: 2006-05-08)
102 reads
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers