It's kind of intuitive once you understand it's just a support hierarchy.

1st level support is typically the person that answers the phone or email, but may be more customer service...

yeah, not directly configurable without turning on advanced options.

i think this is what you are after:

[font="Courier New"]

--advanced options get enabled

sp_configure 'show advanced options', 1;

GO

RECONFIGURE

GO

--'user connections' 0=unlimited,...

it's kind of easy...

in your case, you only care about the time portion of any date....not the date itself.

so you ADD the number of seconds to an arbitrary date,

then one...

i meant here on SqlServerCentral.

Teh script ssections contains thousands of script contributions to do a variety of things; there's at least half a dozen to help you scritp out your...

search the scripts section for "generate scripts"; there are plenty of examples there;

however, teh builtin stuff works great: rightclick on your db...tasks...generate scripts.

a wizard will appear and just tell it...

I've dealt with a couple of shared hosting providers.(ihostasp.net,godaddy.com)

They always give you an interface so you can run SQL statements, batches, etc...you just have to realize, in a shared...

well, SQL servers datetime datatype is only accurate to 3 milliseconds increments...so if you try to increment by milliseconds it goes from 0,3,6,9 all the way up to 997

to preserve...

import and export of any kind, where thru the Management Studio or SSIS, are only part of Standard,Enterprise and Develoepr editions; they are not included in the freebie versions.

your best...

going back to your specific issue....the Service Broker job can be scheduled to run every minute...

say you have a trigger that puts an event in the new Tracking table instantly...that's...

I guess you missed my point; you can have a trigger that does whatever the trigger needs to do. no problem.

but that is separate from an email notification that...

you probably have it open in Access to look at the data at thesame time you are trying to access it via code:

It is already opened exclusively by another...

I don't think you need a trigger for htis....you need a tracking table to determine whether an email should be, or has already been sent.

if the table you have to...

when you create a foreign key, you can add the extra commands ON UPDATE CASCADE ON DELETE CASCADE, and then changes to teh parent will automatically propigate to the foreign...

doh i should have thought of that...edited.

I took some spanish in school, but living in South Florida, I get to struggle with it a bit, just enough to try and...

ok, now as best as i can figure, you wanted to update one specific row, where QuestionID='1773', with the sum of all the Answer_Int for a group of specific questions.

i've...