serach this table....its right there....master..sysprocesses

select spid,nt_username from master..sysprocesses

or

select system_user

64 kb size is what recommended....

move pagefile to his own drive to avoid fragmentation....

here's the process..easy google search

http://www.sqlservercentral.com/articles/Administration/2605/

backup source db's

start target sql in single user mode

open a session and retore these db's one by one, master,msdb,model

restart sql server normal....

Matt Miller (12/4/2007)

---

Since we talking wish lists - perhaps use that to somehow bring out those threads that used to get the old Moderator's "this hasn't been answered - please...

this...

Mirror is not good for STD edition cause it does not allow asynchronos transaction(transaction is not commited unless both servers are updated)....check limitations of sql edition for the same...

i know...

run sp_who also....

ideally there should be many records......

try running with nolock clause also

still same then post ur queries and sql servre versions details or anything which u think can...

i leave it to you to check...lemme know if any problem

try....

Select *

from (table)

Where field = 1

which os?

what sequence you followed and what the current status??

did u check installation logs?

you were not detailed...

best scenerio applicable to you....

Do cluster on site A....and do transactional replication on siteB

2005 std edition supports both above....std edition does not support log shipping, or...

what exactly u wanna prove? would liek to elaborate?

Use coalesce to have all this in one statement....

somethinglike this...

update MCPage1 set

lname=coalesce(@lname,lname) ,

fname=coalesce( fname,fname)

where MemberID=@MemberID