I work as a programmer/DBA for a college, and you'll definitely want to go with a single database for many reasons.

Aside from all the technical reasons, schools seem to require endless...

Perfect! Thank you!

While we're at it ...

When I click on "Users That Need Help" links in the daily emails, the first click brings me to the forum page containing the question referenced...

In Jonathan's post, he advised against dynamic SQL.  Is this a blanket statement?  Should dynamic SQL always be avoided?

Dana

When in doubt, just use parentheses to force precedence.  Remember:

Please Excuse My Dear Aunt Sally

P (arentheses)

E (xponents)

M (ultiplication)

D (ivision)

A (ddition)

S (ubtraction)

If you're using dynamic SQL, you could substitute CHAR(39) for the single quote, CHAR(91) for the left bracket and CHAR(93) for the right bracket, as follows:

------------------------------------------------------

DECLARE...

"Hey Dude, Where's My Country?" is excellent.  And rent a copy of "Bowling For Columbine" while you're at it.

How hard is it to emigrate to the UK if you're from...

Access has a Crosstab query feature that should provide you with the exact report that you want. Go to the Queries tab, click New, and choose Crosstab from the...

I'm one of those developer/systems analyst/help desk/DBAs in a very small office, and about the only areas I'm NOT involved in are web design and the network. So obtaining DBA...

Thought I answered that ... SQL Server 7, Service Pack 2. The server itself is Windows 2000 Advanced Server 5.0.

We're running Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

HELP!

We're runnning SQL Server 7.0 on an dedicated Windows 2000 Advanced Server. For some reason this server NEVER seems to release any memory. No matter what action is performed...

I type about 65 wpm on a QWERTY keyboard. Learned typing on a manual typewriter in summer school back in the 70's.

A few years ago I decided to try...

I'm running a SQL 7 database with a similar "mystery" memory leak. The machine (Windows 2000 Advanced Server) is only used for SQL Server and nothing else. Access...