Eric M Russell (1/4/2017)

---

As a side note, it would be great if all valid codes could be pre-loaded into a primary keyed master table, then data validation could be enforced...

polkadot (1/4/2017)

---

Installation of Microsoft Access Database Engine 2010 Redistributable completed. Went back to trying to import excel file:

IMPORT WORKED!

Now, I found the below the best configuration for importing

1....

komal145 (1/4/2017)

---

I have Firstname , firstname 1 , firstname 2 ,firstname3

If firstname is null thne firstname1 , if firstname1 is also null then Firstname2 ...will the case will work ?

Case...

Phil Parkin (1/4/2017)

---

mandavli (1/4/2017)

---

is there any pre-existing alert that I can use or do I need to create a script? if so then which tables shall tell me of what's...

Just to double check, is this what you're trying to install? Microsoft Access Database Engine 2010 Redistributable

mcfarlandparkway (1/4/2017)

---

Then how I have to create error in the function?

how this function will fail? I am trying to create this eror condition inside the function.And this func is calling...

Also, when you say "User", do you actually mean user, or do you mean login (or even both)? These are not the same thing in SQL, and it surprises me...

Brandie Tarvin (1/4/2017)

---

Thom A (1/4/2017)

---

I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is acceptable. The...

I don't believe there is an alert for this no.

You could use triggers. For users you would need to put a trigger on each database you want to check for...

I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is acceptable. The hyphen is after the...

Glad it's not just me, however, I'm actually running 13.0.16000.28,so a more recent version. Unless, of course, they added the "feature" back -_-

This really depends on what your trying to do.

I, for example, have to use XML to pass any data to our CRM. Although the CRM does have a SQL database...

I'm assuming that the OP is using SQL Server 2016 (as they recently upgraded)?

You'll need to install Visual Studio 2015, and then install SSDT, which you can find here.

Once installed,...

Install the x86 drivers, and give it another try. Excel connections (at least 2014 prior), only worked with 32 bit drivers, not 64 bit. I don't know about 2016 (I...

wendy elizabeth (1/3/2017)

---

In ssrs reports I have never ," encapsulate your code in IFCode Markup. For example .

Would you give me an example of what you are referring...