If you guve the user a form and have them enter the location (or browse) from VB, you can open and access the package and it's objects from VB. Save...

Not sure about the technical specs, but it shouldn't use a lot more power or heat to you. It might be more heat, but I'd be surprised if you noticed.

Server...

Please show us your work and what you are having issues with. This does indeed sound like homework.

To other posters, please don't post answers to people's homework. This is a...

I'd do it your way strictly for security. This way they're just adding "data".

Usually you'd do the metadata in CustomFieldTypes. Maybe an ID, a data type, a tablename or owner...

Not this?

insert into ....

values (@partno, '00', ...

)

_ is a wildcard as well.

select * from ..sysusers. See if it's there

Nigel,

Is this SQL Server Standard or Enterprise? If it's standard, you won't get the memory higher than it is. If it's not, then you need more memory. The cache hit...

Maybe I should expand a little. You can't be ignorant of technology, but you don't have to be able to write SQL queries to manage SQL Server DBAs.

You get explanations...

There are always little bugs and things that they include for tuning. I see a couple hot fixes a month, but most don't apply to me. However it would be...

Haven't tried, but if you post some DDL And code and explain where you're having issues, maybe we can help.

No logging for SELECTs, you are correct in that.

For the continuous selects, likely the data will remain in cache in memory, if it's the same or similar data, and you...

I'd also get rid of the t1.* and t2.*. If you're looking for matches, just get the PKs in the select list and then use that list to get the...

I'd recommend you try it with a regular login, maybe db_writer/reader in the db and see what happens. I've had a few of these applications "require" SA, but only one...

I wish. Unfortunately, too often people don't read the sticky things. I have to admit that on other sites I've missed them as well and restorted to asking an question...