Ok I agree with your first step & Already uninstalled sql server on it

For the Second Point , If I installed SQL Server services on it , it will...

One mistake was there

I executed that query

DBCC CheckDB('KM_Others_Testing', repair_allow_data_loss) with No_Infomsgs , All_errormsgs

And it executed successfully without any error

regards

ghanshyam

Hi

When I again execute following command

DBCC CheckDB('KM_Others_Testing') with No_Infomsgs , All_errormsgs

it's executed successfully without showing any error message

& according to u , it is not pointing to...

Hi

Ok I will do it

Could u help me out in one more thing that from following error messgare

Extent (6:5008984) which table or index is using this page...

Hi

Same output

Extent (6:5008984) in database ID 51 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

CHECKDB found 1 allocation errors and 0 consistency errors...

your means , SQL SERVER will consume whole memory configured on WINDOWS Box even if we set max server memory using AWE

Regards

Ghanshyam

Hi

Let me explain the situaton.

We have 2 Node Active Passive Cluster installed , Now our Appilication developer are going to apply SP 2 on Sharepoint application that will...

yes , master is the default db for this user

Thanks

ghanshyam

Hi

Even I have assigned master DB as DB_owner for this login also , Still Same error

Thanks

Ghanshyam

Thanks

Actually I want to know that

single database file (mdf,ldf) can have ownership from two instances

e.g. In oracle , two oracle instances can access single database at the...

Thanks

Yes i was not having sysadmin right

Thanks

Ghanshyam

I have checked with ping command and both are connection

I also use port no like this 122.45.34.12\sqlexpress,4567 in sp_addlinkedserver

Thanks

Sir

I am having 2 GB RAM

Thanks

Ghanshyam

Sir

If I Enabled AWE on Windows server 2003 Standard Edition , Can I Use more than 4 GB RAM