Scripts

Technical Article

Get DBObjects with Specified Owner

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-06-21 (first published: )

322 reads

Technical Article

Non repetable random number generation script

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-06-20 (first published: )

267 reads

Technical Article

Add Enterprise Manager registrations quickly

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-06-19 (first published: )

334 reads

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2007-06-14 (first published: )

1,953 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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2007-06-13 (first published: )

1,900 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: )

509 reads

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers