The last post was good advise. Every company has different needs. You need to research the options - and there are a lot of them.

I have worked with...

Is there a good reason? Yes, having admin permissions can be a security issue and could be a problem with separation of duties.

You do not "need" to be a...

The licenses you purchase does not limit the number of processors the software actually uses. Cores do not count as individual processors.

The temp table was so I had some sample data and schema. The select statement against your table should work on it's own.

In theory...

[font="Courier New"]CREATE TABLE #MyTable (GroupCode CHAR(1), Num INT)

INSERT #MyTable

SELECT 'A',1

UNION SELECT 'A',2

UNION SELECT 'A',3

UNION SELECT 'B',1

UNION SELECT 'B',2

UNION SELECT 'B',3

UNION SELECT 'B',4

UNION SELECT 'C',1

UNION SELECT 'C',2

SELECT CASE WHEN Num...

I tend to create groups in Exchange (assuming you are using Exchange). Then it is only a single email address to send a message to everyone.

You are going to want to reinstall the SP and all patches anyway. You will probably not want to risk anything not being at the same patch level.

So I...

Save a copy of your SSIS package while it is broken and then again once you have "refreshed" your connection and then compare the two packages (they are just XML...

You cannot use a variable as part of an object name.

If you post what you are specifically trying to do, we can probably give you some pre-tested code.

You should also...

Yup - thanks Gail - better to use the new schema.

I think this does what you want:

[font="Courier New"]BEGIN

DECLARE @rt INT, @dummy INT

...

SELECT min(login_time) FROM Master..Sysprocesses

MS SQL has a process that is always running - so the minimum login time for any process is when the service started.

MS Access is like anything else. If you use it for what it is designed for, it works pretty well.

Jello is great as a snack, but an awful building...

I am not sure what you mean. The client you were planning to use does use an SMTP server of some sort. It may be a local one...

I am not familiar with it, but if it is this one:

http://caspian.dotconf.net/menu/Software/SendEmail/

it is an SMTP mail client. I am not sure how you would benefit from using this over...