Well, the thread appears to be locked, so I can't reply, but:

Celko

---

First, email is so obviously not a natural key for a human being that I'm always shocked when people...

Ray K (9/21/2012)

---

pvanitallie (9/20/2012)

---

I have been looking for something in a Visual Studio-type product as a way to convert an existing MS Access Front End to a SQL Server back...

MysteryJimbo (9/21/2012)

---

Brandie Tarvin (2/11/2011)

---

I almost forgot to add my favorite Access activity. Creating new tables in Access that aren't in SQL Server (without telling anyone), than getting upset when another...

Thanks, guys. I'll take a look at those.

FYI, there's a "new" IE flaw: http://redmondmag.com/articles/2012/09/18/ie-flaw-being-actively-exploited.aspx

HowardW (9/20/2012)

---

Brandie Tarvin (9/19/2012)

---

Yep.

My current drama...

Lynn Pettis (9/19/2012)

---

Brandie Tarvin (9/19/2012)

---

Yep.

My current...

Yep.

My current drama is trying to...

Grant Fritchey (9/19/2012)

---

Brandie Tarvin (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink...

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink Db

5. Rebuild index

6. Update...

How many statuses do you have? If it's 10 or less, your performance may be increased if you switch that WHERE clause to say something like Status IN ('Active','Expired',...'n').

Ah, a mystery unraveled. Thank you for clarifying, Anthony. That helps my understanding of the issue somewhat.

But if Dynamics NAV is a Microsoft product, they should be smart enough to understand the difference between a snapshot and a real database. It's simple enough for anyone to...

Glad we could help. Enjoy your learning.

It doesn't make sense to me that a client tool outside of the actual SQL engine would be inserting data into a database snapshot. I do think you should call...

FYI: When you try to connect to the Local instance, it's not supposed to be connected as MSSQLServer(Local). It's just (local).

But first you need to get your remote connections...