Some time back i had the requirement for a SP which will give non repeatable random numbers with in a range. Following SP accepts a range and gives the random numbers. Once the numbers are exhausetd NULL, will be the out put. In this case user can restart the random number generation by passing 1 […]
2007-06-20 (first published: 2006-03-29)
257 reads
Use this Perl script to add Enterprise Manager registrations from a text file. The text file should contain three fields seperated by spaces. The first two fields are the server groups you want to create, and the last is the server name. ex...Production Accounting ACTPRSQL01QA Accounting ACTQASQL01The script also goes out and registers all SQL […]
2007-06-19 (first published: 2005-03-23)
311 reads
This script will give detials for all the enabled job including their steps/command/schedule.
2007-06-18 (first published: 2006-05-26)
910 reads
This is my attempt to improve the performance of propercasing a string of text in SQL server. I have run this against several other "looping constructs" - and it is significantly faster.
2007-06-15 (first published: 2005-10-17)
445 reads
This script creates 2 new system functions :fn__testregexp(@String,@Pattern) returns int execute the method test(@String) on the regular expressions @Pattern returns : 0 : no match 1 : match null : one of the parameters was null anything else : error from sp_OA procedure fn__replaceregexp(String,@Pattern,@Replace) returns varchar execute the method Replace(@String,@Replace) […]
2007-06-14 (first published: 2004-04-07)
1,937 reads
Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]
2007-06-13 (first published: 2004-09-28)
1,878 reads
This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.
2007-06-12 (first published: 2005-01-05)
495 reads
This script checks the latest backup of all databases. Then it write a logfile with this timestamp. all backups older than one day will be marked as ERROR.
2007-06-11 (first published: 2005-06-30)
645 reads
This script helps you synchronizing ALL orphaned database users to syslogins of the new database server. To run it, pass the target database name in on the first line.
2007-06-08 (first published: 2005-08-27)
565 reads
This stored procedure will loop through all of the Analysis Services databases in the repository and back them up to a .cab file using the msmdarch command. A log file will be included with the backup.There will be 2 days worth of backups saved to a local disk drive on the server.It may be necessary […]
2007-06-07 (first published: 2005-05-25)
441 reads
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers