For that, I make the OrderID an internal column the users never see. This way, they'll never update it. Then, for the foreign key, specify Enforce Foreign Key Constraints and...

Do you then build in index on the "foreign key" column, or does the foreign key constraint take care of that?

Just rescued me! I had one stuck in single user mode. Don't know how it got that way, but now it's fixed.

The End of the Matter:

ALTER PROCEDURE [dbo].[StartBookingReminders]

-- Add the parameters for the stored procedure here

@RunsEvery Int,

@ServerName VARCHAR(30),

@DatabaseName VARCHAR(128)

AS

BEGIN

Exec dbo.StopBookingReminders

exec msdb.dbo.sp_add_job @job_name = 'CS-Booking_Reminders',

...

I tried adding msdb.dbo.sp_add_jobserver to my start procedure

ALTER PROCEDURE [dbo].[StartBookingReminders]

-- Add the parameters for the stored procedure here

@RunsEvery Int,

@ServerName VARCHAR(30),

@DatabaseName VARCHAR(128)

AS

BEGIN

Exec dbo.StopBookingReminders

exec msdb.dbo.sp_add_job @job_name =...

Nope. The job isn't running. I don't find it listed in the sysjobhistory list, though it is in the sysjobs table.

Oh. I get it... The users can specify their phone number and carrier as an email address and then database mail will work.

http://en.wikipedia.org/wiki/SMS_gateway#SMS_to_Skype

Scroll down about 1/2 way.

Hmm. That's interesting, though not quite...

Maybe I just want to give the customers the option of having it text them...

Looks like what I really want is to send SMS messages....

Here's what I did when somebody installed the server themselves and didn't remember what they put for the password...

I used the Server Management thingy to log in using windows authentication....

Given that there are only a couple dozen options here, I'm using a big CASE.

I was just figuring that out 😀 MS kindly thinks I shouldn't be using EXEC inside a function...

I thought I'd simplify the task of writing a big stored proc by...

Who ate the figures?

All I get is blue boxes :crying:

I like that view idea. Simpler than the format file. I also find that on some installations, the order of the columns in the database might be different. View will...

Apparently, you just leave a blank in your text file between the tabs;)

That works! I knew I'd done that, but if I hadn't solved the problem in another 10 minutes, I'd have written my own UDF;)