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...

Okay, I'm a little confused. I thought you said it was the Dynamic NAV client that was doing the insert, now you're saying it's not.

If it's not the Dynamic NAV...

Let me ask this first. Have you searched the internet for possible solutions yet?

If so, what search phrase / words did you use?

josuecalvo (9/14/2012)

---

What you are asking for is called regex. Google it, there are plenty of very good sites about it. I do not think I can improve its flexibility, so...

jrichards54 (9/14/2012)

---

I have just made two more attempts at installing SQL Server 2005 but was unable to even get SP4 installed successfully. All the steps that I took are recorded...

CREATE TABLE is a control permission, not an alter permission. Alter is implied by having control.

Use this:

GRANT CONTROL ON SCHEMA::<mySchema> TO <myLogin>

You can only use the "CREATE TABLE" permission specifically...

Read this link for reasons why Lynn chose 103 and what all those numbers mean:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

kriki-503680 (9/14/2012)

---

Thank you for your reply.

No, I am talking about database snapshots.

And no, they are not writeable. It just happens that the Dynamics NAV-client decided to write some record to...

I was unaware that database snapshots were writable. Everything I've ever learned is that only the engine can write to a db snapshot and everyone else can only read off...