from the sql log if it says " database "EMP " is starting up does it mean the server or computer was restarted ?

Also i dont see any sql logs...

Its not blank but i see " NULL" as db owner and i did not copy this form any other servers and these database are 2 yrs old and there...

I see few database where the db owner is "NULL ", i am not sure how this happened may this is casuing the error.

any help to know the reason why...

how critical is this error with respect to sql server running smoothly ?

but how do i find what database or object is causing this problem.

quick question :

if i dont see any log for few hrs on sql server does it mean that...

i tried the option in security tab " Be made using the security context " and passed on sql login and pswd and it works but i think this will...

I did not get all users listed in the active directory group by runing this..

EXEC xp_logininfo 'State_CO\Programmers' ,'members'

I still miss some users in the result though i see them...

As i have to run the same update from 6 different server/databases having same table, is there a way i can loop through all in single procedure or something.

paul

can i stil use group by SrcKey on ECA table ? does it update the same .

How about pulling all srckey values where memkey are null into a temp table an

select srckey into #t from Emp_CA where memkey is null group by srckey

then do an update...

table names might be mis spelled wantedly but i just need logic. here is the structure of tables

table1 = OBBEVAER.MemberList(SrcKey,MemKey,state,empno)

table2 = Production.Emp_CA(SrcKey,MemKey,State,empno)

there are null values for MemKey in table1 but...

I want to update memkey,state and empno in table Emp_CA where memekey is found with null value. these 3 columns should be updated from the table OBBEAVER.dbo.memberlist whic also has...

query may be wrong for update, but my goal is to update 3 columns in table Emp_CA

select memkey into #t from dbo.Emp_CA where zen_memkey is null group by srckey

update zen_memkey.zen_memkey,zen_memkey.state,zen_memkey.empno

from...

Irrespective of the size of db and indexes, how would i run this update for multiple columns with above criteria in a single sql statement.

any reply... need to update multiple columns in a single update statement.