Here's my first guess, and it's probably right:

when they are coming thru your UI, they are using a different login than when they connect vi SSMS....

if i connect with user...

i think it's Vista;

compared to XP, where every login was also an admin, didn't Vista remove some rights you might expect by default for security purposes? so your login...

do you mean something other than using sp_who or sp_who2?

post the query.

you might be suffering from parameter sniffing, where an execution plan is built on an assumption by the Query optimizer about one or more of the parameters;...

i think what you are looking for is using a CASE and sum together to get the value you are after;

here's a the core example:

[font="Courier New"]SUM(CASE WHEN A.Trans_Type_ID IN ('Reversal',...

15 seconds is a long time, unless it is fiddling with billions of records.

post the query itself so we can see, maybe a missing join or something is killing performance.

saving...

on a similar issue, if you want to drop a FK on a column, but don't know the actual FK constraint name, i made the proc below...

you simply call

EXEC DROP_FK_FROM_SPECIFIC_COLUMN...

the error tells you exactly which line to go to to fix it....

it's pure syntax:

Msg 102, Level 15, State 1, Procedure SP_ResetCreditLimit, Line 32

Incorrect syntax near 'UPDDATE'.

Update is misspelled. remove...

i use something like this, involving an ORDER BY featuring a case statement:

i want nulls at the end, but non-numerics at the beginning;

ORDER BY

CASE WHEN ISNULL(Yourfield) = 1...

if you add the access database as a linked server, you can treat it as any otehr table...

so you could SELECT...INTO NEWTABLENAME FROM ACCESS:

for example, if you created a linked...

yes, but he needs the same WHERE clauses in his subsequent inserts/updates to his other three tables....so I thought he needed the comparison for the later SQL's....

same thing, different island,...

actually, thinking about it some more, the table could be updated, but the status was already 3...

for exmaple, if a NOTES field was updated int eh table, but the status...

your issue is you are locked into thinking about one row at a time:

you think the trigger will affect one and only one row, and that you can grab a...

here's a sample trigger doing what you want....note it is assuming the update has more than one row occurring, so all the operations are set based on the virtual INSERTED...

yeah i carry the advanced version on a flash drive now that I've downloaded it;

i had a problem with VS 2005 installing; It would only install if i explicitly skipped...