Lynn

the batch processing trick worked well with me and asavd lot of time. thank you. From your query does the @@rowcount gives the number records updated, do u think if...

All my databases are in SIMPLE mode.

Thanks .

when running this query does the transaction log will be free for every 100,000 recrods? I am just trying to get how this will improve performace when compared to...

here is the query that updates 90million records

update dbo.Rev

set planid = cast(rate.state as varchar(2))

from dbo.Rev as a left join STATE_LOOKUP_STATE5.dbo.ratefieldlookup as rate on a.revcode = rate.rev and

ltrim(rtrim(a.hmrevid)) = rate.hmrevid and...

If i have 90million records can that be updated in some bathces so that other process can also run and transaction log will not grow. if i have a table...

disable? do you mean disableing the windows login or is in sql server at server level to disable it.

Here is my idea.

1. find out objects,schemas etc owned by user1

2. change ownership to my name

3.delete the account

can this process make the process run good after deleting. I am concerened...

Cannot add rows to sysdepends for the current object because it depends on the missing object 'sp_hexadecimal'. The object will still be created.

Cannot add rows to sysdepends for the current...

Brain

I have a question on your post. If EXECUTE AS can be used to run a store proc where a developer dont have rights to do, then doies it mean...

Brain

could you let me know how that can be modified in this query

http://technet.microsoft.com/en-us/library/bb838727.aspx

I was just wondering if i can use database mirroring in this scenario.

still doesnt work to pull user list from AD.

That User is windows account associated with the windows group. I gave access to the group so that they can exec store proc.

Yes, I just gave permission to to those tables and EXEC to the proc. Can you pls let me know what permissions they need to run this rebuild job.

Here is the exact error mesg.

Executed as user: StatePA\PZarah. Cannot find the object "dbo.Rev2001" because it does not exist or you do not have permissions. [SQLSTATE 42000] (Error 1088). ...