You could write an executable installer that accepts a servername and credentials as inputs and then writes the sprocs to the server itself. The end-user could still profile that...

If you are looking for a partition scheme you could use a hybrid of what you were proposing. Previous years either in a single partition, or in a yearly...

My first thought is UAC in 2008. I'm not sure what app yo are running but if it has a GUI that you are trying to access you might...

That second sentence seems pretty clear to me, I don't think they will be able to use that second processor legally without additional licensing..

CEWII

I would take off the [002 Shipments Table]. it isn't really needed, since the from clause only specifies a single table.

As far as cut and paste, wellllllll, I don't know...

You could disable the foreign keys using something like:

ALTER TABLE dbo.cnst_example NOCHECK CONSTRAINT fk_salary_cap;

ALTER TABLE dbo.cnst_example CHECK CONSTRAINT fk_salary_cap;

CEWII

You are welcome.

CEWII

I completely agree guys, I was only bringing up processor affinity for performance reasons, not licensing but the licensing discussion is really good too..

CEWII

That is generally a true statement, you won't be able to do a DB backup and restore back on a 2000 box, but it will generally behave the same.

I would...

SQL 2005 and 2008 Express do not allow external conenctions by default, however, that is not a problem, they deploy this way for security reasons. In SQL 2005 you...

Also, I remember something about hyperthreading and sql being a bad thing.. You might want to use processor affinity to only use REAL cores or turn HT off entirely.

CEWII

I was reading your post and wondered if you meant database files instead of tempdb's because there is only one tempdb for an instance of sql, you might have more...

I would come at it an entirely different way..

I wold built an SSIS package to handle this.

If possible I would query the hire dates directly using a lookup dataflow component..

my...

Tell us about your SQL server, architecture, amount of memory, other processes on that machine, etc.

CEWII

If you run the package outside of BIDS does it work? Or does it still error out?

Did you set delayed validation at the package level or just the component...