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...

just thinking ahead - you may have to use OPTION (MAXDOP,1) in there somewhere - it may get a bit confused with the union on the same table.

not sure whether...

Select Col1, Col2, Sum(Col3)

From

(

Select Col1, Col2, Col3 from T1

UNION

Select Col1, Col2, Datediff(HH, Col5, Col6) as COL3 From T1

)

group by Col1, Col2

i think that should do it