set up the max server memory

sp_configure 'max server memory(MB)',3000

reconfigure with override

sql profile trace result like below when I am using management studio to update record. from the trace, I can see it was really tring to update only one resoce...

WayneS (5/4/2009)

---

I think at this point that we're going to need to see the data being modified. It would also help to see the table structure, and the command(s) being...

Yes, they are working.

No Triggers

Thanks Sunny. I will read the articles.

sunny Brook (4/20/2009)

---

It should if restarting SQL services is all that it needs to get working.

BTW, I am having same errors as you were trying to fix. but our SQL...

Thanks you!...

Try this,

1. create @temp table ( )

2. insert into @temp

select colunmlist from linkserver.dbname.dbo.tablename.

This is a good and simple article about how to build cluster using virtual server.

http://blogs.msdn.com/blakhani/archive/2008/06/12/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-4.aspx

John Mitchell (4/8/2009)

---

Judy

From the link you posted:

[font="Tahoma"]Locking pages in memory is not required on 64-bit operating systems.[/font]

You shouldn't need to use AWE in a 64-bit environment.

John

Edit: I've reread your...

I met the one case related to Agent XPs. It might be one of the reasons.

I used to have SQL server 2005 standard Edition 32bit which was started as local...

Can you make sure the port 1911 is open and server is listening on this port.

go command line and type "netstat -an", if you can find this port number...

No. I have set up database mirroring on SQL server 2005 standard edition without witness server.

Finally, I made it working after the new rule was added to firewall.

thanks for all your help.