Thanks but may i know the reason for it and why pointer is move to third row in my screen shot thanks again

Please can i have some one expert guidance here..!!

can u give me any example please....i am saying that suppose

create table test1 (name varchar(20), age int)

is create so by any mode apart from gui i can check its...

now my msdb db and model database is not showing in system database list . and these three logins are present

1--BUILTIN\Administrators

2--HHH-5DFJV6HTEAZ\Administrator

3--sa

dont know what happened please give valuable suggestion does...

thanks for your support but please give me exact script solution if possible

thanks for getting me that point master database was selected as default at that point so not getting data now got the data thanks a lot....i need one more...

But i was using this query only (alter index IX_TXNDATE_SRVID on transactions

reorganize;) ...

please some give me the valid answer please...

:unsure:

Sir i use this query to reorganize

alter index IX_TXNDATE_SRVID on transactions

reorganize;

Dear All

Waiting for your valuable suggestion one more question in my mind i have ...does the reorganizing one of table will decrease the fragmentation for other index also..please reply:-)

Thanks Lynn Pettis i check the syntax of select now my doubt is clear thanks for your great support god bless you ....

thanks lynn i got your point i understand it but the only confusion was that we are typing

SELECT -- Have SQL return something to me

8...

how can i explain it to you dear just want to know that mechanism behind execution of that query why any number is returned number of times rows...

thanks for your reply dear i have not make any mistake in pressing the shift key it will return number of rows present on that table what so ever number...

please tell me how to give full permission right to that folder,i have to give any sql server permission like login account or some thing like that bcz my...

thanks a lot bro for ur support ......

Regards

Anshu