You are right i made a mistake that should not happened.

Actually this is my Pre-production database not production that's why i tried to use all possible options without knowing the...

Thanks for your reply .

Yes its a same database but executed below command after that i got the result which i sent you.

DBCC CHECKDB (prod_lrpdb, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;

If i...

please find the below result which consist only errors related information.

Msg 2533, Level 16, State 1, Line 2

Table error: page (1:22394785) allocated to object ID 316735310, index ID 0, partition...

Thanks for reply but the link you shared is no longer available.

i am worried this Db corruption due to hardware failure or other reasons.

please guide i will thank to you.

Hi,

As per your recommendations i have configured 42 GB of RAM of my server1 out of 48 GB.

i restarted the services and checked every thing is running fine but when...

Thanks for your precious comments !

Thanks for your prompt reply , if i got the right point from you that i need to setup the min and max server memory around 42 GB out of...

Yes you are correct , i am going to change node name .....

Hi,

Thanks for your reply.

can i do the same job via management Studio ???

Regards

Syed

Hi Jhon

its wonderfull thing , now i got the desired result

thank you so much for this efforts.

Regar

thanks for this

i am using sp_helplogins , but i need to execute on every server and database .

i made this query but not able to get permission.

select a.dbid,a.name as...

Dear thank you so much for prompt reply but still i am confuse

simply i want to make a list of all DB/Windows users having with all permission.

for example...

thank you so much my dear its really great script

i havn't words for you

Best take care of your self

Regards

Syed Muhammad Naveed

Dear

as i understand that you wana copy copy/ftp the data from source server to destination server

but before sending/ftp/copying the data on destination server you need to confirm that...

yes its a compulsion u have to have a physical connectivity through pair to pair wire connection if you r working on LAN or just copy your data from hard...