FWIW - I really hate MS Access to begin with.

-ldb

I don't think this is possible. SQL Server has the ability to listen on multiple ports, but I don't know of a way for it to listen on multiple IP...

You're not alone.

This is a good reason why you'd want to archive your tran log before you perform the database backup.

You really don't need to have the next archive log file...

Hi Atiq,

There is only a 16-file limit using sp_attach_db. You can still use the CREATE DATABASE FOR ATTACH syntax.

-ldb

Before a decision is made either way, you need to consider scalability.

Let's assume the function is complex - requiring multiple database queries and you're building an interactive app. Can you afford the network traffic sending...

Where do you guys find the time to code in either environment?

I agree with Guus, using the NOT EXIST is more accurate (what happens when [column 0] is nullable?).

Try a query such as:

Talltop

When you start paying for SQLServerCentral.com then you have the right to complain. Until then just appreciate that someone has taken the time to collect and publish these QODs.

Lighten up..

Oh - and by the way, if you try reattaching the DB through Query Analyzer, the error message will tell you specifically that the disk drive is not a dependency....

Yes, but there is a dependency in the process - you must take the SQL Server resource offline to add the dependency, so the criticality of steps is to add...

You miss the point. Restarting the SQL Server resource, in itself, does nothing. Only by making the Disk resource a dependency of SQL Server does it become visible.

Do you mean enforcing the name or automatically naming the FKs?

Dinesh,

In your forward-engineer options, you need to check the option to use Quote Names. You can find it in the 'Other Options' group of options.

-ldb

Just to add to bhunter1, the only time you'd get that would be if you removed Builtin\Administrators from the System Administrators server role. We, in fact, do delete the Builtin\Administrators...