this sounds a little like the SQL service account may not have the relevant permissions for command executed by xp_cmdshell

although it's just a wild stab in the dark

i'd also suggest the following change

CREATE TRIGGER InsteadUPDATERegistrationTrigger on Registration

INSTEAD OF UPDATE

AS

if update(username)

begin

if (select inserted.username...

jeff,

i'm not sure why you're using triggers for this - can't you just put a unique constraint on the username field?

that would be a lot simpler

my advice from recent experience with asp(.net) is to use Stored procedures to retreive data and update data

your stored procedure to update the tables could easily perform multiple update statments...

is this via enterprise manager, query analyser etc?

if so (and i'm assuming that the server IP address hasn't changed, protocols haven't been disbled and that ther are no problems with...

Thanks for your help on that one -

i had planned to paste these as stored procedures, but for the purposes of development i've used sql until the customer approves...

thats exctly what i was looking for (if Not Page.IsPostback Then)

you are correct on all counts, it is visual studio 2003 (i'm usually a c++/vb developer, so asp.net has a...

ok, below is the page load sub.

I think the problem is that the dataset is filled on page, load, which is overwriting any changes when the page is posted.

i've...

if you remove the database name from the ODBC connection string or ODBC settings then set the default database for those logins to be SDE1, sDE2 etc -

those users...

so we're all agreed - there isn't a good reporting solution that does it all and is cheap/easy to deploy

hint hint microsoft - there appears to be a gap...

just a though here, (and please feel free to contradict me)

it might be a quick and easy performance upgrade to ensure your t-log files and data files are on seperate...

maybe if "out for justice" could post us some info about his setup we could be a little more specific about what may be the easiest way to squeeze some...

Bills right there -

crystal is so buggy (or was) that access 2000 was always better for a report generator than crystal could ever be

but still give reporting services a try...

Chris,

my apologies - i didn't word it very clearly

what i actually meant was that range partitioning and snapsot isolation "should" in theory be transparent to your application code and...

i'm not sure why you're in such a mood scking, but basically i was saying

choose a solution that meets the scale of the problem

i agree with some of your...