it's always the little things that cost the largest amounts of time; I've gotten zapped like that when i was playing in case sensitive databases.

an extra pair of eyes helps...

i always move the data in FK Hierarchy order; it makes sense when you look at it today, and 6 months from now when you add other tables.

stored procedure is...

you'll need to paste the trigger in question, so we can see what the issue is.

it's not obvious, but the table definition says 'eeo'_Classification, but the insert is 'ee0'_Classification

so the chars look the same, but the "O" is not the same character "0" in...

if you can provide the actual CREATE TABLE statements, and a few rows of sample data, we could really help a lot better.

off hand, i think you'll update table2 before...

psuedo code wastes your time and mine...give us the specifics so we can help with specific answers.

1. Import the table [message]from server a to server b

--are you doing this to...

you can do it by comparing the COLUMNS_UPDATED function to see if specific columns have changed, and only let the trigger run if that is true; it uses a bitmask...

one of Florian's many points is this:

SQL server does not natively have a rollback after x seconds functionality. because a database needs to preserve ATOM-ocity, it's an all-or-nothing scenario,...

definately use some of the log trolling tools out there...i think RedGates SQL Log Rescue for SQL 2000 is/was free, so something like that or profiler are your best bets.

i...

correct me if I'm wrong, but the character after the '-'(A,B etc) is the screen...so if you get that substring, you could check for the charindex on each user:

try joining...

i mapped this out for fun; i reversed engineered by comparing the values to all my serves(8 total in my db) for the first 10 columns, the values seem...

you want to use MAX() to get the highest values,sum() to add stuff, and group by the items that you want to...well..group by. something like this:

select

max(id),dpid,cabid,max(stlid),joid,sum(qty)

from your table

group by dpid,cabid,joid

Rad...

use the search in the upper right for "script user permissions"

there are like ten different versions of scripts in the contributions section that does exactly this;

this is the one i...

if you search for "count all rows", there are like 10 different versions of this script in the contributions.

there's two ways to do it:

use the indexes to get the counts,...

in your example above, you mentioned only specific fields, that would be grabgbed based on foreign keys:

Orders.OrderID, Orders.CustomerID, Customer.CustomerID, Customer.Name, Orders.ProductID, Products.ProductID, Products.Name

that is nothing more than a view which...