Should I open another case?

Otherwise, can anyone tell me how to export SP by using T-SQL ?

Thanks.

Yes, please.

Thanks again.

I got the idea already.

How about moving SPs between databases of the same server (or different) using T-SQL?

Thank you again for the response.

I do not have to move all tables of the database, but I have a list which I would do in a loop.

If you do...

Is it possible to use T-SQL only?

If the above is yes, could you please show me how to copy (structure + data) table (Table A) from ServerA to ServerB ?

T-SQL...

yes, sir!

Thanks!

Thanks again first.

1. If there is only one index (no partitioned table) allowed, MAX(rows) would get the "count(*)" provided other indexes are zero. Just want to clarify/learn for curiosity.

2....

It's sinking below the top, still .. hoping to get response ..

Anyone from the dark guides me through the dark ?

Thanks.

As a rookie, I'm back for two more questions -

1. As explained before, indid --> index ID

a. is there only a row count (number) anytime...

All right guys, I got it. Thanks !!!:-)

I would like to ask a last question before I close this subject.

Is there any other cases that if I use MAX(rows) for the same tablename I would not get...

Lot of information, thank you ALL!

Thanks.

I need to backup a database (dbAA to \\server001\DBbackups\dbAA.BAK) on server001 and copy dbAA.BAK to \\server002\DBbackups\dbAA.BAK.

First action needs a "BACKUP DATABASE ....." ans second needs a DOS action "COPY \\server001\DBbackups\dbAA.BAK...