I guess it was to generate a...

Hmmm...true. 🙂 Ran it very quickly on my box as well.

I discovered one more way to create a big table a day or so after submitting my script. Create...

For all DBA's here who have the ears of any influential people at Microsoft, for the sake of all that is good and pure in this world, have them deprecate...

Try this, it's something I wrote to automate a program that could be optimized on number of processors used:

create procedure num_processors

as

set nocount on

declare @numprocs int

create table #numprocs

(

id int,

colname varchar(128),

IV int,

CV...

Hmmm...thanks. I guess that would be the best way in general. While security can sometimes be complicated, don't make it more complicated than it has to. So...

Thanks very much, that helped quite a bit.

Gaby

Gail, here's the original code. It's totally different from the first example I gave except the sp_executesql part.

set @ctr = 1

while @ctr <= @numdb

begin

select @dbname = dbname from @names...

Hmmm...that gave me an error, the reason being that @db only exists in the context of @sqlstring so when I build it outside, I get those errors.

On another note, here's...