Viewing 15 posts - 3,946 through 3,960 (of 9,722 total)
Lynn Pettis (9/19/2012)
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/2012)
Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't listening?
Yep.
My current...
September 19, 2012 at 11:09 am
Lynn Pettis (9/19/2012)
Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't listening?
Yep.
My current drama is trying to...
September 19, 2012 at 9:42 am
Grant Fritchey (9/19/2012)
Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink...
September 19, 2012 at 7:31 am
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update...
September 19, 2012 at 7:07 am
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').
September 19, 2012 at 4:41 am
Ah, a mystery unraveled. Thank you for clarifying, Anthony. That helps my understanding of the issue somewhat.
September 18, 2012 at 7:37 am
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...
September 18, 2012 at 7:15 am
Glad we could help. Enjoy your learning.
September 18, 2012 at 4:29 am
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...
September 17, 2012 at 10:37 am
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...
September 17, 2012 at 4:58 am
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...
September 17, 2012 at 4:42 am
Let me ask this first. Have you searched the internet for possible solutions yet?
If so, what search phrase / words did you use?
September 17, 2012 at 4:39 am
josuecalvo (9/14/2012)
September 17, 2012 at 4:34 am
jrichards54 (9/14/2012)
September 14, 2012 at 12:30 pm
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...
September 14, 2012 at 12:14 pm
Viewing 15 posts - 3,946 through 3,960 (of 9,722 total)