This is a first version of a custom solution for SQL Server log shipping using VB.NET 2005 and .NET Framework v.2.0. The script has to run on a server where you have SQL Server 2005 (or at least tools) installed because it uses new SMO. For some functions of the script you will have to […]
2007-06-22 (first published: 2006-06-05)
1,138 reads
Hi,exec sp_change_users_login 'report' displays the list of orphan USERS in a database but we don't have any builtin SP which displays the orphan LOGINS.By Orphan Logins (not users), I mean the Logins that don't have any access to any databases and are sitting idle on the server (also aren't member of any fixed server role).We […]
2007-06-21
276 reads
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]
2007-06-21 (first published: 2006-01-30)
297 reads
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)
245 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)
298 reads
This script will give detials for all the enabled job including their steps/command/schedule.
2007-06-18 (first published: 2006-05-26)
895 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)
429 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,923 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,849 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)
470 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers