The profile specifies the email that the message come FROM. If you want to send to more than one recipient, you can specify more than one email address in...

You can do that. There are some difficulties associated with that. But we would be trying to stay away from dynamic SQL. This also opens the process...

SQL Does the work it is sent to do, and the work it is sent to do is controlled by Access. But if your front-end is querying linked tables...

You can often minimize it by making sure that you set aside enough memory for the OS. This all depends on what else you have running and how much...

The reason all the tables had dbo was that was the table owner.

I'm guessing that the reason you are getting terrible performance is that the access engine is doing all...

For reports that are run with a defined set of parameters every week you might consider data driven reports.

CEWII

SELECT SERVERPROPERTY('LicenseType')

Mode of this instance of SQL Server.

PER_SEAT = Per Seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.

Base data type: nvarchar(128)

Well you can't do it quite that way, but you can accomplish the same thing using SYNONYMs.

A synonym is very much like an alias. You could create a synonym...

GilaMonster (10/4/2009)

---

Elliott W (10/4/2009)

---

The only right answer is a valid answer, "I don't know" or a crap answer will almost certainly be a disqualification for anything other than a junior...

RBarryYoung (10/4/2009)

---

No, as the table grows, it becomes clearer and clearer that temporary tables outperform table variables....

Grant Fritchey (10/4/2009)

---

Usually, when someone crosses the line, I just walk away. This time, I've got to say something. There's no way you can interview for a senior level position...

Yet even more agreement with Jeff. Big files stored in SQL is just not the best solution. Link in SQL pointing to the file is the best solution..

CEWII

I thought I was agreeing..

But I was also making a larger point about there being lots of factors that controls how it will perform..

As the table grows is...

Paul White (10/3/2009)

---

Elliott W (9/23/2009)

---

As far as logical reads of a table variable.. Keep in mind that if they are not too big they will probably reside fully in...

Then you would have to change it for the whole group that is allowing...