Additional Articles


Technical Article

Use of regular expressions in TSQL

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) […]

5 (2)

You rated this post out of 5. Change rating

2007-06-14 (first published: )

1,907 reads

Technical Article

SP_WHO_3 Powerful Filtering/Sorting Very Efficient

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 […]

5 (2)

You rated this post out of 5. Change rating

2007-06-13 (first published: )

1,794 reads

Technical Article

ActiveX - Clean Up Unused Connections

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.

You rated this post out of 5. Change rating

2007-06-12 (first published: )

462 reads

Technical Article

Distribution of Enterprise Manager registrations

This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]

5 (1)

You rated this post out of 5. Change rating

2007-06-05 (first published: )

894 reads

Technical Article

Script to perform http(s) post

Post data as coming from an HTML FORM with METHOD=POST to an URL and retrieve the result. The script uses the WinHttp.WinHttpRequest.5.1 object.Call like :exec dbo.usp_httppost 'http://www.sqlservercentral.com/search/turbo.asp','searchstring=ftp&btnG= Go &cArticles=on&cForums=on&cScripts=on&sitesearch=http://www.sqlservercentral.com'

5 (1)

You rated this post out of 5. Change rating

2007-05-30 (first published: )

1,744 reads

Technical Article

how to start a program like Notepad.exe in a job

sometime I need to kill an program which does not continue to process data, and i sheduled a job to do that. After lots of times' try, I made it at last.This script add a shedule to the sheduled task list, one minutes later then the current system time. You can change it by edit […]

4 (1)

You rated this post out of 5. Change rating

2007-02-28 (first published: )

216 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

Database copy issue through - COPY DB WIZARD

By Kaushik Parui

I have a production server with SQL server 2016 version (13.0.5026.0) and a database...

Help with a SQL Unpivot

By rogue1009

I am trying to use unpivot to extract some data, however, the results are...

how to de escalte a isolation level, and are there any implications.

By rajemessage 14195

hi, I have one nested transaction and want to deescalate to outer  transaction's isolation/...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers