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

the only way i can see to do this is by seperating your stored procedures off into a seperate database.

you can then drant DDL to your developers for the...

what exactly do you want to do with COM, what languages are you looking to develop in???

also consider that .NET is now the logical replacement for COM

have a look at NetIQ's products

they will check out index sizes, database sizes, statistics, fragmentation etc over a perfiod of time and give you some nice trend graphs.

they have...

so what you're asking really is -- is there a way to detect whether it's BST or not from the current date? and then apply a date modifier if it...

can you post an example of the data - sureley you just need to use dateadd(hh,1,[date]) and dateadd(hh,-1,[date]) to go backwards and forwards one hour ???

have you tried diabling TCP/IP and using another protocol to test ?

first of all you're going to have to identify all of the duplicate surnames in your primary table and also all of the equivalents in your import table.

if you set...

there are several tools to do this - although i've found that the best way to do this is to us a bit of VB and use an ADO connection...

a - time for a joke about servers running FLAT out...

sorry