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

2007-06-20 (first published: )

216 reads

Search any object across db's ..made simple

I just saw a script on this site for object search across the db's. I have written an alternate version with sp_msforeachdb undocumented sp which is much simpler.This avoids a lot of code and dynamic sql.Replace "object_name" with the name of the object which needs to be searched across the databases.

2006-10-17 (first published: )

167 reads

Blogs

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Read the latest Blogs

Forums

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Need to do it

By florant

Hi everyone! The inner world is very difficult, but you need to step over...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers