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

cumulative permissions for all his roles in the database.

so public + other roles + specific user permissions + server permissions

the 3 status of any permission are

GRANT - tick

DENY - cross

REVOKE - empty

is the user on the new server a member of other databases ? was he on the last...

have you installed new network cards ?? are network cards load balanced ??

have you tried connecting to the server via TCP/IP ?

i have had something similar when using multiple NICS...

yes,

i agree on the latter points there - data Marts (or warehouses) should give you nice fast reports based on snapshot data, whilest freeing up your tables for faster...