it covers most of the things in the BPA, and the baseline security analyser, but also a few other things all in one package.

with the manually written recommendations it also...

i can't see how, perhaps it may allow you to change it. depends on how your services are set up

if they are set up to run under local admin or...

there is little linux utility disk that you can download from the internet.

boot from the disk and it will discover your local admin passwords and accounts from windows machines....

heh...

update VT_MailInfo set Inf_EmployeeNo=(select Pers_EmployeeNo from VT_PersonelData where Pers_FirstName= @FirstName and Pers_LastName=@LastName and inf_DUP_MAIL=1<-----THIS BIT HERE ???)

because it's a dial up or onsite service offered by our company to identify possible problems or areas of improvement.

international phone calls and flights tend to be a little more...

I'd be very tempted to replicate out to the branches. the only issue here is that your liscencing costs will quite high.

what kind of quantity of data will be stored...

we've done this before -

basically you have to create a trigger on insert for the table - if the datalength of the IMAGE field is 0 then call a...

Cunning

this won't let them modify the SPs though - only execute

on this front have a look at

http://www.go-l.com/servers/index.htm

to get some inspiration for servers - but i'd advise Xeon 3.2 2mb cache to get best performance

permissions on a view or Stored procedure do not infer permissions on the table they access - you need to specify permissions for the supplying object as well.

it's better to...

Prefixing anything other than SP_ should help - you should avoid doing this anyway due to certain query plan execution problems.

I'd be tempted at ASP_ to get them at the...

or unless they're in Sytem administrators group (or a member of local or domain ADMINS for the builtin/admins)

the SA role and login will override all DENY statements

This one's simple enough- there's no TRANSFORM or PIVOT functions in SQL - these are access functions.

it is possible to make a pivot table, but you have to do...

have a look at http://www.sql-server-performance.com/dbcc_commands.asp

there should be some good explanations there