thanks i got the idea

yes, infact both the databases are in the same instances (it is specific to application requirement)... and MSDTC is running

pls help

and finally i need to take this output to a file (query analyzer, execute mode -- results to file) also and in that case results in grid may not work

Ok, first of all i may not be able to decide the size (eg. varchar(20)) in  advance, it depends on the user inputs in the table.

on more thing is command like...

gabor,

ok you mean to say if there is no clustered index, defagramentation is not required right ?

hai hoo-t,

Ok your suggestion is great abd appreciable..

But the fact is the the table is having Non-clustered  index...

Truncate log will not reduce the physical log size... it will mark all transaction which are not required for recovery as incative log...Once you issue dbcc shrinkfile command your log size...

Ok this helped me

Greate.. thanks a lot

but what actully this set fmt only off does... i am not able relate this result with what is written in BOL

but i am getting the error while executing the query

select * from openquery(general,'set fmtonly off;exec master.dbo.sp_helpdb')

Server: Msg 7411, Level 16, State 1, Line 1

Server 'general' is not configured for DATA...

See Default it will show all the processors available in the system and all of them will be selected (used) by default.

Here SQL is giving you a choice of how...

Maximum memory SQL Server Std edition can support is 2GB and i think it inclueds Physical + Virtual

Ok, thanx

Hai gbn,

No, i am not using AWE (run value is '0'). infact my OS is Windows 2003 Enterprise Edition (64 bit) running on Itanium based processor machine , in this...

I had problem when i was trying to expand the Database Plus sigin in EM and the problem gt solved when reduce the size of the log.

connection problem also can...