Viewing 15 posts - 166 through 180 (of 429 total)
anthony.green (3/14/2012)
March 14, 2012 at 7:33 am
Koen Verbeeck (3/14/2012)
Are server A and B in the same domain?
Both the servers are in the same domain. One is running under a local account and other is running under...
March 14, 2012 at 6:50 am
Koen Verbeeck (3/14/2012)
Ah ok. Maybe change the owner of the job to another account than sa?sa is a built-in account, so that also uses the local system account for connecting.
I...
March 14, 2012 at 6:26 am
Also, in the microsoft link, it is mentioned that:
Job steps that execute Transact-SQL do not use SQL Server Agent proxies. Transact-SQL job steps run in the security context of the...
March 14, 2012 at 5:17 am
Koen Verbeeck (3/14/2012)
create a proxy through TSQL, or use the Management Studio Interface.
I think the last one will be the easiest.
At which step did you get that...
March 14, 2012 at 5:04 am
Thanks for your link above. To create a proxy, I needed to create a credential but while creating a credential, I got an error:
an error occured during decryption Error: 15466...
March 14, 2012 at 4:57 am
Koen Verbeeck (3/14/2012)
Sure you can solve it. Do not use the local system account 🙂Or execute the job through a proxy.
🙂
I cannot change the local system...
March 14, 2012 at 4:46 am
Perry Whittle (2/29/2012)
full machine backup and subsequent restore to the physical box would be my chosen avenue
How do we do that. Is this something done by a sysadmin and not...
March 1, 2012 at 12:26 am
Thanks Paul for taking time out of your schedule and giving such a detailed explanation. Unfortunately, when a lot of DBAs like me enter the world of already established databases...
January 13, 2012 at 1:58 am
SQL Kiwi (1/12/2012)
Grant Fritchey (1/12/2012)
Ouch. I didn't catch the date types. Good one Paul.
It's not at all evident from the plan - I only came across it after running the...
January 13, 2012 at 12:09 am
Cadavre (1/12/2012)
Read through this link[/url] to find out how best to post your performance related question.
Also, DDL may be...
January 12, 2012 at 5:51 am
Jeff Moden (1/3/2012)
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Jeff Moden (1/3/2012)
January 3, 2012 at 7:06 am
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Jeff Moden (1/3/2012)
Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An UPDATE might not even "touch" any of the indexes.
Jeff,
Can you...
January 3, 2012 at 5:49 am
Jeff Moden (1/3/2012)
Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An UPDATE might not even "touch" any of the indexes.
Jeff,
Can you please write few more...
January 3, 2012 at 5:37 am
Viewing 15 posts - 166 through 180 (of 429 total)