ALTER TABLE tbl_open_order

ADD rownum int NULL

or

ALTER TABLE tbl_open_order

ADD rownum bigint NULL

Depending on the number of bytes you need for the integer. NULL is necessary if you have rows until you...

If I post in a thread, it auto-subscribes me to receive notifications. But I'm like Thomas, I've not seen anywhere to subscribe to a whole topic.

Moderator functionality doesn't seem to work (Moderator CP).

I'm having the same issue as far as the editor is concerned. Sometimes I have to refresh the reply screen a few times before I'm able to edit. I know...

Yup. The question on the table is "Was there a limit to the number of text columns in SQL Server 4.2?" SQL Server 4.2 had text column entries starting from...

When the possibility exists, use Windows authentication to assign security. The best way to handle this is:

1. Create a Windows group for the DBAs
2. Put all of the DBA Windows accounts in...

For fixed server roles: sp_helpsrvrolemember

For database roles (fixed or user): sp_helprolemember   [This one must be run in the database]

The db_ddladmin fixed database role is the minimum level of rights needed to accomplish this. A user with such rights would have to make sure to specify the owner in...

I agree, very nice! Although the new avatars means Frank can scare all of us with that shark!

One thing I noticed, sometimes you'll have to manually set the language to English as it defaults back to Russian. For instance, if you aren't logged in and you follow...

It should run with no issues at all.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Apparently under SQL Server 4.2 if you had multiple text columns it would count down from 255:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;75191

This isn't the behavior in SQL Server 2000, so it's probably a hold-over. Out...

According to Inside SQL Server 2000 the allowable values for non-clusted indexes in the indid column is 2 to 250. That leaves 249 values. Not sure what happened with 251-254....

How can I check that? I am a new user to the MS Sql Server. Can u pl. guide me, that on the NT Server where I can find that? Thru'...

What service account does SQL Server run under? Local SYSTEM or a created user account?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/