Are you typing in Account Name: domain\user?

If you're not on the...

They are listed as separate jobs in SQL Agent Jobs.

You have to open each one and change the owner to a new AD user.

or this

http://www.sqlservercentral.com/Forums/Topic564492-150-1.aspx

This is why I extracted the data from our CRM database, and imported the views into Access. This way I can recreate the Shop Traveler that we use right now...

Very Impressive :). Really cool and works on 2008 and 2012 SSMS.

Thank you

vanamali (5/7/2014)

---

Hi,

Everywhere somebody talks about logging a different way in SSIS packages. What is the best way to log the trace and errors. I am confused and not...

Jack Corbett (5/5/2014)

---

I've been asked to research auditing products for SQL Server, currently a mostly 2008 R2 environment. I'm wondering what people out there are using and...

aaron.floyd (5/2/2014)

---

I have, it runs as SA in SSMS. The Job runs as SA as well. The job would fail if there were invalid permissions. That isnt...

Wait what's the service account for sql agent...

Can you execute the exact same code from managements studio in a query window with the SQL Agent service account?

You may have another process accessing this table.

Check and wait or kill

SELECT

t1.resource_type,

t1.resource_database_id,

t1.resource_associated_entity_id,

t1.request_mode,

t1.request_session_id,

t2.blocking_session_id,

o1.name 'object name',

o1.type_desc 'object descr',

p1.partition_id 'partition id',

p1.rows 'partition/page rows',

a1.type_desc 'index descr',

a1.container_id 'index/page container_id'

FROM sys.dm_tran_locks as t1

INNER JOIN sys.dm_os_waiting_tasks as...

Oops double post.

You can configure central management server (CMS). Add all your SQL Servers and write a dynamic script to restore.

https://www.simple-talk.com/sql/backup-and-recovery/centralized-management-tips-for-managing-backups-on-multiple-servers/

If you only see nulls in areacode and phonenumber you can get rid of them with temp table like john mentioned

select into #t1

from @somedata where AreaCode is not null...