It appears you are guessing the extension of the file.

If you open up the D:\ drive in windows explorer, go to the directory you have listed, then right click on...

Ed Wagner (2/17/2014)

---

dwain.c (2/16/2014)

---

Ed Wagner (2/13/2014)

---

dwain.c (2/13/2014)

---

I guess it is...

EdVassie (2/17/2014)

---

SQL 2012 Enterprise is only licensed by Core. If you think you are using CAL licenses with EE then you may not be correctly licensed.

SQL 2013 BI and...

SQLRNNR (2/14/2014)

---

Or...

Oooooppsss, I see I missed the extra from in the upper query.

Help improves when you post scripts for table structures and some sample data, along with the select statement.

Usually when you get multiple records, a join is missing.

Assuming all your tables are the same SQL to Access, you should be able paste into a new query in SQL view and run it.

TOP 1 with no Order By...

Haven't done this before, but it looks like it is supported.

See TechNet for details.

Under Upgrade How to Topics, you will see more details.

Sean Lange (2/4/2014)

---

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started...

You might want to read this.

Might be helpful just to compare what the vendor says vs. your setup.

You also need to account for the application server, similar to looking at SQL Server and the resource needs.

If both are on the same VM, you are putting all the...

I would look at what else is running on the VM.

Are they reserving resources for your instance?

Also reading from disk to memory.

You are in a shared environment, so you need...

Revenant (2/3/2014)

---

SQLRNNR (2/3/2014)

---

Grant Fritchey (2/3/2014)

---

Please, please, please, no piling on, but I'm curious what you guys think about this: Unreasonable Defaults. I think most of the fundamental info is fine....

You mention the core issue - front end with no entry validation.

And understand that it is an ever growing guessing game.

Also that you have several different issues, and may have...

Double edged sword putting logic in server names.

Get it wrong or have a server that has multiple roles and it doesn't work so well.

Some indication of location (especially for printers)...