thanks

1. The table has only 4 coulmmns, no FK, constrains etc.

2. The table is used 24 hours, and about 2000 users use it all the time.

3. When I use GUI...

The following procedure is OK?

1. Create Table [backup12212009] with BIGINT Indentity

2. using SSIS export data from old table to [backup12212009]

3. Delete old table

4. Rename backup12212009

Can do as above?

Thank you guys for your helps.

thank you CirquedeSQLeil. This is what exactly I needed. Thanks for the link.

thanks for your replies; But it did not help me.

I have a DB with one signle mdf file and one logfile (size 500GB). What is the procedures to have the...

yes it will be in simple mode;

Thanks for your replies; But the replies does not help me much; Assume that the enviroment is going to be set up new; and there should not be any problems...

Thaks a lot; WAV file idea will work for what I need; That a lot guys; simply great;

samuel

The model is: Motorola MOTO Q™ 9c ; verizon wireless

picture:

http://www.verizonwireless.com/b2c/store/accessory?action=selectPhone&phoneId=3765&archetypeId=11088

I need a long rining tone; any way thanks for your help; I will contact the Coustomer Serivce of...

Jonathan;

I am OK with SMS; that is what I am using now; The only problem is ring tone; when I am sleeping I want something to ring for a long...

Jonathan;

Thanks; I will look into the tool;

Then what idea most of the people do to notifiy SQL DB alerts?

RBarryYoung

Thanks for your reply; Can you know of any software you experience with;?

RBarryYoung

Thanks; even if I get in table thru win service; I still need to do something extra to...

Thanks again; I will go thru your tips;

Thanks for your reply; your reply me a confidence; I will tune distributor; I am doing a pull down trans. repl; Distri. to subs. takes a long time; 7hrs to...