Jscript to obscure emails from robots in HTML

This script will obscure email addresses from robots even ones that ignore the tags to not snoop. Usually robots that ignore the tags, and the robots.txt file are used by spammers. They pull down the SOURCE of your page and scrape the email addresses from them. This script breaks the mail href into its base […]

2003-03-23

84 reads

Search All Columns in All Tables for a string

This procedure can search all columns in one or all tables for a specified string. Prints out the TableName.ColumnName that the string is found in...--     Example Calls--     EXECUTE spFindTextInColumns MyTable, 'tcart' --search a specific table--         --     EXECUTE spFindTextInColumns default, 'tcart' --search all tables BUG FIX : (2003/01/20) Changed SELECT @columnName […]

3 (2)

2003-01-09

697 reads

Net Send

Yee Haa, as if we couldn't annoy our users more with message boxes, emails, and other friendly pop ups ;P here comes the net send. Has a test for success to determine if the send worked. If an invalid name is entered it can take a bit to fail, so don't use this from a […]

2002-12-18

210 reads

Dynamic String Compare (W/O the dynamic sql)

Purpose: To compare two strings with a supplied operator and return true if the strings evaluate to true using the operator provided. This is useful for stored procs to use instead of dynamic sql. YAY!  Allowing for the operator and value to be passed in as parms. So that the user on the front end […]

2002-12-07

365 reads

Setting permissions (Updated: UDF's now set)

Here is a script I wrote to automate updating of permission on a database. Often running as sa I forget to set the rights for objects when distributing db objects. It provides the capability to process only certain object types, and whether or not to print and execute the persmissions change or just print out […]

2002-11-22

429 reads

Split Delimited String (Updated: Multi char delimeters)

This UDF will take a delimited string and split it into a table. It has an identity field that is provided solely for uniqueness on the rows, but that can be removed to improve the speed, and optimize it. Sample call :dbo.fnSplit(, )@Data - the string to split apart@Delimiter - the seperator string, if DEFAULT […]

2002-11-15

1,091 reads

Blogs

Using Azure Data Factory Mapping Data Flows to populate Data Vault

By

(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure...

New Azure “SQL Server settings” blade in the Azure Portal

By

I just noticed today that there is a new blade in the Azure portal...

Mass Backup All Sessions

By

Migrating Extended Event Sessions from one server to another should be a simple task....

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Buffer Pool calculation

By avpco

Hello Colleagues. Could you tell me about how MS SQL Server 2016 SE determines...

SSIS Scale out deployment in a high availability cluster

By KobusV

Good day all, Just wondering if it will be possible to have a scale-out...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers