If myUserResponse = "" Then

Main = DTSTaskExecResult_Failure

exit function

End If

This gets both the case where the user enters nothing and the case where they hit cancel. If you...

sp_changeobjectowner can be used to change the owner.

Lori

If you have successfully run the job, shut down EM and re-open it. I've had it act flaky in the past.

Lori

Elno,

I ran the create table statement (you have one column in there twice, so I deleted it), then the three alter table statements. The code completes successfully. What...

What you're most likely experiencing is called a broken ownership chain. To prevent this, objects in a chain should be owned by the same user (e.g. table and view...

indid = 0 means it is a heap structure.

Lori

I created a database and added tables. I created a login that had no permissions on the database, then logged in. The user was unable to access the...

You can use the sp_addalias 'login_name', 'name_in_db' syntax to add a user and alias that user to dbo. That user must not currently exist in the database if you...

Try right-clicking jobs in EM, then click refresh.

Lori

Rita,

I just posted a script that will determine the latest backup completion time. The title is "Script to determine backup finish times".

DECLARE @FinishDate datetime

SELECT @FinishDate = MAX(backup_finish_date)

FROM...

I also tested the constraint statement, and it worked successfully for me. If the constraint actually existed, your error message would have been "there is already an object named...

Elno,

The reason you can't drop the constraint and you can enter data that violates the constraint is that the constraint was never created. When you said you were trying...

Melissa,

Create a blank Access database (or you may just use an existing database). In the DTS Wizard (DTS Export Wizard), after you select the source, on the destination screen,...