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

devullapallymanidhar (9/14/2012)

---

I have a tricky situation where we have a server with a default and an instance.In the default we have 4 databases

for example (A,B,C,D) and we mirror them to...

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

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

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

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering], but I still want a...

Not knowing anything about Oracle, I can tell you that there is a problem with the way the data is being translated between the two (numbers are getting cut off)....

If you have multiple queries trying to update the same table that is...