It is not just you. I went back and read the first article so i would be ready for this second one. I am the same place you are, I...

Thanks. You are always so helpful!

Yes that's exactly what i mean. Can you point me in the direction as to how to figure out which one they are? If they are chached shells, how long...

NJ-DBA (11/4/2011)

---

HI Jimmy,

If I correctly understand your problem, I'm pretty sure this is exactly the purpose of SQL Agent Proxies: http://msdn.microsoft.com/en-us/library/ms189064.aspx%5B/quote%5D

I know about proxies. But they are...

okbangas (10/11/2011)

---

This does indeed happen on both SQL Server 2008 R2 (RTM) and SQL Server 2008 SP2:

use tempdb;

go

create table t1 (

id int identity primary key,

val varchar(10)

);

create...

Nadrek (10/10/2011)

---

"I dropped all the foreign key constraints to this table on the handful of tables referencing it. I dropped the index, and then I added the foreign keys references...

serejka058 (10/10/2011)

---

I recently had this problem on SQL Server 2005 SP2 and SP3, and in my case the reason was that there were two identical indexes on a table:

-1st...

Thanks for reading the article. Atlanta is a little far for for me, but i hear there is one in Pensacola, FL every year but it was a couple of...

If you do find that you have too many vlogs in your tlog how can you reduce the number of vlogs.What comes to mind is set the database to simple,...

Can you use the UI to script out your linked server and post it here? That might help me understand your configuration.

Gail,

I ran into this. I don't need help resolving, but I did want to know if you found where the behavior is documented. This is my scenario.

Create table called main...

I would like to see online index rebuilds as part of the standard edition. Also i would like to see the code based changed so you do not have to...

As a quick fix, try using the with (nolock) query hint on your select statements. Many apps are not affected by dirty reads so this may be an option.

Gail,

Thanks, I was looking at the same lines in the default trace. I saw the object:deleted, but did not put together with the object type to prove that was when...

Thanks, this will work for me!