Viewing 15 posts - 3,946 through 3,960 (of 9,715 total)
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
Read this link for reasons why Lynn chose 103 and what all those numbers mean:
September 14, 2012 at 12:08 pm
kriki-503680 (9/14/2012)
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...
September 14, 2012 at 11:42 am
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...
September 14, 2012 at 9:46 am
devullapallymanidhar (9/14/2012)
for example (A,B,C,D) and we mirror them to...
September 14, 2012 at 9:44 am
There are any number of FTP utilities you can use to accomplish this. Once you get the file onto the dev environment, decrypt it and put it into another location...
September 14, 2012 at 9:34 am
Okay, try this on for size (it's just a wag, but...)
The order of query evaluation is supposed to be:
1) FROM
2) ON
3) JOIN
But the FROM clause is a CROSS JOIN, which...
September 14, 2012 at 8:06 am
The execution plans on both of them are identical. Same objects, same percentages. (Once I swap the tables in the FROM clause, that is). Same results, same everything.
But wouldn't something...
September 14, 2012 at 7:53 am
Viewing 15 posts - 3,946 through 3,960 (of 9,715 total)