All,

Thanks for your help.. The requirement for generating this numbers is not to be used for any database operations. Another application requires data (in a file) in this format:

AB1

AB2

AB3

AB4

AB5

AB51

AB52

AB53

AB6

AB61

AB66

AB67

AB68

AB69

AB70

TR1

TR2

TR3

....

....

TEF1230

TEF1231

TEF1232

TEF1237

....

..

As you...

Thank you.. This is great.

One question though.. I cannot seem to get it working when the numbers are really large. For example,

select count(*) from dbo.F_TABLE_NUMBER_RANGE(1,999999999)

returns zero rows because of the...

Thank you Robert!

Merry Christmas and Happy Holidays to all!

-Ganesh

Robert,

Thanks for the reply and code piece. However, PatIndex returns 0 even for this..

Declare @val varchar(128)

Set @val = 'i&&35iC4io'

Select PatIndex('%[^0-9a-z[_]]%', @val)

Can you help?.

Thanks,

Ganesh

Ramesh,

Yes you can use variables in CTEs.

Ganesh

Thanks for the reply, Peter. That was the only way I would make it work; treat the Sp_Oa SPs like any other SP for permissions. But why does BOL says that...

If you had seen the @sql value just before executing it, you will know whats wrong.

You have to have another single quote in front of each variable. Something like this:

set...

Sorry, worng forum.. Created another one in "General".

I think you have to apply the latest SQL Server Service Pack (SP4) though the problem was fixed even earlier.

http://www.kbalertz.com/kb_872939.aspx

Ganesh

I do not think "select into" can create constraints as well. It can only get data.

The best option for you will be to first script your table and create them at...

Yes, I can implement Security in the database, but at the same time, I would still like NOT to send such "drop" commands to the database and would like to interpret before...

wz700,

Thanks for the reply. Yes, "sp_depends" did help me for the Stored Procedure and other objects in the database.

It helped me for one half of the problem. Can you please...

Hi,

Thanks, but that is not what I want. I want to know just the "NAME" of the "tables" involved in the query not the joined results or the data...

Hi Steve,

Could you please help me (with code snippets!) in determining the # of logical and physical processors in Windows 2003?.

Thanks,

Ganesh

Hi Brian,

Thanks for your reply. I did go thru the docs. Is there a programatical way to determine the physical count of the processors in the OS?. Our application is .NET...