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

2007-06-20 (first published: )

219 reads

Technical Article

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: )

171 reads

Blogs

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Read the latest Blogs

Forums

SQL Query Question

By Siva Ramasamy

Hello everyone, Thank you for looking into my question. I have a dataset like...

"Frankenrows"

By julian.fletcher

I'm not sure if that's the correct term for what we're seeing here, but...

SQL Express Install

By lukutu

So I'm not sure whats going on but I've been trying to install SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers