Andrew (8/19/2009)

I like this format as well, since that's essentially what IP addresses are anyway. Like...

I have to admit the four tiniyints was my first idea but I realized the limitations imposed by that solution immediately, yes its human readable, so what, add the function...

Look into merge join in data flow components..

CEWII

From a previous employer, they own it, but that is how I did it before..

I have been meaning to rewrite them and put them up on CodePlex..

CEWII

You might want to go about this in a different way where you have a sproc do a dir on a directory and get the data and store it. ...

Jeff,

I partially agree with your post, I have had to buy Enterprise because there were features I needed, your points are also valid about hardware and utilization but if...

Using SSIS isn't the problem, using some drivers can be a problem with 64-bit, but they can be overcome by forcing packages to run as 32-bit on a 64-bit server.....

Perhaps, that could explain it..

CEWII

Wayne is right on track with the SSIS problem with anything using MS-Jet drivers.

However, if you use any custom extended stored procedures you may have a problem.

CEWII

In the dev environment I would say mentoring is important with an eye towards security. In the production environment data protector is the most important..

CEWII

I would go with no, the statement cannot finish until the trigger finishes. I'd look for "Process Delegation Workbench" on the simple talk site at:

http://www.simple-talk.com/sql/t-sql-programming/process-delegation-workbench/

To handle the access outside...

Are these really highly desired (practically used) install features not available in Standard edition?

- Partitioning, More CPUs supported, Fast Recovery, Indexed View Matching, Parallel processing of indexing operations, Online...

WLBS really isn't a high availability path for SQL. Clustering, DB Mirroring, and Log shipping are. I am unsure if you were referring to one of these?

CEWII

I'm not familiar with SID service accounts.

Are you talking about windows integrated security?

If so then you will need your users on an AD domain or a AD domain trusted by...

DTS is a depracated technology in SQL 2005/2008, I wouldn't expect them to continue to support it...